Description
Job DescriptionScope: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 themSubmit Deliverables for the Cluster/Ministry approval as they are completed.Comply with the Ontario Government and the Cluster/Ministry security procedures and practicesComply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practicesComply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality GuidelinesProvide knowledge and skill transfer to a designated Cluster/Ministry staff; andComply with the Ontario Government I&IT Directive, Operational Policy on the I&IT Project Gateway Process, and other applicable Guidelines, Standards and Procedures.RequirementsExperience 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.
