Archived listing. The details below describe a past opening.
Title
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.
Skills
Experience and Skill Set 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
Onsite - 5 days in the office
MUST HAVES:
Please refer to the Experience and Skill Set Requirements
