Ab Initio Developer
- Toronto, ON, Canada
$55 to $60 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $55 to $60 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
Pay Range: CAD 55-60/hr
Experience Required: 6-8 Years
Role Descriptions:
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
Serve as the subject matter expert for the existing Ab Initio ETL ecosystem, analyzing and documenting its workflows, transformation logic, business rules, and data lineage. Guide HANA developers in migrating the logic to SAP HANA stored procedures, and validate that the new solution produces results equivalent to the existing implementation.
Requirements
The posting seeks a senior Ab Initio developer with 10 or more years of hands-on experience and the ability to analyze Ab Initio graphs, workflows, transforms, plans, scripts, and ETL processes. Candidates should be able to document data flows and rules, guide SAP HANA conversion, troubleshoot migration issues, and assess dependencies and performance considerations.
Skills
- Ab Initio
- ETL
- SAP HANA
- Stored Procedures
- Data Lineage
- Data Mapping
- Business Rules
- Unix Shell Scripting
- Workflow Orchestration
- ETL Migration
- Troubleshooting
- Performance Analysis
- Data Validation
- HANA Database Objects
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Consulting
Keywords
- Ab Initio
- ETL Ecosystem
- SAP HANA
- HANA Stored Procedures
- ETL Migration
- Ab Initio 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
- Baseline Outputs
- Data Validation
- Job Execution
- Migration Defects
- Performance Considerations
- Scheduling Dependencies
- Execution Sequences
- Database Objects