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.