RQ09226 - Systems Testing/QA Specialist - Senior

Description

A Note on Assignment Type:

This position is currently listed as "Onsite"; however, the Assignment under this request will provisionally be "Hybrid", working 7.25 hours per calendar day, sometime between 8:00 AM and 5:00 PM (excluding breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment, you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to.

Scope

• The Office of the Public Guardian and Trustee (OPGT) requires one (1) Systems Testing/QA Specialist to assist with data migration quality assurance and testing.

Assignment Deliverables

As a member of the data migration team, you will provide quality assurance for the data migration effort:

Data Migration

• Test Plan: Develop comprehensive test plans outlining the testing approach, scope, objectives, and the resources required for data migration quality assurance.
• Test Cases: Create detailed test cases and test scripts covering all aspects of data migration, including data extraction, transformation, loading, and validation.
• Test Data: Prepare test data sets that mimic real-world scenarios, ensuring the data covers a wide range of cases and scenarios.
• Test Execution: Perform testing activities according to the test plan, documenting any issues or discrepancies encountered during the data migration process.
• Defect Reports: Report and track defects, issues, or inconsistencies found during testing. Clearly document the steps to reproduce these issues.
• Regression Testing: Conduct regression testing to ensure that existing functionality in Dynamics 365 CRM is not adversely affected by the data migration.
• Performance Testing: If applicable, conduct performance testing to ensure the data migration process does not degrade system performance.
• Documentation: Maintain detailed documentation of test cases, test results, and any modifications made to the test plan during the project.
• Other duties as assigned.

The Vendors Personnel will also be required to:

• Complete work and achieve milestones within the assigned deadlines;
• Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the Assignment Deliverables, as soon as he/she becomes aware of them
• Submit Deliverables for the Cluster/Ministry approval as they are completed.
• Comply with the Ontario Government and the Cluster/Ministry security procedures and practices
• Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices
• Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines
• Provide knowledge and skill transfer to a designated Cluster/Ministry staff; and
• Comply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.

SkillsExperience and Skill Set Requirements

A Note on the VOR Master Service Agreement:

The VOR Master Service Agreement which expires on April 5, 2026, leaves some Contracts with funding unassigned for fiscal 2026-27. If the current statement of work expires on March 31, 2026, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2026, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2026, and be upon the same terms, conditions, and covenants contained in the SOW.

The start date is subject to change based on security clearances and contract signing timelines.

Experience and Skillset Requirements

Mandatory Requirements

• Experience in data migration projects in a QA role, especially involving Azure Cloud and Dynamics 365 CRM.
• Demonstrated experience with designing, implementing and supporting solutions to automate data migration testing

Nice to Have Requirements

• Azure cloud certifications (e.g., Azure fundamentals,)
• Experience with PowerApps platform, Power Automate, Dynamics CE and F&O

Desired Skills and Experience

• Experience in data migration projects in a QA role, especially involving Azure Cloud and Dynamics 365 CRM.
• Knowledge of integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
• Understanding of data quality management practices, including data profiling, data validation, and error handling.
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of data structures and data quality principles.
• Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for create and managing test plans, tracking changes, and collaborating with team members.
• Ability to work closely with stakeholders to gather reporting requirements and translate them into test cases and scenarios.

Resumes Evaluation/Criteria:

Criteria 1: QA Experience / Data Migration - 35 Points

• Experience in data migration projects in a QA role, especially involving Azure Cloud and Dynamics 365 CRM.
• Understanding of data quality management practices, including data profiling, data validation, and error handling.
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of data structures and data quality principles.

Criteria 2: Data Migration Test Automation - 30 Points

• Demonstrated experience with designing, implementing and supporting solutions to automate data migration testing to Dynamics 365

Criteria 3: Dynamics 365 CE - 20 Points

• Knowledge of integration technologies commonly used with Dynamics, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.
• Experience conducting Quality Assurance for model-driven apps in Dynamics 365.

Criteria 4: Azure DevOps - 15 Points

• Demonstrated experience with Azure DevOps, test plans.

Knowledge Transfer

What needs to be KT

• Document the tasks executed and in process of execution as a member of the data migration team using the approach and tools required by the project manager.

To whom

• Project Manager / Team members

When

• 1:1 meetings / team meetings / documentation in DevOps Wiki and boards throughout the duration of the project life cycle.

Must have:

Mentioned above in Experience and Skill Set Requirements