RQ09010 - Systems TestingQA Specialist - Senior

Scope

• The Office of the Public Guardian and Trustee (OPGT) requires a 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 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.
  

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 drillthrough 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. rowlevel 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.
  
  

Requirements

Experience and Skillset Requirements

Mandatory Requirements

• 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.
  
• Experience in Power BI online in a QA role (or similar BI software).
  

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

• 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: QA Experience BI Reporting

• 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 largescale data warehousing/lakehouse solutions.
  
• Ability to work closely with stakeholders to gather reporting requirements and translate them into test cases and scenarios.
  

Criteria 3: Dynamics 365

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

Criteria 4: Azure DevOps

• Demonstrated experience with Azure DevOps test plans test automation
  

Knowledge Transfer

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.
  

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 haves:

• 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.
  
• Experience in Power BI online in a QA role (or similar BI software).