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

1. Ab Initio ETL / GDE solid hands-on experience developing complex graphs and workflows.

2. Ab Initio DML &
- Components

– strong 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

– strong 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