Ab Initio - ETL Developer
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
Analyze and document existing Ab Initio workflows, graphs, transformations, business rules, data mappings, and end-to-end data lineage. Support migration of ETL logic to SAP HANA by collaborating with developers, troubleshooting defects, and identifying conversion and performance considerations.
Requirements
The role calls for mid-senior experience analyzing Ab Initio ETL processes, workflows, and associated Unix scripts and parameter files. It also requires the ability to interpret complex transformation logic, understand data dependencies, and support migration to SAP HANA; no education requirement is stated.
Skills
- Ab Initio
- ETL Development
- SAP HANA
- Stored Procedures
- Data Lineage
- Data Mapping
- Business Rules Analysis
- Unix Shell Scripting
- Workflow Orchestration
- Troubleshooting
- Performance Analysis
- Data Migration
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
- Consulting
Keywords
- Ab Initio
- ETL
- SAP HANA
- Stored Procedures
- Database Objects
- 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
- Troubleshooting
- Data Migration
- Performance Considerations
- Functional Dependencies
- Baseline Outputs