ETL Developer

Capgemini; Bengaluru; On-site; INR 1,100,000 - 2,300,000; Full time

Job summary

Capgemini is seeking an Ab Initio Developer to design and build complex data processing pipelines. The role requires deep expertise in Ab Initio features, including metadata-driven development and orchestration through Plans and ConductIt.

You will design and optimize high-performance graphs using core components, implement advanced data transformations, and develop reusable frameworks with PDL and Metaprogramming. Strong focus on orchestration and ExpressIt for business rules.

Qualifications

• Thorough development experience in full-lifecycle ETL using Ab Initio.
• Expert-level mastery of core components Rollup, Scan, Join, Partitioning, Normalize.
• Hands-on experience with Vectors, PDL, and Metaprogramming to build metadata-driven frameworks.
• Extensive experience designing and executing Plans and ConductIt workflows.
• Functional knowledge of ExpressIt for business-rule implementation and template management.

Responsibilities

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

Tools

Rollup

Scan

Join

Partitioning

Normalize

Vectors

PDL

Metaprogramming

Plans

ConductIt

ExpressIt

Job description

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