HM Note: This hybrid contract role is three 3 days in office. Candidates resume must include first and last name.
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.
and nbsp;
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 realworld scenarios ensuring the data covers a wide range of cases and scenarios.
- Test : 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 Consultant 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 and amp;IT Directive Operational Policy on the I and amp;IT Project Gateway Process and other applicable Guidelines Standards and Procedures.
Skills
Experience and Skill Set Requirements
and nbsp;
Mandatory Requirements
- Experience in data migration projects in a QA role especially involving Azure Cloud and Dynamics 365 CRM. and nbsp;
- Demonstrated experience with designing implementing and supporting solutions to automate data migration testing and nbsp;
Nice to Have Requirements
- Azure cloud certifications (e.g. Azure fundamentals)
- Experience with PowerApps platform Power Automate Dynamics CE and F and amp;O
Desired Skills and Experience
- Experience in data migration projects in a QA role especially involving Azure Cloud and Dynamics 365 CRM. and nbsp;
- 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. and nbsp;
- 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.
and nbsp;
Resumes Evaluation/Criteria:
and nbsp;
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. and nbsp;
- Understanding of data quality management practices including data profiling data validation and error handling. and nbsp;
- Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of data structures and data quality principles.
Criteria 2: and nbsp;Data Migration Test Automation 30 Points
- Demonstrated experience with designing implementing and supporting solutions to automate data migration testing to Dynamics 365
Criteria 3: and nbsp;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 modeldriven apps in Dynamics 365.
and nbsp;
Criteria 4: and nbsp;Azure DevOps 15 Points
- Demonstrated experience with Azure DevOps test plans.
and nbsp;
Knowledge Transfer
and nbsp;
What needs to be KT
- Document the tasks executed and in process of as a member of the data migration team using the approach and tools required by the project manager.
and nbsp;
To whom
- Project Manager / Team members
and nbsp;
When
- 1:1 meetings / team meetings / documentation in DevOps Wiki and boards throughout the duration of the project life cycle.