Senior Ab Initio ETL Engineer — Hybrid Toronto

Adastra; Markham; Hybrid; CAD 65,000 - 75,000; Full time

Benefits offered by this job

Competitive compensation package

Comprehensive benefits plan

Career progression opportunities

Referral program

Flexible, dynamic workplace

Job summary

Adastra seeks a seasoned Ab Initio ETL Developer to design, build, and optimize enterprise ETL workflows in a hybrid Toronto setting. You will collaborate with analysts and architects to translate business requirements into scalable data pipelines and ensure data quality across large datasets.

Ideal candidates bring 5+ years with Ab Initio, GDE, EME, and strong debugging skills, with experience across databases, flat files, and APIs.

Qualifications

• 5+ years of experience developing ETL solutions using Ab Initio.
• Strong hands-on experience with Ab Initio GDE, Co>Operating System, and EME.
• Experience developing and optimizing large-scale data integration and transformation processes.
• Strong knowledge of Ab Initio components, including partitioning, sorting, joins, rollups, and lookups.
• Experience writing and maintaining PDL and DML.
• Experience working with relational databases, flat files, APIs, and other enterprise data sources.
• Strong understanding of data warehousing, ETL, and data integration best practices.
• Experience implementing data quality controls, error handling, and logging frameworks.
• Strong troubleshooting, debugging, and root cause analysis skills in production environments.
• Ability to translate business requirements into technical designs and scalable ETL solutions.
• Strong communication, collaboration, analytical, and problem-solving skills.

Responsibilities

• Design, develop, and maintain ETL graphs using Ab Initio GDE.
• Build and optimize ETL processes that integrate data from databases, flat files, mainframes, and APIs.
• Develop Ab Initio components including partitioning, sorting, joins, rollups, and lookups for large-scale data processing.
• Write and maintain reusable, parameterized graphs using PDL and DML.
• Tune ETL workflows for performance, scalability, and efficient resource utilization.
• Manage metadata and version control using Ab Initio Co>Operating System and EME.
• Implement data quality controls, error handling, rejection processing, and logging within ETL workflows.
• Collaborate with business analysts and data architects to translate business requirements into technical solutions.
• Schedule, monitor, and support batch jobs using Ab Initio Control Center or enterprise scheduling tools.
• Troubleshoot production issues, perform root cause analysis, and resolve data pipeline failures.
• Participate in code reviews, testing, deployments, and release activities.
• Document technical designs, data lineage, ETL workflows, and graph specifications.

Skills

Ab Initio

Ab Initio GDE

Co>Operating System

EME

Large-scale ETL

PDL and DML

Relational databases

APIs and flat files

Tools

Autosys

Control-M

Job description

Adastra seeks a seasoned Ab Initio ETL Developer to design, build, and optimize enterprise ETL workflows in a hybrid Toronto setting. You will collaborate with analysts and architects to translate business requirements into scalable data pipelines and ensure data quality across large datasets.

Ideal candidates bring 5+ years with Ab Initio, GDE, EME, and strong debugging skills, with experience across databases, flat files, and APIs.