ETL Dev Lead (Ab Initio)

The ETL Development Lead is responsible for leading the design development and delivery of scalable end-to-end data pipelines that support enterprise data warehousing and analytics initiatives. As a hands-on technical leader this position drives best practices in ETL development ensures high-quality and reliable data solutions and provides mentorship and guidance to the development team. The role works closely with architects analysts and stakeholders to translate business requirements into robust data solutions while ensuring performance scalability and production stability.

Primary Location: Toronto ON

Work Model: Hybrid 3-Days Onsite

Employment Type: Contractor

Vacancy Status: New

RESPONSIBILITIES

• Lead the design development and maintenance of end-to-end ETL/data pipelines from source systems to data warehouse and data marts
• Provide technical leadership including code reviews standards enforcement and mentoring of ETL developers
• Design and implement scalable and efficient data transformations including cleansing aggregation and integration using AB Initio
• Develop and optimize complex SQL queries for high-performance data processing
• Oversee ETL job scheduling automation and monitoring using Unix and shell scripting
• Ensure data quality integrity and alignment with enterprise data warehouse standards and best practices
• Collaborate with architects analysts and business stakeholders to translate requirements into scalable technical solutions
• Support deployment QA/UAT testing and ensure stability and reliability in production environments
• Drive continuous improvement of ETL frameworks processes and performance

QUALIFICATIONS SKILLS & EXPERIENCE

• Bachelors degree in Computer Science Information Technology Engineering or a related field
• 5 years of work experience as an ETL Developer building and maintaining data pipelines
• Proven hands-on experience with AB Initio for ETL design development and data transformations
• Strong expertise in SQL including complex query development and performance tuning
• Solid understanding of data warehousing concepts including data marts and data modeling fundamentals
• Strong experience working in Unix/Linux environments with shell scripting for automation and orchestration
• Experience building and maintaining enterprise data pipelines (source staging data warehouse data marts)
• Strong debugging troubleshooting and root cause analysis skills across ETL workflows
• Demonstrated experience providing technical leadership mentoring or leading development teams
• Strong collaboration and stakeholder communication skills

NICE TO HAVE

• Experience in large-scale enterprise or consulting environments
• Exposure to cloud data platforms (e.g. AWS Azure)
• Familiarity with data governance data quality or metadata management frameworks
• Experience with additional ETL or data integration tools

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
• 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.