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 Vendor's 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.
  

Experience and Skill Set Requirements:

Must Haves:

• 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
  

Skill Set Requirements:

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.
  

QA Experience / Data Migration:

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

Data Migration Test Automation:

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

Dynamics 365 CE:

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

Azure DevOps:

• Demonstrated experience with Azure DevOps, test plans.