Abinitio Developer

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 strong hands-on experience developing complex graphs and workflows.
2. Ab Initio DML & Components – strong knowledge of Reformat, Rollup, Join, Scan, Sort, Partition, Normalize, etc.
3. Advanced SQL & Database – complex SQL queries, joins, stored procedures, data validation, and query optimization.
4. Unix/Linux & Shell Scripting – strong command-line and scripting experience for ETL automation and troubleshooting.
5. Performance Tuning & Production Support – experience with parallel processing, partitioning, optimization, job monitoring, debugging, and production issue resolution.