RQ11634 - Systems Testing/QA Specialist - Senior

Description:

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 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.