Roles &
Responsibilities
Design, develop, and maintain Ab Initio ETL workflows and complex data integration solutions.
Develop and optimize Ab Initio graphs using GDE, DML, PSETs, and standard Ab Initio components.
Perform data extraction, transformation, validation, reconciliation, and loading from multiple source systems.
Work with Oracle/relational databases and write complex SQL queries for data processing and validation.
Develop Unix/Linux shell scripts for file processing, automation, job execution, and operational activities.
Analyze and resolve production issues, perform root-cause analysis, and provide permanent fixes.
Perform ETL performance tuning using partitioning, parallelism, sorting, joins, and other optimization techniques.
Coordinate with business analysts, data architects, QA teams, and other development teams to understand requirements and deliver solutions.
Participate in code reviews, unit testing, integration testing, deployment, and release activities.




Support production deployments and troubleshoot batch/job failures within defined SLAs.
Maintain technical documentation, data mappings, and process specifications.
Mentor junior developers and provide technical guidance on Ab Initio development and best practices.

Must-Have Skills
Ab Initio ETL / GDE solid hands-on experience developing complex graphs and workflows.
Ab Initio DML &
Components

– solid knowledge of Reformat, Rollup, Join, Scan, Sort, Partition, Normalize, etc.
Advanced SQL &
Database

– complex SQL queries, joins, stored procedures, data validation, and query optimization.
Unix/Linux &
Shell Scripting

– solid command-line and scripting experience for ETL automation and troubleshooting.
Performance Tuning &
Production Support

– experience with parallel processing, partitioning, optimization, job monitoring, debugging, and production issue resolution.

📌 Abinitio Developer Hyderabad
🏢 CGI
📍 Hyderabad