We are looking for a skilled ETL CP4D Developer to design, develop, and maintain scalable ETL processes. The role involvesworking closely with business teamsto extract, transform, and load data from various sources into target databases. The developer will be responsible for ensuring the efficiency and scalability of ETL pipelines and adhering to business logic.

Know your team :

At ValueMomentums Engineering Center, we are a team of passionate engineers who thrive on tackling complex business challenges with innovative solutions while transforming the P&C insurance value chain.

We achieve this through a strong engineering foundation and continuously refining our processes, methodologies, tools, agile delivery teams, and core engineering archetypes. Our core expertise lies in six key areas : Cloud Engineering, Application Engineering, Data Engineering, Core Engineering, Quality Engineering, and Domain expertise.

Join a team that invests in your growth.Our Infinity Programempowers you to build your career with role-specific skill development leveraging immersive learning platforms. You'll have the opportunity to showcase your talents by contributing to impactful projects.

Responsibilities :

- Design and develop CP4D jobs to extract, transform, and load data into data warehouses.

- Collaborate with business teams and data modelers to understand ETL requirements.

- Develop mapping documents and transformation rulesbased on source-to-target mapping.

- Handle large data volumes efficiently using IBM CP4D tools.

- Read files from AWS S3 buckets and load them into target databases.

- Perform unit testing and support performance testing of CP4D jobs.

- Create and maintain ETL testing documentation, including test cases, results, and issues.

- Work closely with cross-functional teams to ensure seamless data integration.

Requirements :

Must Have :

- 4 to 6 years of experience in IBM CP4D Tool and ETL engineering.

- Experience with SQL for Data Warehouse and Data Hub testing.

- Familiarity with AWS S3, Unix Scripting, and Oracle SQL.

- Experience with IBM DataStage