<p>Must haves:</p>
<ul>
<li>5 - 10 years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes. </li>
<li>· Strong SQL skills and experience working with Azure SQL Databases and Dataverse.</li>
<li>· Knowledge of Microsoft Dynamics 365 Customer Engagement (CE).</li>
</ul>
<p>Nice to have:</p>
<ul>
<li>Azure cloud certifications (e.g. Azure fundamentals, Azure Data Engineer associate, Azure Database Administrator associate)</li>
</ul>
<p><strong>Experience and Skillset Requirements</strong></p>
<p><strong>Mandatory Requirements</strong></p>
<ul>
<li>5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes. </li>
<li>Strong SQL skills and experience working with Azure SQL Databases and Dataverse.</li>
<li>Knowledge of Microsoft Dynamics 365 Customer Engagement (CE).</li>
</ul>
<p><strong>Nice to Have Requirements</strong></p>
<ul>
<li>Azure cloud certifications (e.g. Azure fundamentals, Azure Data Engineer associate, Azure Database Administrator associate)</li>
</ul>
<p><strong>Desired Skills and Experience</strong></p>
<ul>
<li>5+ years of proven working experience in an ETL role; strong understanding of ETL principles, including data extraction, transformation, and loading processes; knowledge of common ETL design patterns.</li>
<li>Experience in integrating various data sources and systems, using Azure ETL technologies such as Synapse.</li>
<li>Knowledge of technologies commonly used with Dynamics 365, such as DataVerse / Common Data Service (CDS), Data Entities, and APIs.</li>
<li>Expertise in data transformation techniques, such as data cleansing, aggregation, enrichment, and normalization using Azure cloud technologies.</li>
<li>Understanding of data quality management practices, including data profiling, data validation, and error handling within ETL processes. </li>
<li>Understanding of data governance principles, data privacy regulations and experience working with high-sensitivity data, and knowledge of best practices for data security and compliance in Azure. </li>
<li>Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies; Expert in data manipulation languages (T-SQL), data definition languages, physical database design, data modelling, query performance analysis & tuning.</li>
<li>Familiarity with version control systems (e.g., Azure Repos) and collaboration tools (e.g., Azure DevOps) for managing code, tracking changes, and collaborating with team members.</li>
<li>Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.</li>
<li>Experience with SQL Server Management Studio, Azure data management tools, XRM toolbox.</li>
</ul>
<p><strong>A Note on Assignment Type:</strong></p>
<p><strong>Scope</strong></p>
<p> </p>
<ul>
<li>The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer – ETL to validate the data migration from the existing OPGT legacy applications to the new Dynamics 365 OPGT solution.</li>
</ul>
<p> </p>
<p><strong>Assignment Deliverables</strong></p>
<p> </p>
<p>As a member of the data migration team, you will be responsible for validating the quality of the data migration from the legacy application to Dynamics, in preparation for go-live. A high-level list of deliverables follows:</p>
<ul>
<li>Data Analysis: analyze the existing data in the legacy applications, understand its structure, quality, and relationships.</li>
<li>Data Mapping and Transformation: read the existing data migration code to understand the mapping of the data elements from the legacy application to the corresponding entities and fields in Dynamics 365 CE</li>
<li>Data Testing and Quality Assurance: conduct thorough testing to verify the accuracy and integrity of the migrated data; define test cases, perform data reconciliation, and address any issues or discrepancies that arise during the testing phase; develop KPIs to report on the progress, completeness, and quality of the data migration effort.</li>
<li>Data Migration Test Plans: Develop comprehensive test plans outlining the testing approach, scope, objectives, and the resources required for data migration quality assurance.</li>
<li>Data Migration Test Cases: Create detailed test cases and test scripts covering all aspects of data migration, including data extraction, transformation, loading, and validation.</li>
<li>Data Fix Development: Modify data migration code to address data migration issues.</li>
<li>Documentation: Maintain detailed documentation of test cases, test results, and any modifications made to the test plan during the project.</li>
<li>Ongoing Support: provide post-migration support, analyze, and address data-related issues or questions; help optimize data management processes in the new environment.</li>
<li>Other duties as assigned.</li>
</ul>
<p> </p>
<p>The Vendor’s Personnel will also be required to:</p>
<ul>
<li>Complete work and achieve milestones within the assigned deadlines.</li>
<li>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.</li>
<li>Submit Deliverables for the Cluster/Ministry approval as they are completed.</li>
<li>Comply with the Ontario Government and the Cluster/Ministry security procedures and practices.</li>
<li>Comply with the Ontario Government and the Cluster/Ministry architecture/technology standards and best practices.</li>
<li>Comply with the Ontario Government and the Cluster/Ministry Conflict of Interest and Confidentiality Guidelines.</li>
<li>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.</li>
</ul>