Systems Testing/QA Specialist

Description

NOTE:

Assignment Type: This position is listed as Onsite; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location.

Extension/Amendment Attestation:

Extensions are permitted only to the extent of unused contract days and/or remaining contract funds. No additional funds will be added beyond the maximum contract value, including any extension options set out in the original SOW.

We

are seeking a highly skilled and detail-oriented Software Systems
Testing & Quality Assurance Specialist to join our project team. The ideal candidate will play a key

role in ensuring the reliability, performance, and integrity of our health

domain data platform. This role requires strong expertise in relational

database systems, SQL, and a solid foundation in software testing

methodologies. Experience with Python is a strong asset.

Key
Responsibilities

Design, develop, and execute comprehensive test

plans and test cases for the health

domain data platform.

Perform functional, regression, integration, and

performance testing.

Validate data engineering activities, ensuring data quality,

integrity and optimal performance.

Write and optimize complex SQL queries for data

validation and analysis.

Collaborate with developers, business analysts, and

stakeholders to understand requirements and ensure quality standards are met.

Identify, document, and track software defects using

appropriate tools.

Contribute to continuous improvement of QA processes

and automation strategies.

Provide clear and concise documentation and reports

on testing outcomes.

Experience Requirements

Public Sector Experience

5+ years of experience

working in the federal/provincial/broader public-sector in the field of

software systems development, testing or operations

5 points

Analytical and communications skills

Excellent documentation skills, including

the ability to produce clear and concise test plans, test cases, and test

summary reports.

• Strong

collaboration and communication skills, with the ability to work

effectively with cross-functional teams including business stakeholders, developers,

business analysts, architects and project managers.

Strong analytical skills to interpret test results, identify root

causes of issues, and recommend corrective actions.

20 points

Data management Skills & Experience

5+ years of experience in data

management

• Demonstrated experience in

designing, developing or maintaining relational database management systems.

• Strong

knowledge of relational database systems (e.g., SQL Server, Oracle,

PostgreSQL).

• Advanced

proficiency in SQL for data analysis and validation.

• Experience

with Python for scripting and automation is an asset.

25 points

Quality Assurance Skill & Experience

10+

years of experience in quality assurance and software system testing:

Extensive experience in software systems testing, including functional,

regression, integration, system, and performance testing across complex

enterprise applications.

Strong understanding of software development life cycle (SDLC) and quality assurance

methodologies, including Agile, Waterfall, and hybrid models.

Proficiency in test planning and strategy development, including risk-based

testing approaches and test coverage analysis.

Hands-on experience with test automation tools (e.g., Selenium,

PyTest) and scripting for automated test execution.

Expertise in defect tracking and management, using tools such as JIRA

or Azure DevOps, with a strong ability to triage and prioritize issues.

Ability to design and execute test cases based on business

requirements, technical specifications, and user stories.

Experience with API testing using tools like Postman, SoapUI, or

REST-assured is an asset

Knowledge of performance testing tools such as JMeter or

LoadRunner is an asset.

Experience in test data management, including data creation, masking, and

validation in relational database environments.

Comfortable working with CI/CD pipelines and integrating

testing into automated build and deployment processes.

50 points

Supplier Comments

The closing date/time: 2026-09-16, 2:30 p.m.

Maximum Number of Submissions – 1 (one)

Onsite – 5 days in the office

MUST HAVES:

Please refer to the Experience Requirements