Ab Initio Developer
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
Analyze and document the existing Ab Initio ETL ecosystem, including its workflows, transformation rules, data mappings, and dependencies. Guide HANA developers in migrating the logic to SAP HANA Stored Procedures and validate that the new implementation matches the existing outputs.
Requirements
The role requires extensive hands-on Ab Initio experience, with the posting specifying 10+ years in its required skills section. Candidates should be able to analyze Ab Initio workflows and scripts, document data lineage and business rules, and support migration troubleshooting and validation.
Skills
- Ab Initio
- SAP HANA
- ETL
- Stored Procedures
- Data Lineage
- Business Rules Documentation
- Data Mapping
- Unix Shell Scripting
- Workflow Orchestration
- ETL Migration
- Data Validation
- Troubleshooting
- Performance Analysis
- Scheduling Dependencies
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Consulting
Keywords
- Ab Initio
- SAP HANA
- ETL
- Stored Procedures
- Graphs
- Workflows
- Transforms
- Plans
- Data Lineage
- Business Rules
- Transformation Logic
- Data Mappings
- Unix Shell Scripts
- Wrapper Scripts
- Parameter Files
- Workflow Orchestration
- Database Objects
- Baseline Outputs
- Job Execution
- Data Validation
- Migration
- Scheduling Dependencies
- Execution Sequences
- Performance Considerations
- Upstream Dependencies
- Downstream Dependencies