Note: 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.

Must Have

• Experience in data migration projects in a QA role, especially involving Azure Cloud and Dynamics 365 CRM.
• Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.

Nice-to-Have Skills and Experience

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

Description

A Note on Assignment Type:

• The VOR Master Service Agreement which expires on April 5, 2025, leaves some Contracts with funding unassigned for fiscal 2025-26. If the current statement of work expires on March 31, 2025, the remaining funds can be used to exercise an option to extend the SOW beyond March 31, 2025, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond April 5, 2025, 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.

Scope

• The Office of the Public Guardian and Trustee (OPGT) requires two (2) Systems Testing/QA Specialist to assist with data migration quality assurance and with testing the migration/redevelopment of BI reports to the new data warehouse.

Assignment Deliverables

As a member of the data migration team and reporting team, you will provide quality assurance for the data migration and BI reporting efforts:

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.

BI reporting

• Test Plan: Develop a test plan specific to Power BI reporting, outlining the testing approach, scope, objectives, and the resources required for reporting quality assurance.
• Test Cases: Create detailed test cases and test scenarios covering all aspects of Power BI reports, including data accuracy, functionality, and visualization quality.
• Data Validation: Verify that the data displayed in Power BI reports matches the source data and meets accuracy and completeness requirements.
• Functionality Testing: Test the interactive features of Power BI reports, including filtering, drill-through, and parameterization, to ensure they function correctly.
• Performance Testing: Conduct performance testing to ensure that Power BI reports load and respond within acceptable time frames, especially with large datasets.
• Security Testing: Verify that security measures (e.g., row-level security, data encryption) are correctly implemented to protect sensitive data in Power BI reports.
• Regression Testing: Perform regression testing to ensure that changes or updates to Power BI reports do not introduce new defects or affect existing functionality.
• Accessibility Testing: Ensure that Power BI reports are accessible to users with disabilities and comply with accessibility standards.
• 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 Skillset 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.
• Experience in Power BI online in a QA role (or similar BI software).
• Power BI knowledge, including data modeling, report development, and visualization best practices, including AODA.
• Familiarity with testing methodologies specific to BI and reporting, including functionality testing, data accuracy testing, performance testing, and security testing.
• Familiarity with data warehousing concepts and experience working with Azure Synapse Analytics or similar platforms for building and managing large-scale data warehousing/lakehouse solutions.
• 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: Dynamics 365 - 30 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 3: QA Experience - BI Reporting - 20 Points

• Experience in Power BI online in a QA role (or similar BI software).
• Power BI knowledge, including data modeling, report development, and visualization best practices, including AODA.
• Familiarity with testing methodologies specific to BI and reporting, including functionality testing, data accuracy testing, performance testing, and security testing.
• Familiarity with data warehousing concepts and experience working with Azure Synapse Analytics or similar platforms for building and managing large-scale data warehousing/lakehouse solutions.
• Ability to work closely with stakeholders to gather reporting requirements and translate them into test cases and scenarios.

Criteria 4: Azure DevOps - 15 Points

• Demonstrated experience with Azure DevOps, test plans, test automation