Ab Initio Developer

Adastra is seeking an experienced Ab Initio 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: $75000 - $85000 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 intelligenceresponsibly 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 worlds 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 journeybuilding 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 2000 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 Canadas 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 Corporations implementation and support of employment initiatives encourage diversified labour force participation and equal access to opportunities based on merit and performance.

AI Usage - Our hiring process includes the use of AI-enabled tools to screen applications (e.g. keyword matching qualification ranking). A human recruiter reviews all AI-generated shortlists to make informed hiring decisions.

There has been an increased instance of fraudulent job offers coming from people posing as Adastra HR employees. Please note that Adastra will never request fees as part of our recruiting process and any emails sent to you that are not from @ or @ are fraudulent. All employment offers are sent via DocuSign and if you receive an employment offer from a suspicious email and not via DocuSign it is fraudulent.

Contact to inquire about jobs at Adastra to report a suspicious request for money or personal information from external websites or suspicious employment offers.