---

---

Location

North York, ON | Canada

---

Job description

This is a contract position for a OPGT MOD - One (1) Systems Testing / QA Specialist - Senior for our public sector client.
Work location: Downtown Toronto
Duration: Ten Months
7.25 hours/day
This is an onsite role that requires the candidate to be onsite 5 days of the week (This is a mandatory requirement of the role and is non-negotiable outside of exceptional circumstances.)

Advantages
Good compensation working on projects that will make a difference to the people of Ontario.

Responsibilities
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; and
• 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; and
• Other duties as assigned.

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

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

Summary
If interested and qualified for this role, please apply today for immediate consideration!

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to [email protected] to ensure their ability to fully participate in the interview process. show more

---

Job tags

---

---

Salary