HM Note: This onsite role is three (3) days in office
Scope
The Office of the Public Guardian and Trustee (OPGT) requires a Senior Software Developer ETL to perform activities for interfacing the new Dynamics 365 solution and data warehouse with internal (OPS) and external systems as a member of the integrations team made up of internal and vendor staff.
and nbsp;
Assignment Deliverables
As a member of the integrations team the person will be responsible for integrating and developing the new Dynamics 365 solution as a member of the integrations and amp; development team made up of internal and vendor staff. A highlevel list of deliverables for the integrations team follows:
Deliverables include:
- Designing developing and implementing custom solutions within the Dynamics 365 platform and amp; Dynamics 365 CRM applications using C# JavaScript and HTML
- Designing and implementing integrations with other systems using Power Platform and other integration tools.
- Verifying the configuration tuning and optimization of Dynamics 365 applications to ensure seamless integration with other external/internal enterprise systems.
- Analyzing and optimizing the performance of the system integration.
- Providing functional guidance to CRM users through documentation training sessions and the resolution of system issues.
- Performing data validation tasks such as to validate the extracted/imported data to ensure its accuracy completeness and consistency. Help with identifying and resolving data quality issues.
- Executing processes for transferring data and files between internal and external environments via network sFTP APIs Microsoft Power Platform Logic Apps.
- Executing processes for encryption and decryption in an Azure environment.
- Performing quality assurance related tasks such as to conduct thorough testing to verify the accuracy and integrity of the data manipulated in interfaces. Define test cases and address any issues or discrepancies that arise during the testing phase.
- Other duties as assigned.
The Vendors 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 and amp;IT Directive Operational Policy on the I and amp;IT Project Gateway Process and other applicable Guidelines Standards and Procedures.
Skills
Experience and Skill Set Requirements
Experience and Skillset Requirements
and nbsp;
Mandatory Requirements
- 5 years working experience of Microsoft (MS) Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as Customer Engagement and Finance and amp; Operations PowerApps Power Automate and Power BI Data Factory and Data Pipelines.
- 5 years of programming language experience using C# Power FX JavaScript and HTML to:
- Create and manage Dynamics 365 CRM online solutions.
- Customize Dynamics 365 CRM forms.
- Implement Dynamics 365 CRM views and visualizations.
- Manage Dynamics 365 CRM entities.
- Configure Dynamics 365 CRM field customizations.
- Implement Dynamics 365 CRM entity relationships.
- Create business process flows.
- Proficiency in Azurespecific scripting using PowerShell or Azure CLI .NET C# Power Platform Logic Apps
- Proven working experience in integrating various data sources and systems both onpremises and in the cloud using Azure ETL services or other ETL tools.
- Proficiency in Azure Data Factory Azure Synapse workspaces
- Expert proficiency with data manipulation languages (TSQL PL/SQL) data definition languages physical database design data modeling query performance analysis and amp; tuning
NicetoHave Requirements
- and nbsp;Azure cloud certifications (e.g. Azure Administrator Azure Developer Azure Data Engineer Azure Database Administrator)
- Knowledge of integration technologies commonly used with Dynamics such as DataVerse Data Entities and APIs.
- Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps data workflows Synapse workspaces.
Desired Skills and Experience
- 5 years programming experience related to MS Dynamics 365 applications PowerApps Power Automate and Power BI Data Factory and Data Pipelines.
- 5 years experience using Microsoft Dynamics and Power Platform (including PowerApps Power BI and Power Automate) to enhance business functionality and overall performance.
- Indepth understanding of CI/CD pipeline and enterprise DevSecOps implementation
- Well versed in development with ModelDriven and Canvas Apps
- Proven working experience in integrating various data sources and systems both onpremises and in the cloud using Azure ETL services or other ETL tools
- Indepth knowledge of integration technologies commonly used with Dynamics such as DataVerse Data Entities and APIs.
- Expertise in data transformation techniques aggregation enrichment and normalization using Azure cloud technologies.
- Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.
- Expertise with Microsoft Power Platform Logic Apps.
- Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps data workflows Synapse workspaces.
and nbsp;
Resumes Evaluation/Criteria:
Criteria 1: Microsoft Dynamics 365 CRM and amp; ERP Applications Development Experience 50 Points
- Demonstrated development experience of MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications PowerApps Power Automate and Power BI Data Factory and Data Pipelines.
and nbsp;
Criteria 2: Data Manipulation Skills and Experience 20 Points
- Demonstrated experience with ETL development data pipelines workflow orchestration and data ingestion transformation and movement.
- Demonstrated experience in integrating various data sources and systems both onpremises and in the cloud using Azure ETL services or other ETL tools
- Demonstrated experience with data manipulation languages (TSQL PL/SQL) data definition languages query performance analysis and amp; tuning.
Criteria 3: Testing and Quality Assurance 20 Points
- Demonstrated experience of creation and execution of test cases test scripts and test data based on functional and technical specifications.
- Maintain comprehensive testing documentation including test plans test cases test results and defect reports and ensure all documentation is uptodate and accessible to relevant parties.
- Identify potential risks related to testing and implement mitigation strategies.
and nbsp;
Criteria 4: Communication Skills 10 Points
- and nbsp;Ability to effectively communicate complex technical information to nontechnical stakeholders.
- Ability to work collaboratively with crossfunctional teams.
- Strong interpersonal skills to build relationships with stakeholders.
and nbsp;
Knowledge Transfer
and nbsp;
What needs to be KT
- Document the tasks executed and in process of execution as a member of the data migration team using the approach and tools required by the project manager.
and nbsp;
To whom
- Project Manager/Team Members
and nbsp;
When
- 1:1 meetings / team meetings / documentation on SharePoint site throughout the duration of the project life cycle etc.
Must haves:
- 5 years working experience of Microsoft (MS) Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as Customer Engagement and Finance and amp; Operations PowerApps Power Automate and Power BI Data Factory and Data Pipelines.
- 5 years of programming language experience using C# Power FX JavaScript and HTML to:
- Create and manage Dynamics 365 CRM online solutions.
- Customize Dynamics 365 CRM forms.
- Implement Dynamics 365 CRM views and visualizations.
- Manage Dynamics 365 CRM entities.
- Configure Dynamics 365 CRM field customizations.
- Implement Dynamics 365 CRM entity relationships.
- Create business process flows.
- Proficiency in Azurespecific scripting using PowerShell or Azure CLI .NET C# Power Platform Logic Apps
- Proven working experience in integrating various data sources and systems both onpremises and in the cloud using Azure ETL services or other ETL tools.
- Proficiency in Azure Data Factory Azure Synapse workspaces
- Expert proficiency with data manipulation languages (TSQL PL/SQL) data definition languages physical database design data modeling query performance analysis and amp; tuning
Nice to have:
- Azure cloud certifications (e.g. Azure Administrator Azure Developer Azure Data Engineer Azure Database Administrator)
- Knowledge of integration technologies commonly used with Dynamics such as DataVerse Data Entities and APIs.
- Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps data workflows Synapse workspaces.