Cymetrix's data engineers, ETL Migration & data integration consultants possess exceptional problem-solving skills, data integration tool expertise (e.g. Talend, IBM Infosphere DataStage, and Databricks), SQL expertise, & high proficiencies in today’s advanced technology.
Sharing highlights of one of the Data Extraction/ETL projects below:
Completion date: 12 MAY 2020
CHALLENGE: The client decided to migrate its legacy ETL platform to Talend, it worked with Cymetrix’s data engineering experts to migrate data from IBM DataStage to Talend. To reduce its data center costs and improve the flexibility and scalability of its data management environment, this group decided to migrate its entire on-prem IT ecosystem to Amazon Web Services (AWS). The move to the cloud also prompted the company to migrate its data integration tool. Concerned about diminishing support for DataStage, they enlisted Cymetrix's ETL migration services to migrate to Talend.
SOLUTION: Cymetrix’s ETL migration experts approached the work in three phases: • Analysis: Analyzing, categorizing, and scoping the work
• Development: Converting ETL jobs from DataStage to Talend
• Testing: Testing of output across both platforms to compare results We migrated 300+ jobs to Talend and then compared output across the legacy ETL and Talend platforms. Throughout the effort, we collaborated closely with the Client’s cloud migration team to ensure the environment was set up on AWS for accurate testing. RESULTS: We successfully converted all ETL jobs to Talend, with great accuracy & seamless integration after completing thorough analysis, conversion & testing tasks. Moving to Talend helped the client to reduce ETL software licensing costs with access to a strong Talend Support team.