Role: Ab Initio ETL Developer
Location: Downtown, Toronto – Hybrid
Contract Role
Job 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 the migration of 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:
- Sr. Ab Initio Developer having 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.
