Senior Quality Engineer - Data & ETL

Senior Quality Engineer - Data & ETL

Date: Apr 3, 2025

Job Type: Permanent
Work Model: Hybrid
Reference code: 128944
Primary Location: Toronto, ON

Our Purpose

At Deloitte, our Purpose is to make an impact that matters. We exist to inspire and help our people, organizations, communities, and countries to thrive by building a better future.

What will your typical day look like?

As a Senior Quality Engineer specializing in ETL Testing, you will:

• Lead the quality assurance activities for data-centric solutions, ensuring data and ETL pipelines are effectively validated.
• Create and implement detailed test strategies, plans, and cases for ETL processes, data transformations, and integrations.
• Work with stakeholders to identify and define data quality requirements, turning them into practical testing strategies.
• Establish and manage test automation for ETL processes using industry-standard tools and frameworks.
• Collaborate with data engineers, developers, and business analysts to identify risks and resolve data quality concerns.
• Refine data validation procedures to boost testing efficiency and precision.
• Record and report on test outcomes, quality metrics, and communicate results to stakeholders to ensure clarity in testing processes.
• Stay informed about new data technologies and incorporate best practices into testing methodologies.

About the team

Enough about us, let’s talk about you

• Deep knowledge of data validation, ETL processes, and data architecture.
• Expertise in using SQL and NoSQL for data validation and transformation testing.
• Experience in data integration, warehousing, and cloud-based data platforms.
• Practical experience with ETL tools and frameworks to facilitate efficient data processing.
• Capability to implement data quality assurance practices to maintain data integrity and accuracy.
• Strong analytical and problem-solving abilities to identify and resolve data issues.
• Excellent communication and collaboration skills, with the ability to work effectively across business, development, and data teams.
• Proficiency in designing and executing automated testing strategies to ensure data accuracy and pipeline integrity.

Technical Skills:

• Proficiency in Python (libraries such as PySpark & Pandas), SQL, or NoSQL for data engineering and ETL processes.
• Hands-on experience with cloud platforms such as AWS, Azure, and Google Cloud for data storage and processing.
• Strong knowledge of relational databases (MySQL, PostgreSQL, SQL Server) and NoSQL databases (MongoDB, Cassandra).
• Experience with big data tools such as Apache Hadoop, Spark, and Kafka for distributed data processing.
• Familiarity with version control systems like Git and CI/CD processes for automating data workflows.
• Expertise in data validation, quality assurance, and data profiling techniques.

To Qualify for the Role, You Must Have

• 5+ years of experience in Quality Assurance, focusing on data and ETL testing.
• Proven expertise in designing and executing complex data validation tests for large-scale data systems.
• Experience working in fast-paced, Agile environments and delivering high-quality results under tight deadlines.

Ideally, You’ll Also Have

• Knowledge of CI/CD pipelines and how they relate to QA automation.
• Knowledge of API Testing.
• Ability to mentor junior Quality Engineers.

Nice to Have

• Performance Testing Knowledge: Understanding the concepts and methodologies around performance testing, including load testing, stress testing, and scalability testing.

Total Rewards

The salary range for this position is $58,000 - $96,000, and individuals may be eligible to participate in our bonus program.