Ab Initio Developer

About the role

This position focuses on software development and data engineering with an emphasis on ETL processes and Ab Initio technologies. The role involves designing, developing, testing, optimizing, and supporting complex data pipelines and transformation workflows across heterogeneous data environments.

Responsibilities

• ETL Development: Design, develop, and test complex Ab Initio graphs using the Graphical Development Environment (GDE) to extract, transform, and load data from heterogeneous sources.
• Data Processing: Implement data quality checks, data cleansing, and complex transformation logic within the Ab Initio pipelines.
• Performance Tuning: Monitor graph performance, identify bottlenecks, and optimize Ab Initio components for maximum efficiency and parallel processing.
• Scripting & Automation: Write Unix/Linux shell scripts for job automation, file manipulation, and scheduling integration (e.g., using Autosys or Control-M).
• Database Integration: Write and optimize SQL queries for relational databases (e.g., Oracle, Snowflake, PostgreSQL) to support data extraction and loading processes.
• Production Support: Assist in troubleshooting and resolving data discrepancies, pipeline failures, and performance issues in UAT and production environments.
• Documentation: Maintain technical documentation mapping data lineage, transformation logic, and architectural designs in compliance with data governance standards.

Requirements

• Required Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Required Qualifications/Skills/Experience: 3-6 years of hands-on software development and data engineering experience, with a heavy focus on ETL. Ab Initio Proficiency: Demonstrated experience building data pipelines using Ab Initio GDE, Co>Operating System, and Enterprise Meta>Environment (EME). Database & SQL: Strong proficiency in standard SQL and understanding of relational database concepts. Unix/Linux: Solid command-line skills and experience writing shell scripts. SDLC Knowledge: Understanding of the Software Development Life Cycle (SDLC) and Agile methodologies. Analytical Skills: Strong problem-solving abilities with a keen attention to detail and data accuracy.

Qualifications

• Desired: Hands-on experience in software development and data engineering with a strong focus on ETL.
• Preferred Qualifications/Skills/Experience: Experience with Ab Initio Continuous Flows, Express>It, or Control Center. Familiarity with the Hadoop ecosystem or cloud data platforms (AWS, Snowflake). Prior experience in the banking or financial services industry, particularly dealing with regulatory data or risk modeling.

Benefits

For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.