ETL Developer

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

Job summary

Capgemini Bengaluru is seeking a skilled Ab Initio Developer to design and build complex data processing pipelines. The ideal candidate will have deep expertise in Ab Initio features, including metadata-driven development and orchestration through Plans and ConductIt.

You will design high-performance graphs, implement advanced data transformations, and develop reusable code with PDL and metaprogramming, while optimizing performance and troubleshooting bottlenecks in enterprise environments.

Qualifications

• Full lifecycle ETL development using Ab Initio.
• Proficiency with core components Rollup, Scan, Join, Partitioning and Normalize.
• Hands-on experience with Vectors, PDL and Metaprogramming for metadata-driven frameworks.
• Experience designing and executing Plans and ConductIt workflows.
• Knowledge of ExpressIt for business rules and template management.

Responsibilities

• Design and develop high-performance Ab Initio graphs and pipelines.
• Implement complex data transformations using Ab Initio features.
• Build dynamic, reusable code using PDL and metaprogramming techniques.
• Orchestrate enterprise workflows with Plans and ConductIt.
• Optimize graph performance and troubleshoot data bottlenecks.

Skills

ETL development

Ab Initio components

Vectors

PDL

Metaprogramming

Plans

ConductIt

ExpressIt

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