Ab Initio ETL Developer

We are seeking a highly skilled Ab Initio ETL Developer with strong hands-on experience in designing, developing, and optimising scalable data integration and processing solutions. The ideal candidate will possess deep expertise in Ab Initio, strong SQL/database development skills, and a proven track record of building high-performance ETL pipelines in enterprise data environments., * Design, develop, and implement scalable ETL workflows using Ab Initio, ensuring optimal performance and reliability.

• Build, enhance, and maintain Ab Initio graphs utilizing components such as Reformat, Join, Partition, Sort, Rollup, Lookup, and other core transformations.
• Leverage GDE (Graphical Development Environment) for efficient ETL development, testing, debugging, and deployment.
• Develop complex data transformation logic while ensuring data accuracy, consistency, and integrity across multiple systems.
• Integrate ETL solutions with relational databases using advanced SQL programming techniques.
• Optimize ETL processes for performance, scalability, and maintainability.
• Troubleshoot production issues, perform root cause analysis, and resolve data-related problems.
• Collaborate with data architects, DBAs, business analysts, and other stakeholders to deliver data integration solutions.
• Support deployment, monitoring, performance tuning, and maintenance of data pipelines across multiple environments.
• Ensure compliance with data governance, security, and data quality standards.

• Strong hands-on experience with Ab Initio ETL Development.
• Expertise in:

• Ab Initio Graph Development
• Ab Initio components and parallel processing concepts
• GDE (Graphical Development Environment)

• Strong experience with SQL and relational databases such as Oracle, Teradata, SQL Server, or similar platforms.
• Solid understanding of Data Warehousing concepts, ETL architecture, and best practices.
• Proven experience designing, developing, and optimizing ETL workflows.
• Experience integrating ETL solutions with enterprise databases and large-scale data processing systems.
• Strong troubleshooting, debugging, and performance tuning capabilities., * Experience working in distributed, high-volume, and large-scale data environments.
• Exposure to Unix/Linux shell scripting and enterprise scheduling tools.
• Familiarity with cloud platforms such as AWS and/or Azure.
• Experience supporting data migration, modernization, or transformation initiatives.
• Knowledge of Agile/Scrum methodologies.

Soft Skills

• Strong analytical and problem-solving skills.
• Excellent verbal and written communication abilities.
• Effective stakeholder management and collaboration skills.
• Ability to work independently in a fast-paced, deadline-driven environment.

Nice to Have

• Experience with Continuous Graphs and real-time data processing.
• Exposure to data quality frameworks and metadata management tools.
• Prior experience in Banking, Financial Services, or large enterprise environments.