ETL Developer

Capgemini; Pune District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Capgemini is seeking an experienced Ab Initio Developer to design and build complex ETL pipelines across multiple centers in India. You will work on high-performance graphs using core Ab Initio components and contribute to scalable data integration initiatives within a fast-paced consulting environment.

The ideal candidate will master metadata-driven development, vectors, PDL, and Metaprogramming, and will orchestrate enterprise workflows with Plans and ConductIt.

Qualifications

• Full lifecycle ETL development using Ab Initio.
• Core components mastery: Rollup, Scan, Join, Partitioning, Normalize.
• Hands-on with Vectors, PDL, and Metaprogramming for metadata-driven frameworks.
• Experience designing and executing Plans and ConductIt workflows.
• ExpressIt knowledge for business-rule implementation.

Responsibilities

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

Skills

Ab Initio

ETL development

Data transformation

Vectors

Metaprogramming

Plan & ConductIt

Tools

Ab Initio

ExpressIt

PDL

ConductIt

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