We are looking for an experienced Ab Initio Developer to design, build and optimize large-scale ETL pipelines for our [banking/insurance/retail] data platform. You will work closely with data architects, business analysts and QA teams to deliver reliable, high-volume data integration solutions.

Key Responsibilities:

- Design, develop and unit-test Ab Initio graphs, plans and sub-graphs using GDE and Co>Operating System
- Build and maintain generic, parameterized (PDL) and reusable components for scalable data ingestion and transformation
- Work with EME for version control, dependency analysis and code promotion across environments
- Write and tune complex SQL against [Teradata / Oracle / DB2 / Snowflake]; optimize joins, partitioning and data parallelism for performance
- Develop Unix/Linux shell scripts for job orchestration, file handling and automation
- Schedule and monitor batch workflows using [Autosys / Control-M / Conduct>It]
- Perform root-cause analysis and production support for job failures,



data quality issues and SLA breaches
- Participate in code reviews, prepare design/technical documentation and support UAT and release activities
- Collaborate with stakeholders in Agile/Scrum ceremonies and provide accurate estimates

Required Skills

- 5+ years of hands-on ETL development with Ab Initio (GDE, Co>Op, EME)
- Solid command of Ab Initio components Partition/Departition, Rollup, Scan, Join, Reformat, Normalize, Lookup, Continuous Flows
- Strong SQL and RDBMS concepts; experience with [Teradata/Oracle] utilities (BTEQ, FastLoad, MultiLoad) is a plus
- Proficiency in Unix/Linux shell scripting
- Solid understanding of data warehousing concepts — dimensional modelling, SCDs, CDC, star/snowflake schemas
- Experience with job schedulers and production support in a 24x7 batch environment
- Good analytical, debugging and communication skills

📌 Abinitio Developer (Hyderabad)
🏢 Capgemini
📍 Hyderabad