RQ10005 - Systems Testing/QA Specialist - Intermediate

Responsibilities:

The Quality Assurance Specialist is responsible for the development of test plans, test scripts and test cases and executing these against the various components. The tester will work with the testing lead and IT lead of each project as well as the project team members in the analysis, design, development, implementation and ongoing support of the required systems

Key deliverables to be performed by the Systems Testing/QA Specialist \- Senior include, but are not limited to, the following:

• Support the end\-to\-end testing strategy to ensure the business requirements are met and the system performs as expected without impact to current business processing; Analyze business requirements documentation including use cases and non\-functional requirements;
  


• Create test strategies and test suites, including test plans, cases and summary reports;
  


• Analyze test data requirements and create appropriate test data to support the test cases;
  


• Execute system and user acceptance tests adhering to OPS standards;
  


• Verify actual results meet expected results;
  


• Examine test databases using database access tools; e.g., SQL. Analyze and log test results; Document and monitor resolution of system variances using an automated problem management system;
  


• Provide recommendations to the Project Lead / Sr. Project Manager as to the acceptance or rejection of any new or changed system components;
  


• Provide weekly project status report that reflects progress on tasks, changes based on approved change orders, issues/risks that require management attention and planned activities for the next period;
  


• Use the Cluster tool for internal defect quality management and follow up on defects;
  


• Plan and execute system iteration and regression tests;
  


• Develop presentations for various audiences, as required;
  


• Work with the business and IT areas to complete any activities required to accomplish above and others deliverables as required during the assignment;
  


• Transfer skills and knowledge to selected OPS staff;
  

Responsibilities:

• Provides advice on the testing strategy, test plans, the selection of testing tools, and the identification of resources required for testing.
  


• Plans and organizes testing efforts for large systems in Graphical User Interface (GUI) and non\-Graphical User Interface (GUI) environments, including the execution of systems integration tests, specialized tests, and user acceptance testing (e.g., stress tests).
  


• The Quality Assurance Specialist is responsible for the development of test plans, test scripts and test cases and executing these against the various components. The tester will work with the testing lead and IT lead of each project as well as the project team members in the analysis, design, development, implementation and ongoing support of the required systems.
  


• Executes functional, integration, system, and regression tests.
  


• Validates that the system behaves as expected under various conditions.
  


• Identifies, document, and track software defects using tools like ALM, JIRA, Bugzilla, and Azure DevOps.
  


• Works closely with developers to reproduce and resolve issues.
  


• Develops and maintains automated test scripts using tools like Micro Focus, OpenText™ UFT, Selenium, TestComplete, or Postman.
  


• Integrate automated tests into CI/CD pipelines.
  


• Conduct performance, stress, and load testing to ensure the system can handle expected user traffic and data volumes.
  


• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards.
  


• Collaborate with developers, business analysts, and project managers to clarify requirements and ensure quality.
  


• Participate in Agile ceremonies like sprint planning, daily stand\-ups, and retrospectives.
  


• Maintain detailed documentation of test results, test coverage, and quality metrics.
  


• Provide input for user manuals and release notes.
  


• Ensure testing processes comply with industry standards and regulatory requirements.
  

General Skills:

• Experience in planning, organizing and implementing testing efforts at the specified experience level
  


• Knowledge of structured methodologies for the development, design, implementation and maintenance of applications
  


• Knowledge and experience in the use of Computer Aided Software Engineering (CASE) tools and data query tools to aid in the development of test cases
  


• Knowledge and experience in the use of automated test tools and version control systems on one or more platforms
  


• Experience executing functional tests, non\-functional tests and systems level integration tests
  


• Experience supporting user acceptance testing and participating in UAT activities
  


• Experience with quality assurance principles, practices, tools and structured methodologies
  


• Experience creating testing strategy documentation, test plans, test cases and test data for various types and phases of testing, including technical and business functional validation
  


• Experience in quality assurance and testing, including unit testing, integration testing, load testing, performance testing, etc.
  


• Knowledge and experience in all phases of the Systems Development Life Cycle
  


• Excellent analytical, problem\-solving and decision\-making skills; organizational, creativity and perseverance skills; verbal and written communication skills; and interpersonal skills
  


• A team player with a track record for meeting deadlines
  


• Knowledge of one or more automated testing tools
  


• Knowledge of system, integration, regression, and acceptance testing.
  


• Familiarity with Agile, Scrum, and Waterfall methodologies.
  


• Demonstrated ability to write clear, comprehensive test cases and execute them effectively.
  


• Experience with tools like ALM, JIRA, Bugzilla, TestRail, Zephyr, etc.
  


• Familiarity with tools like Selenium, Cypress, or Postman or ThunderClient. for API testing.
  


• Understanding of scripting languages (e.g., Python, JavaScript, Bash) for automation or test data setup.
  


• Demonstrated ability to write queries to validate data and perform backend testing.
  


• Clear grasp of the software development and testing life cycles.
  


• Experience conducting basic security testing and collaborating with security specialists for deeper penetration testing.
  


