Ab Initio ETL Developer
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- Ab Initio Developer having 10+ years of hands-on experience
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
Analyze and document the existing Ab Initio ETL ecosystem, including its workflows, transformation logic, business rules, and data dependencies. Guide HANA developers in migrating that logic to SAP HANA Stored Procedures and validate that the new implementation produces equivalent results.
Requirements
Requires 10+ years of hands-on experience as a senior Ab Initio developer, including the ability to analyze and execute existing ETL workflows and document their logic and lineage. Candidates should also be able to advise HANA developers, troubleshoot migration issues, and assess scripts, dependencies, and conversion challenges.
Skills
- Ab Initio
- ETL Development
- SAP HANA
- Stored Procedures
- Data Transformation
- Data Mapping
- Data Lineage
- Workflow Orchestration
- Unix Shell Scripting
- ETL Migration
- Baseline Testing
- Troubleshooting
- Performance Analysis
- Business Rules Documentation
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Consulting
Keywords
- Ab Initio
- ETL
- SAP HANA
- Stored Procedures
- Graphs
- Workflows
- Transforms
- Plans
- Business Rules
- Transformation Logic
- Data Mappings
- Data Lineage
- Upstream Dependencies
- Downstream Dependencies
- Unix Shell Scripts
- Wrapper Scripts
- Parameter Files
- Workflow Orchestration
- ETL Migration
- Baseline Outputs
- Data Validation
- Troubleshooting
- Performance Considerations
- Scheduling Dependencies
- Execution Sequences