Ab Initio ETL Developer

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

Benefits offered by this job

Career progression

Competitive pay

Benefits plan

Referral program

Prestigious employer

Job summary

Adastra Corporation is seeking an experienced Ab Initio ETL Developer to design, build, and support enterprise-scale data integration solutions in a hybrid Toronto setting. You will translate business requirements into scalable data pipelines while ensuring data quality and operational stability.

Responsibilities include designing ETL graphs, optimizing workflows, and collaborating with analysts and architects.

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 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 GDE

Ab Initio Co>Operating System

Ab Initio EME

ETL design & development

Data integration

PDL & DML

Relational databases

ETL troubleshooting

Communication & collaboration

Tools

Autosys

Control-M

Ab Initio Control Center

Job description

Overview

Adastra is seeking an experienced Ab Initio ETL Developer to design, develop, and support enterprise-scale data integration solutions. This role is responsible for building, optimizing, and maintaining ETL workflows that enable reliable data movement across complex business systems. The successful candidate will work closely with business analysts, data architects, and technology teams to translate business requirements into scalable, high-performance data pipelines while ensuring data quality, operational stability, and efficient processing of large-volume datasets.

Primary Location: Toronto, ON

Work Model: Hybrid 3-Days Onsite

Employment Type: Permanent Full-Time

Vacancy Status: New

Compensation Range: $65,000 - 75,000 CAD

RESPONSIBILITIES

• Design, develop, and maintain ETL graphs using Ab Initio GDE (Graphical Development Environment)
• 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

QUALIFICATIONS, SKILLS & EXPERIENCE

• 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

NICE TO HAVE

• Experience with enterprise scheduling tools such as Autosys or Control-M
• Experience working within large-scale enterprise data warehouse environments
• Exposure to cloud-based data platforms and modern data architectures
• Experience with CI/CD and automated deployment processes
• Financial services or banking industry experience

ABOUT ADASTRA

Adastra is a global leader in AI and data-driven transformation, helping organizations lead with artificial intelligence—responsibly, strategically, and at scale. With over 25 years of experience, Adastra empowers enterprise clients to unlock business value through data innovation, operational excellence, and smart customer engagement.

Trusted by some of the world’s most prominent brands, Adastra delivers end-to-end solutions grounded in thoughtful strategy, robust governance, and deep technical expertise. From defining vision to ensuring execution, Adastra guides organizations through every stage of their AI, data and cloud journey—building future-ready capabilities and delivering measurable, lasting impact.

Adastra serves clients across key industries including financial services, automotive, manufacturing, technology, media and telecom (TMT), healthcare, retail, and professional services. The company employs more than 2,000 professionals across North America, Europe, and Asia.

WHAT WE OFFER

• Opportunity for advancement and career progression
• Competitive compensation package
• Comprehensive benefits plan
• Successful referral program
• The opportunity to work with one of Canada’s 50 Best Managed Companies
• Satisfaction of working for a reputable company
• A flexible, dynamic, and diverse workplace

EQUAL OPPORTUNITY EMPLOYER

In our commitment to promote fair and equitable treatment of all employees and applicants, Adastra Corporation provides equal employment opportunities for all individuals regardless of age, sex, disability, race, ethnic origin, citizenship, creed, sexual orientation, marital status, or any other ground as described in the Ontario Human Rights Code.In addition, accommodation will be provided during the hiring process. Adastra Corporation’s implementation and support of employment initiatives, encourage diversified labour force participation and equal access to opportunities based on merit and performance.