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 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 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.Requirements
Experience and Skill Set Requirements :
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).Nice to have :
Azure cloud certifications (e.g. Azure fundamentals)Experience with PowerApps platform Power Automate Dynamics CE and F&OSkill 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.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.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.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.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.Azure DevOps :
Demonstrated experience with Azure DevOps test plans test automationExperience and Skill Set Requirements : 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). Nice to have : 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. 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. 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. 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 large-scale data warehousing / lakehouse solutions. Ability to work closely with stakeholders to gather reporting requirements and translate them into test cases and scenarios. 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 model-driven apps in Dynamics 365. Azure DevOps : Demonstrated experience with Azure DevOps, test plans, test automation