• Experience developing and managing robust test data strategies, including generating realistic and sufficient test data, ensuring data privacy, and managing test data environments.
  


• Validates data integrity, consistency, and accuracy across various system components and databases, performing data migration and transformation testing as needed.
  


• Experience developing and executing performance test scripts using tools like JMeter or LoadRunner, and analyzing performance bottlenecks and system scalability.
  

Desirable Skills:

• Knowledge and experience in at least one programming language
  


• Experience in the use of information retrieval packages
  


• Knowledge and understanding of testing methods in an object\-oriented environment
  


• Knowledge and understanding of Information Management principles, concepts, policies and practices.
  


• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
  


• Experience planning and organizing testing efforts for both large and small systems
  


• Experience coding automated test scripts to produce sets of automated test cases
  


• Experience testing Commercial Off\-the Shelf Applications (COTS)
  

Requirements

Experience and Skill Set Requirements:

Must Have:

• Experience in designing, developing, and executing automated test frameworks and test cases.
  


• Proficiency in writing and optimizing SQL queries for data validation and analysis within Oracle databases.
  


• Hands\-on experience performing API testing using tools such as ThunderClient.
  

Skill Set Requirements:

Must haves:

• Experience using Microsoft Devops to create test plan and test cases, and track defects and issues;
  


• Experience scripting for testing automation (e.g. using Quick Test pro tool, HP Quality Center) and performance testing (eg using Load Runner);
  


• Expert in creating complex SQL scripting in testing environments built on 3/N\-tier web applications using Oracle and/ or SQL Server DBs;
  


• AODA testing experience with full WCAG AA compliance in\-web applications, experience using screen readers (e.g. JAWS, NVDA) for testing and High Compliance Sherriff tool expertise
  


• Experience with VBA and VBS used for web applications testing
  


• Demonstrated experience profiling and testing data stored within Databases, XML, CSV, JSON, and Excel files;
  

Technical Skills:

• Demonstrated experience in developing test strategy, test plan, test cases and test data
  


• Demonstrated strong experience in manual and automated testing and scripting
  


• Demonstrated experience with automation testing in web application, Window services and Web API services
  


• Demonstrated experience with testing user authentication and authorization
  


• Demonstrated experience eliciting requirements, and conducting impact analysis
  


• Demonstrated experience using HPQC and TFS to document, track and record testing progress, test plan and test cases;
  


• Demonstrated experience using Microsoft DevOps to create test plan and test cases, and track defects and issues
  


• Demonstrated Experience with VBA and VBS used for scripting in testing web applications
  


• Experience in testing environments built on 3/N\-tier web applications using Oracle and/ or SQL Server DBs;
  


• Demonstrated experience with Test Automation tool in particular Quick Test pro v10.0, HP quality Center;
  


• Demonstrated experience using SQL for testing;
  


• Strong technical skills in SQL, Databases, XML;
  


• Demonstrated experience profiling and testing data stored within Databases, XML, CSV, JSON, and Excel files;
  


• Demonstrated experience testing for WCAG AA compliance in web applications, preferable experience using screen reader (JAWS , NVDA) for testing and High Compliance Sherriff tool;
  


• Demonstrated experience creating complex SQL scripting for testing;
  


• Demonstrated experience scripting for testing automation (using a tool like Quick Test pro) and performance testing(using a tool like Load Runner); Demonstrated experience with the use of desktop tools such as Visio, MS Office, MS Project, and MS Outlook;
  


• Demonstrated experience in SQL, Databases, and XML in the context of database testing;
  


• Demonstrated experience in an HP NonStop (Tandem) batch, online, n\-tier and web environment.
  

Core Skills:

• Demonstrated experience executing testing as part of the Software Development Life Cycle (SDLC), including experience testing through all the Software Testing Life Cycle phases;
  


• Experience in testing web applications used by 5000+ end users within the broader public sector;
  


• Demonstrated experience executing different types of software testing processes and testing methodologies
  


• Demonstrated experience writing test scripts, test cases and test scenarios, testing web applications and reporting defects;
  


• Demonstrated experience in investigating production issues for root causes and providing suggestion on solutions
  


• Demonstrated experience with conducting system impact analysis by working with business analysts and developers
  


• Knowledge with migrating on\-prem application to Azure Cloud
  


• Demonstrated experience preparing for, conducting and supporting SIT, SAT and UAT testing that adhere to Testing Strategy and Testing Methodology
  

General Skills:

• Excellent analytical, problem\-solving, and decision\-making skills; verbal and written communication skills; interpersonal and negotiation skills
  


• Demonstrated Experience in dealing with multiple teams representing various areas in delivering the project and to work collaboratively with client organizations
  


• Demonstrated experience working in an agile and waterfall environment;
  


• Demonstrated experience working collaboratively with client organizations;
  


• Demonstrated experience coordinating multiple projects with competing priorities;
  


• Demonstrated experience producing deliverables on time and on schedule
  

Public Sector Experience:

• Experience within the public sector, particular with school/student information systems