Senior Test Lead - Data Quality & ETL Expert (Hybrid)

Rubicon Path; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading technology company in Toronto seeks a Test Lead Senior to design test strategies, mentor a team, and ensure data quality across ETL workflows. The ideal candidate will have extensive experience in SQL and data warehousing concepts, with a proven track record in managing testing activities. This role offers a hybrid work arrangement, requiring a minimum of 3 days per week at the office.

Qualifications

• Extensive experience in relational databases and advanced SQL skills.
• Awareness of data quality, integrity, lineage, and compliance.
• Ability to guide, mentor, and manage a team of testers.

Responsibilities

• Lead the design of test strategy, plans, and procedures.
• Verify the accuracy and integrity of data in ETL workflows.
• Collaborate with cross-functional teams to ensure data quality.

Skills

Extensive experience in relational databases and SQL

Data Warehousing Concepts and Data Governance

Crafting comprehensive test strategies

Guiding and mentoring a team

Strong SQL skills

Data validation techniques

Test management tools knowledge

Agile methodology understanding

Tools

Selenium

JIRA

Azure DevOps

Job description

About the job RQ08114 - Test Lead Senior

Responsibilities:

· Lead the design of test strategy, plans, scenarios, scripts, or procedures for testing

· Responsible for verifying the accuracy and integrity of data being processed in ETL workflows

· Experience initiating the specification, preparation, implementation and execution of tests, monitor the test results and check the exit criteria

· Experience introducing suitable metrics for measuring test progress and evaluating the quality of the testing and product.

· Experience providing input to test automation strategy, test automation framework roadmap

· Experience selecting tools to support testing and organize any training in tool use for testers

· Experience writing test summary reports based on the information gathered during testing.

· Experience leading / providing guidance to team members

· A team player with a track record for meeting deadlines

SkillsExperience and Skill Set Requirements

Please note this role is part of a Hybrid Work Arrangement and resource(s) will be required to work at a minimum of 3 days per week at the Office Location.

Must haves:

Extensive experience in:

· Relational databases and advanced SQL skills for querying and verifying data

· Data Warehousing Concepts and Data Governance: Awareness of data quality, integrity, lineage, and compliance

· Crafting comprehensive test strategies and plans specific to data projects.

· Ability to guide, mentor, and manage a team of testers.

Technical Skills (75%)

· Strong SQL skills to validate data, query large datasets, and perform complex joins

· Experience with database management systems (e.g., SQL, Oracle, NoSQL) and data formats (e.g., XML, JSON).

· Experience with data validation techniques, including data profiling and data quality assessment

· Experience with data modeling and data warehousing concepts and methodologies

· Ability to analyze data sets to ensure data quality and integrity

· Understanding of data governance and compliance standards related to data handling.

· Experience with manual and automated testing processes and tools

· Experience with functional testing of large scale enterprise systems undergoing transformation or being built from scratch

· Experience in developing automated test scripts using different tools such as Selenium

· Experience with designing, developing, and maintaining test cases based on industry best practices and standards

· Experience with manual test execution and defect reporting, testing of various types of integration technologies

· Experience with test management tools (e.g., JIRA, Azure DevOps) for tracking testing activities

· Knowledge of Agile methodology and ceremonies

· Experience with AODA testing

Leadership and communication: 25%

· Good team collaboration, documentation, problem solving and communication skills

· Excellent leadership and team management skills to oversee QA activities.

· Strong communication skills to convey data quality issues and solutions to stakeholders.

· Ability to collaborate with cross-functional teams to ensure data quality standards are met.

· Strong analytical and problem-solving skills to identify data quality issues and trends.

· Ability to develop and implement data quality metrics and KPIs.