RQ07981 - Software Developer - CRM - Senior

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.

ignment 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 & 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& 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.
  
• yzing and optimizing the performance of the system integration.
  
• Providing functional guidance to CRM users through doentation 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 urance 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 igned.
  

The Vendor s Personnel will also be required to:

• Complete work and achieve milestones within the igned deadlines;
  
• Notify the Cluster/Ministry project Manager in writing of any issues or other material concerns related to the ignment 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 s 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.
  

Ss

Experience and S Set Requirements

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 & 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 PowerS 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 ysis & tuning
  

NicetoHave Requirements

• 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 Ss 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 ss 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.
  

Resumes Evaluation/Criteria:

Criteria 1: Microsoft Dynamics 365 CRM & ERP Applications Development Experience

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

Criteria 2: Data Manipulation Ss and Experience

• 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 ysis & tuning.
  

Criteria 3: Testing and Quality urance

• Demonstrated experience of creation and of test cases test scripts and test data based on functional and technical specifications.
  
• Maintain comprehensive testing doentation including test plans test cases test results and defect reports and ensure all doentation is uptodate and accessible to relevant parties.
  
• Identify potential risks related to testing and implementing mitigation strategies.
  

Criteria 4: Communication Ss

• Ability to effectively communicate complex technical information to nontechnical stakeholders.
  
• Ability to work collaboratively with crossfunctional teams.
  
• Strong interpersonal ss to build relationships with stakeholders.
  

Requirements

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 & 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 PowerS 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 ysis & 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.