The Opportunity
We are currently seeking a Senior Quality Assurance Engineer with expertise in Data and ETL testing to join our team in the Canadian Sector Technologies & Platforms consulting group. This is an exciting opportunity to play a key role in transforming businesses by ensuring the integrity, accuracy, and performance of their data systems. As part of our technology team, you’ll work on high-impact projects with clients across industries, using cutting-edge tools and methodologies to drive digital transformation.
This role offers the chance to work collaboratively with leading financial institutions and innovative companies, helping them navigate complex data challenges, enhance data quality, and ensure robust ETL processes. If you are an experienced QA professional with strong data testing and automation skills, we want to hear from you.
Your Key Responsibilities
As a Senior QA Engineer specializing in Data and ETL, you will:
- Lead the quality assurance efforts for data-driven solutions, ensuring the successful validation of data and ETL pipelines.
- Develop and execute comprehensive test strategies, plans, and cases for ETL processes, data transformations, and integrations.
- Work with stakeholders to define and understand data quality requirements, transforming them into actionable testing strategies.
- Implement and drive test automation for ETL processes using industry-leading tools and frameworks.
- Collaborate with data engineers, developers, and business analysts to identify potential risks and resolve data quality issues.
- Optimize data validation procedures to improve testing efficiency and accuracy.
- Document test results, report on quality metrics, and communicate findings with stakeholders, ensuring transparency in testing processes.
- Stay updated on emerging data technologies and incorporate best practices into testing methodologies.
Skills And Attributes For Success
- Strong understanding of data validation, ETL processes, and data architecture.
- Proficiency in SQL for data validation and transformation testing.
- Experience with data integration, warehousing, and cloud-based data platforms.
- Hands-on experience with ETL tools and frameworks to drive efficient data processing.
- Ability to apply data quality assurance practices to ensure data integrity and accuracy.
- Strong problem-solving skills with an analytical approach to identifying and resolving data issues.
- Effective communication and collaboration skills, able to work cross-functionally with business, development, and data teams.
- Ability to design and execute automated testing strategies to validate data accuracy and pipeline integrity.
Technical Skills:
- Proficiency in Python, SQL, or Java for data engineering and ETL processes.
- Extensive experience with ETL tools like Informatica, Talend, SSIS, or Apache Nifi.
- Hands-on experience with cloud platforms such as AWS, Azure, and Google Cloud for data storage and processing.
- Proficient in data warehousing technologies, including Amazon Redshift, Snowflake, and Microsoft Azure Synapse.
- 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.
- Experience using data visualization tools like Power BI or Tableau to create dashboards and reports.
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
- Familiarity with data visualization tools (e.g., Tableau, Power BI).
- Knowledge of CI/CD pipelines and how they relate to QA automation.
- Previous consulting or Big 4 experience is highly desirable.
