Senior Systems Testing/QA Specialist

We are seeking an experienced Senior Systems Testing/QA Specialist with deep database testing expertise to lead data quality assurance and ETL validation for enterprise digital reporting solutions. In this role, you will be responsible for defining test strategies, developing comprehensive test plans, and validating complex data warehouse, data migration, and monitoring and evaluation reporting pipelines. Leveraging hands-on proficiency with complex SQL scripting, relational databases (SQL Server and Oracle), and enterprise ETL tools such as Informatica, you will verify data transformations, execute functional and integration tests across GUI and backend layers, and collaborate with cross-functional technical teams to ensure data integrity and delivery excellence.

Location: Toronto, ON (Hybrid – up to 3 days onsite at hiring manager's discretion)

Duration: 4-month contract.

Advantages
Targeted Data Focus: High-visibility backend data validation and reporting test execution.

Modern Hybrid Work: Flexible schedule with up to 3 days onsite in Toronto.

Modern Testing Tooling: Hands-on test management and execution within Azure DevOps and enterprise ETL engines.

Collaborative Team: Work alongside dedicated data architects, business analysts, and development teams.

Responsibilities
Provide expert guidance on overall testing strategy, master test plans, tool selection, and QA resource estimates.

Plan, organize, and execute testing across Graphical User Interface (GUI) and non-GUI backend environments, including functional, integration, system, regression, and user acceptance testing (UAT).

Author detailed test plans, test scenarios, test cases, and test execution records within Azure DevOps (ADO).

Develop and execute complex SQL scripts involving multi-table joins, nested queries, and aggregations to validate backend data integrity and ETL transformation rules.

Perform manual testing, debugging, and data reconciliation using Informatica (or equivalent ETL tools) to verify extraction, transformation, and loading accuracy.

Analyze business requirements documents (BRDs), user stories, data models, and source-to-target mapping specifications to design robust test coverage.

Build and maintain requirements traceability matrices to ensure complete alignment between business specifications, test assets, and verified defects.

Identify, document, and triage software defects and data anomalies, collaborating with developers, data analysts, and solution architects to resolve issues.

Generate QA test summaries, defect metric dashboards, and release readiness reports for project leadership and stakeholders.

Qualifications
Advanced SQL Scripting: 5–7 years of proven, hands-on experience authoring comprehensive SQL scripts to analyze backend databases and validate complex data logic (Strictly Required).

ETL Testing Tooling: 3–5 years of dedicated testing experience with Informatica ETL tools or equivalent enterprise ETL platforms (Strictly Required).

Data Warehouse & Migration Projects: Proven experience conducting quality assurance within enterprise Data Warehouse (EDW) and complex data migration environments (Strictly Required).

Database & Architecture Concepts: Strong understanding of relational database structures and concepts across SQL Server and/or Oracle, including procedures, views, and data schemas (Strictly Required).

Requirements & Traceability: Solid experience interpreting user stories, BRDs, and data mapping specifications, alongside managing test assets in tools like Azure DevOps (Strictly Required).

Nice-to-Have Assets:
Prior testing or quality assurance experience within a public sector or healthcare environment.

Basic knowledge of Unix/Linux shell scripting, navigation, and command-line job execution.

Experience with IBM InfoSphere DataStage or related data integration engines.

Familiarity with CRM systems (such as Siebel) or enterprise cloud platforms (Azure or AWS).

Summary
If you're interested in the "Senior Systems Testing/QA Specialist" role based in Toronto, we encourage you to apply online at www.randstad.ca.

Only qualified candidates will be contacted for the next steps. We look forward to hearing from you!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [email protected] to ensure their ability to fully participate in the interview process.

This posting is for existing and upcoming vacancies.