ETL (Extract Transform Load) techniques are used to merge, purge, cleanse, match and de-dupe the data. ETL also plays important role in handling old and legacy systems / raw data and resolving redundancies and inconsistencies. ETL typically takes 60% of any data warehouse development initiative.
ETL also plays key role in any data integration efforts that have become increasingly complex due to scores of applications that gets evolved as companies grow their business, acquire new businesses. In no time yesterday's cutting edge application becomes today's legacy application and needs to be integrated with the new systems till they get decommissioned.
Our ETL practice focuses on :
1. Provide ETL development resources with specializations in market leading ETL tools such as Informatica, Data Stage and Kettle (Pentaho).
2. ETL development that replaces existing custom ETL development (Shell scripts, C/C++, Perl, SQL loader, java or other other 2nd generation programming language) with any of the above ETL tools, simultaneously capturing the rich metadata about the ETL processes.
3. Conversion from one ETL tool (Informatica/DataStage) to another ETL tool(Data Stage/Informatica/Kettle).
4. Performance tuning of ETL/batch programs in any technologies.