Hiring ETL Automation QE in Toronto, ON

Job Title: ETL Automation QE

Location: Toronto, ON - Hybrid (4 Days WFO)

Duration: 06-12 Months

Job Description:

We are seeking a detail-oriented ETL Automation Quality Engineer to ensure the reliability, accuracy, and efficiency of our data pipelines. This role combines deep technical expertise in ETL processes, automation, and quality engineering to validate data integrity and system performance in a cloud-based environment.

Required Skills & Qualifications

• Expertise in SQL for data validation and complex querying.
• Proficiency in Python for scripting and automation.
• Hands-on experience with Unix/Linux, cloud platforms (AWS), Hadoop, Parquet, and AWS S3.
• Familiarity with GitHub for version control and collaboration.
• Proven experience in automated ETL testing frameworks.
• Strong communication skills to articulate technical issues and solutions to diverse stakeholders.
• Analytical mindset with a focus on quality and attention to detail.
• Understanding of QE principles, including test design, execution, and reporting.

Preferred Skills & Qualifications

• Experience with GitHub Actions for CI/CD pipeline automation.
• Knowledge of automated API testing tools (e.g., Postman, REST-assured).
• Familiarity with AI/ML tools (e.g., Copilot) for code optimization or data quality enhancements.
• Basic understanding of machine learning concepts as they relate to data pipelines.

Day-to-Day Responsibilities

• Design, develop, and maintain automated test frameworks for ETL workflows, ensuring data accuracy, consistency, and compliance with business requirements.
• Write complex SQL queries to validate data transformations, integrity, and quality across databases and data lakes.
• Implement Python scripts to automate testing, monitor pipeline performance, and generate reports on data quality metrics.
• Collaborate with engineering teams to integrate automated tests into CI/CD pipelines using GitHub and GitHub Actions.
• Manage data storage and retrieval processes in AWS S3, ensuring scalability and security.
• Apply QE methodologies to identify and resolve issues in ETL pipelines.
• Develop and execute test cases for API integrations and validate end-to-end data workflows.
• Document test strategies, results, and recommendations for process improvements.
• Work with cross-functional teams to troubleshoot data discrepancies and optimize ETL processes.

For immediate consideration please click APPLY to begin the screening process with Alex.