Ab Initio Developer

Ab Initio Developer Work Model: Hybrid – 3 Days in Office Location: Toronto Downtown Skills: Ab Initio Experience Required: 6–8 Years Role Description The Ab Initio Developer will act as the Subject Matter Expert (SME) for the existing Ab Initio ETL ecosystem and play a critical role in migrating ETL processing logic to SAP HANA Stored Procedures.

The individual will be responsible for analyzing and understanding the current Ab Initio implementation, documenting business and transformation rules, guiding HANA developers during the conversion process, and validating that the HANA solution produces results equivalent to the existing Ab Initio implementation.

Required Skills

Senior Ab Initio Developer with 10+ years of hands-on experience. Analyze and understand existing Ab Initio graphs, workflows, transforms, plans, and ETL processes. Execute existing Ab Initio workflows to generate baseline outputs for comparison. Review and document business rules, transformation logic, data mappings, and processing flows implemented within Ab Initio.

Understand end-to-end data lineage, including upstream and downstream dependencies. Provide technical guidance and clarifications related to Ab Initio design, architecture, and implementation. Collaborate with HANA developers to translate Ab Initio ETL logic into SAP HANA Stored Procedures and database objects. Support troubleshooting of job execution issues, data issues, and migration-related defects.

Assist in interpreting complex transformation logic and business rules embedded in Ab Initio code. Identify potential conversion challenges, performance considerations, and functional dependencies. Analyze Unix shell scripts, wrapper scripts, parameter files, and workflow orchestration components associated with Ab Initio processing.

Top 3 Nice-to-Have Skills Review HANA implementation to ensure alignment with the original Ab Initio processing logic. Review scheduling dependencies and execution sequences to ensure complete migration coverage.