ETL Developer

Capgemini; Chennai District; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Capgemini is seeking a highly skilled Ab Initio Developer to design and build complex data processing pipelines. You will work on metadata-driven development and orchestration through Plans and ConductIt to optimize performance across large ETL workloads.

The role focuses on implementing advanced Ab Initio features, crafting reusable code with PDL and Metaprogramming, and ensuring robust data processing across the enterprise environment.

Qualifications

• 5–13 years of full-lifecycle ETL development using Ab Initio.
• Expert-level mastery of Rollup, Scan, Join, Partitioning and Normalize.
• Hands-on experience with Vectors, PDL, and Metaprogramming to build metadata-driven frameworks.
• Extensive experience designing and executing Plans and ConductIt workflows.
• Knowledge of ExpressIt for business-rule implementation.

Responsibilities

• Design and develop high-performance Ab Initio graphs.
• Implement complex data transformations using Vectors and multi-level lookups.
• Develop dynamic, reusable code using PDL and Metaprogramming.
• Orchestrate workflows using Ab Initio Plans and ConductIt.
• Optimize graph performance and troubleshoot data bottlenecks.

Skills

Ab Initio ETL

Data Modeling

Tools

Ab Initio

Rollup

Scan

Join

Partitioning

Normalize

Vectors

PDL

Metaprogramming

Plans

ConductIt

ExpressIt

Job description

Location: Bangalore/Pune/Hyderabad/Chennai

Experience Level: 5 to 13 Years

About the Role

We are seeking a highly skilled Ab Initio Developer to design and build complex data processing pipelines. The ideal candidate will possess deep expertise in advanced Ab Initio features, including metadata-driven development and orchestration through Plans and Conduct>It.

Key Responsibilities

• Design and develop high-performance graphs utilizing core Ab Initio components: Rollup, Scan, Join, Partitioning, and Normalize.
• Implement complex data transformations using Vectors and multi-level lookups.
• Develop dynamic, reusable code using PDL (Parameter Definition Language) and Metaprogramming techniques.
• Orchestrate enterprise-level workflows using Ab Initio Plans and Conduct>It.
• Optimize graph performance and troubleshoot complex data bottlenecks.

Required Technical Skills

• Thorough Development Experience: Proven track record in full-lifecycle ETL development using Ab Initio.
• Core Components: Expert-level mastery of Rollup, Scan, Join, Partitioning, and Normalize.
• Advanced Features: Hands-on experience with Vectors, PDL, and Metaprogramming to build generic, metadata-driven frameworks.
• Orchestration: Extensive experience designing and executing Plans and Conduct>It workflows.
• Express>It: Functional knowledge of Express>It for business-rule implementation and template management.

#AbInitio #ETLDeveloper #DataEngineering #BigData #ConductIt #Metaprogramming #DataWarehouse #Hiring #TechJobs #DataArchitecture #ExpressIt #DataIntegration