RQ08080 - Systems Testing/QA 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 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.

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&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
2 days ago