Job DescriptionDescription:We are seeking a highly skilled and detail-oriented
Software Systems Testing & Quality Assurance Specialist to join our projectteam. 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.
RequirementsExperience and Skill Set Requirements: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
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.
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.
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.
