HM Note : This onsite role is three (3) daysinoffice
Scope
TheOffice of the Public Guardian and Trustee (OPGT) requires a SeniorSoftware Developer ETL to perform activities for interfacing thenew Dynamics 365 solution and data warehouse with internal (OPS)and external systems as a member of the integrations team made upof internal and vendorstaff.
andnbsp;
AssignmentDeliverables
As amember of the integrations team the person will be responsible forintegrating and developing the new Dynamics 365 solution as amember of the integrations and amp;
development team made up ofinternal and vendor staff. A highlevel list of deliverables for theintegrations teamfollows :
Deliverablesinclude :
- Designingdeveloping and implementing custom solutions within the Dynamics365 platform and amp; Dynamics 365 CRM applications using C#JavaScript andHTML
- Designing andimplementing integrations with other systems using Power Platformand other integrationtools.
- Verifying theconfiguration tuning and optimization of Dynamics 365 applicationsto ensure seamless integration with other external / internalenterprisesystems.
- Analyzing andoptimizing the performance of the systemintegration.
- Providingfunctional guidance to CRM users through documentation trainingsessions and the resolution of systemissues.
- Performingdata validation tasks such as to validate the extracted / importeddata to ensure its accuracy completeness and consistency.
Help withidentifying and resolving data qualityissues.
- Executingprocesses for transferring data and files between internal andexternal environments via network sFTP APIs Microsoft PowerPlatform LogicApps.
- Executingprocesses for encryption and decryption in an Azureenvironment.
- Performingquality assurance related tasks such as to conduct thorough testingto verify the accuracy and integrity of the data manipulated ininterfaces.
Define test cases and address any issues ordiscrepancies that arise during the testingphase.
Other duties asassigned.
TheVendors Personnel will also be requiredto :
- Completework and achieve milestones within the assigneddeadlines;
- Notify theCluster / Ministry project Manager in writing of any issues or othermaterial concerns related to the Assignment Deliverables as soon ashe / she becomes aware ofthem
- SubmitDeliverables for the Cluster / Ministry approval as they arecompleted.
- Comply withthe Ontario Government and the Cluster / Ministry security proceduresand practices
- Complywith the Ontario Government and the Cluster / Ministryarchitecture / technology standards and bestpractices
- Comply withthe Ontario Government and the Cluster / Ministry Conflict ofInterest and ConfidentialityGuidelines
- Provideknowledge and skill transfer to a designated Cluster / Ministrystaff; and comply with the Ontario Government I and amp;
ITDirective Operational Policy on the I and amp;IT Project GatewayProcess and other applicable Guidelines Standards andProcedures.
Skills
Experienceand Skill SetRequirements
Experienceand Skillset Requirements
andnbsp;
MandatoryRequirements
5years working experience of Microsoft (MS) Dynamics 365 CustomerRelationship 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 andData Pipelines.
- 5years of programming language experience using C# Power FXJavaScript and HTMLto :
- Create and manageDynamics 365 CRM onlinesolutions.
- CustomizeDynamics 365 CRMforms.
- ImplementDynamics 365 CRM views andvisualizations.
- ManageDynamics 365 CRMentities.
- ConfigureDynamics 365 CRM fieldcustomizations.
- ImplementDynamics 365 CRM entityrelationships.
- Createbusiness processflows.
- Proficiency inAzurespecific scripting using PowerShell or Azure CLI .NET C# PowerPlatform LogicApps
- Proven workingexperience in integrating various data sources and systems bothonpremises and in the cloud using Azure ETL services or other ETLtools.
- Proficiency inAzure Data Factory Azure Synapseworkspaces
- Expertproficiency with data manipulation languages (TSQL PL / SQL) datadefinition languages physical database design data modeling queryperformance analysis and amp;tuning
NicetoHaveRequirements
- and nbsp;Azure cloud certifications (e.g. Azure Administrator AzureDeveloper Azure Data Engineer Azure DatabaseAdministrator)
- Knowledgeof integration technologies commonly used with Dynamics such asDataVerse Data Entities andAPIs.
- Experience withcontinuous integration / continuous deployment (CI / CD) processesaround DevOps data workflows Synapseworkspaces.
DesiredSkills andExperience
- 5years programming experience related to MS Dynamics 365applications PowerApps Power Automate and Power BI Data Factory andData Pipelines.
- 5years experience using Microsoft Dynamics and Power Platform(including PowerApps Power BI and Power Automate) to enhancebusiness functionality and overallperformance.
- Indepthunderstanding of CI / CD pipeline and enterprise DevSecOpsimplementation
- Wellversed in development with ModelDriven and CanvasApps
- Proven workingexperience in integrating various data sources and systems bothonpremises and in the cloud using Azure ETL services or other ETLtools
- Indepthknowledge of integration technologies commonly used with Dynamicssuch as DataVerse Data Entities andAPIs.
- Expertise indata transformation techniques aggregation enrichment andnormalization using Azure cloudtechnologies.
- StrongSQL skills and experience working with Azure SQL Databases andDataverse; good understanding of Azure storage concepts andtechnologies.
- Expertisewith Microsoft Power Platform LogicApps.
- Experience withcontinuous integration / continuous deployment (CI / CD) processesaround DevOps data workflows Synapseworkspaces.
- andnbsp;
ResumesEvaluation / Criteria :
Criteria1 : Microsoft Dynamics 365 CRM and amp; ERP Applications DevelopmentExperience 50Points
- Demonstrateddevelopment experience of MS Dynamics 365 Customer RelationshipManagement (CRM) and Enterprise Resource Planning (ERP)applications PowerApps Power Automate and Power BI Data Factory andData Pipelines.
- andnbsp;
Criteria 2 : DataManipulation Skills and Experience 20Points
- Demonstratedexperience with ETL development data pipelines workfloworchestration and data ingestion transformation andmovement.
- Demonstratedexperience in integrating various data sources and systems bothonpremises and in the cloud using Azure ETL services or other ETLtools
- Demonstratedexperience with data manipulation languages (TSQL PL / SQL) datadefinition languages query performance analysis and amp;tuning.
Criteria3 : Testing and Quality Assurance 20Points
- Demonstratedexperience of creation and execution of test cases test scripts andtest data based on functional and technicalspecifications.
- Maintaincomprehensive testing documentation including test plans test casestest results and defect reports and ensure all documentation isuptodate and accessible to relevantparties.
- Identifypotential risks related to testing and implement mitigationstrategies.
- andnbsp;
Criteria 4 : CommunicationSkills 10 Points
- andnbsp; Ability to effectively communicate complextechnical information to nontechnicalstakeholders.
- Abilityto work collaboratively with crossfunctionalteams.
- Stronginterpersonal skills to build relationships withstakeholders.
- andnbsp;
KnowledgeTransfer
andnbsp;
What needsto beKT
- Documentthe tasks executed and in process of execution as a member of thedata migration team using the approach and tools required by theproject manager.
- andnbsp;
Towhom
- ProjectManager / Team Members
- andnbsp;
When
1 : 1meetings / team meetings / documentation on SharePoint sitethroughout the duration of the project life cycleetc.
Musthaves :
5 yearsworking experience of Microsoft (MS) Dynamics 365 CustomerRelationship 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 andData Pipelines.
- 5 years of programming languageexperience using C# Power FX JavaScript and HTMLto :
- Create and manage Dynamics 365 CRM onlinesolutions.
- Customize Dynamics 365 CRMforms.
- Implement Dynamics 365 CRM views andvisualizations.
- Manage Dynamics 365 CRMentities.
- Configure Dynamics 365 CRM fieldcustomizations.
- Implement Dynamics 365 CRMentity relationships.
- Create business processflows.
- Proficiency in Azurespecific scriptingusing PowerShell or Azure CLI .NET C# Power Platform LogicApps
- Proven working experience in integratingvarious data sources and systems both onpremises and in the cloudusing Azure ETL services or other ETLtools.
- Proficiency in Azure Data Factory AzureSynapse workspaces
- Expert proficiency with datamanipulation languages (TSQL PL / SQL) data definition languagesphysical database design data modeling query performance analysisand amp;tuning
Niceto have :
- Azure cloudcertifications (e.g. Azure Administrator Azure Developer Azure DataEngineer Azure DatabaseAdministrator)
- Knowledge of integrationtechnologies commonly used with Dynamics such as DataVerse DataEntities and APIs.
- Experience with continuousintegration / continuous deployment (CI / CD) processes around DevOpsdata workflows Synapseworkspaces.