Client

The client is a Fortune 200 American holding company that operates multiple insurance and investment management businesses. The company is headquartered in Radnor, Pennsylvania, US.

Challenges

•  Migrate Informatica large volumes of ETL jobs from the on-premises data center to the AWS cloud effectively. 
•  Migrate Informatica workflows to AWS Glue seamlessly, minimizing the manual effort. 
•  Transfer mappings, transformations, and data dependencies to the AWS cloud, aligning with the customerʼs cloud-first strategy. 
• Manage complex data pipelines and maintain the scheduling requirements.
• Ensure cloud best practices are followed. 

LTM Solution

• Created a proprietary migration accelerator to automate the migration of Informatica workflows to AWS Glue with minimal human interventions.
•  Utilized an intelligent parser to analyze and migrate existing ETL business logic to AWS Glue, retaining the mapping, transformations, and data dependencies.
•  Implemented a configuration-based solution, allowing flexibility for customers to change the source and target definitions post-migration.
•  Managed complex data pipelines, enabling manual customization of transformations and the inclusion of non-functional directives.
• Leveraged LTM Scarletʼs ETL migrator to convert ETL jobs to AWS, achieving approximately 50% automation in the conversion process.

Business Benefits

• Achieved approximately 30% in time and cost savings through the automation-enabled ETL migration.
• Ensured scalability and flexibility by leveraging AWS Glue’s scalable infrastructure for large data processing.
• Achieved a seamless transition from Informatica to AWS Glue.