Data QA

TEKsystems•Waterloo, ON

3d•CA$70 - CA$70•Hybrid

About The Position

This Data QA role will work on our Client Care Portal project, where they will perform QA from the Data perspective. They will work on our data platform in Synapse.

Requirements

SQL
Azure Synapse
JSON file format knowledge/experience and asset
Power BI
excellent documentation/communication
experience with creating test plans (including master test plans and reviewing with stakeholders)
addressing blocks/defect with the PM/Developers
excellent understand of the QA lifecycle
Azure Synapse / cloud data platform exposure
JSON and structured data validation
Strong QA lifecycle expertise (test planning, execution, defect management)
Experience with ETL/data pipeline testing
Excellent documentation and communication skills
Ability to operate as a self-starter / “go-getter” within a fast-moving environment
Familiarity with tools such as Azure DevOps or JIRA

Responsibilities

Design, develop, and execute ETL and application test strategies, test plans, and detailed test cases based on business requirements, user stories, and technical design documents.
Perform end-to-end data and application testing, including data validation, data completeness, data integrity, transformation logic verification, and reconciliation between source and target systems.
Execute SQL-based validations to ensure accuracy and consistency of data across databases, data stores, and reporting layers.
Validate data pipelines and integrations using modern platforms and tools (e.g., Azure-based services), covering functional, system integration, regression, smoke, and sanity testing.
Develop and execute automated test scripts for data and application validation, including reusable checks for record counts, column-level validation, data types, and transformation rules.
Participate in requirement analysis, design walkthroughs, sprint planning, and agile ceremonies, providing quality-focused input throughout the delivery lifecycle.
Identify, log, track, and manage defects using Azure DevOps or JIRA, ensuring timely retesting, verification, and closure.
Support UAT and production validation activities, including investigation and resolution of production support tickets in collaboration with business and technology partners.
Communicate defects, risks, and quality metrics clearly to team members and stakeholders, supporting efficient defect resolution.
Provide technical guidance and mentoring to peers, contributing to consistent testing practices and continuous quality improvement.
Identify opportunities to improve testing processes, workflows, and efficiencies, and assist in maintaining quality standards and documentation.
Review and validate structured data formats (e.g., JSON, CSV, flat files) used for integrations and feed
Ensure testing considers regulatory, compliance, and control requirements relevant to data privacy, auditability, segregation of duties.
Validate that sensitive client and financial data is handled according to security and access standards.
Support audit and control activities by providing test evidence and traceability when required.