15 Nov
|
Capgemini
|
Bengaluru
15 Nov
Capgemini
Bengaluru
## Job highlights
- 5+ years ETL development experience with Ab Initio (GDE, Co>Op, EME), strong Ab Initio components knowledge, SQL and Unix/Linux shell scripting proficiency
- Design, develop and optimize Ab Initio ETL pipelines, build reusable components, write and tune complex SQL, automate workflows, perform root-cause analysis and production support, participate in code reviews and Agile ceremonies 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)
- Strong 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
- Valuable analytical, debugging and communication skills
📌 Abinitio Developer (Bengaluru)
🏢 Capgemini
📍 Bengaluru