Texas Instruments ATSS loader

Develop ETL algorithms using JAVA Spring to load 20 million rows data daily from HQ to data warehouse for further transformation and alteration. Complex data conversion and transformation done to achieve the requirements.

support

99%

of legacy system by ETL plugin

features

complex transformation
failure handling
cron jobs
email notification
data harvesting

what we’ve done

spring

+ java spring with mvc and aop concept

This programming language enable easy management of huge range of functionalities.

etl

+ extract transform & load

Program to extract 20 millions data daily from HQ and consolidate into data warehouse.

transformation

+ flexible data transformation

Supported customized flexible data transformation based on user needs.

automation

+ 100% synchronization automation

Cron jobs and email notification to track the daily data synchronization.

complex

+ complex MSSQL & ORACLE query

High complexity of MSSQL & Oracle database query to gather and transform related data.