RQ07961 - Software Developer - ETL - Senior

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.

AssignmentDeliverables :

As a member ofthe integrations team the person will be responsible forintegrating the new Dynamics 365 solution and data warehouse andinternal (OPS) and external systems as a member of the integrationsteam made up of internal and vendor staff.

A highlevel list ofdeliverables for the integrations teamfollows :

These deliverables willrequire :

Designdevelopment and of test plans cases scripts and test data based onfunctional and technical specifications to validate solutions.

Thisincludes creating and maintaining a full test plan testingprocedures an associated library of test cases and scripts testdata (e.

g. manufactured obfuscated) and maintaining fulltraceability from the test plan throughcases.

• Performmanual and automated testing to validate system / integrationfunctionality andperformance.
• Collaboratewith stakeholders to ensure proper integration of tests into thecontinuous integration / continuous delivery (CI / CD)pipeline.
• Provideanalytical development and testing support and execute projectlevel testing of the applications andsolutions.
• Planand execute data migration activities ensuring various systemsintegration from external / internal sources to Microsoft DynamicsCustomer Engagement and Finance & Operation.
• Verify theconfiguration tuning and optimization of Dynamics 365 applicationsto ensure seamless integration with other external / internalenterprisesystems.
• Analyzeand optimize the performance of the systemintegration.
• Providefunctional guidance to CRM users through documentation trainingsessions and the resolution of systemissues.
• Performdata validation tasks such as to validate the extracted / importeddata to ensure its accuracy completeness and consistency.

Help withidentifying and resolving data qualityissues.

• Developprocesses for transferring data and files between internal andexternal environments via network sFTP APIs Microsoft PowerPlatform LogicApps.
• Developprocesses for encryption and decryption in an Azureenvironment.
• Performtesting and quality assurance related tasks such as to conductthorough testing to verify the accuracy and integrity of the datamanipulated in interfaces.

Define test cases and address any issuesor discrepancies that arise during the testingphase.

• Documentthe processesdeveloped.
• Otherduties asassigned.

Requirements

Experienceand Skill SetRequirements :

MustHaves :

• 5years working experience of Microsoft (MS) Azure Cloud technologyespecially MS Dynamics 365 Customer Relationship Management (CRM)and Enterprise Resource Planning (ERP) applications such asCustomer Engagement and Finance & Operations PowerAppsPower Automate and Power BI Data Factory and DataPipelines.
• 5years of proven working experience in integrating various datasources and systems both onpremises and in the cloud using AzureETL services or other ETLtools.
• 5years of experience working on preferably leading testing teams andefforts.
• Indepthknowledge of integration technologies commonly used with Dynamicssuch as DataVerse Data Entities andAPIs.
• Understandingof data pipeline architectures Azure workflow orchestration toolsand concepts related to data ingestion transformation andmovement.
• Proficiencyin Azure Data Factory Azure Synapseworkspaces
• StrongSQL skills and experience working with Azure SQL Databases andDataverse; good understanding of Azure storage concepts andtechnologies.
• Proficiencyin Azurespecific scripting using PowerShell or Azure CLI .NET C#Power Platform LogicApps
• Expertproficiency with data manipulation languages (TSQL PL / SQL) datadefinition languages physical database design data modeling queryperformance analysis &tuning

Nice tohave :

• Azurecloud certifications (e.g. Azure Administrator Azure DeveloperAzure Data Engineer Azure DatabaseAdministrator)
• Knowledgeof integration technologies commonly used with Dynamics such asDataVerse Data Entities andAPIs.
• Experiencewith continuous integration / continuous deployment (CI / CD) processesaround DevOps data workflows Synapseworkspaces.

Skill SetRequirements :

GeneralSkills andExperience :

• Expertisein data transformation techniques aggregation enrichment andnormalization using Azure cloudtechnologies.
• Understandingof data governance principles data privacy regulations andexperience working with highsensitivity data and knowledge of bestpractices for data security and compliance in Azure.
• Ability tomonitor and troubleshoot integration processes and implementefficient data processing techniques inAzure.
• Expertisewith Microsoft Power Platform LogicApps.
• Familiaritywith version control systems (e.g. Azure Repos) and collaborationtools (e.g. Azure DevOps) for managing code tracking changes andcollaborating with teammembers.
• Experiencewith SQL Server Management Studio Azure data management tools XRMtoolbox data modeling tools (ERWIN or PowerDesigner).
• Familiaritywith data warehousing concepts and experience working with AzureSynapseAnalytics.
• Experiencewith PowerApps platform Power Automate Dynamics CE andF&O

Microsoft Dynamics 365 CRM& ERP Applications and Azure CloudExperience :

Demonstratedexperience of Microsoft (MS) Azure Cloud technology especially MSDynamics 365 Customer Relationship Management (CRM) and EnterpriseResource Planning (ERP) applications such as Customer Engagementand Finance & Operations PowerApps Power Automate and PowerBI Data Factory and DataPipelines.

Data Manipulation Skills andExperience :

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

Testing and QualityAssurance :

• Demonstratedexperience of creation and of test cases test scripts and test databased 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.

CommunicationSkills :

• Abilityto effectively communicate complex technical information tonontechnicalstakeholders.
• Abilityto work collaboratively with crossfunctionalteams.
• Stronginterpersonal skills to build relationships withstakeholders.

Experience and Skill Set Requirements : Must Haves : 5+ years workingexperience of Microsoft (MS) Azure Cloud technology especially MSDynamics 365 Customer Relationship Management (CRM) and EnterpriseResource Planning (ERP) applications such as Customer Engagementand Finance & Operations, PowerApps, Power Automate and PowerBI, Data Factory and Data Pipelines.

5+ years of proven workingexperience in integrating various data sources and systems, bothon-premises and in the cloud, using Azure ETL services or other ETLtools.

5+ years of experience working on, preferably leading,testing teams and efforts. In-depth knowledge of integrationtechnologies commonly used with Dynamics, such as DataVerse, DataEntities, and APIs.

Understanding of data pipeline architectures,Azure workflow orchestration tools, and concepts related to dataingestion, transformation, and movement.

Proficiency in Azure DataFactory, Azure Synapse workspaces Strong SQL skills and experienceworking with Azure SQL Databases and Dataverse;

good understandingof Azure storage concepts and technologies. Proficiency inAzure-specific scripting using PowerShell or Azure CLI, .

NET, C#,Power Platform, Logic Apps Expert proficiency with datamanipulation languages (T-SQL, PL / SQL), data definition languages,physical database design, data modeling, query performance analysis& tuning Nice to have : Azure cloud certifications (e.

g., AzureAdministrator, Azure Developer, Azure Data Engineer, Azure DatabaseAdministrator) Knowledge of integration technologies commonly usedwith Dynamics, such as DataVerse, Data Entities, and APIs.

Experience with continuous integration / continuous deployment(CI / CD) processes around DevOps, data workflows, Synapseworkspaces.

Skill Set Requirements : General Skills and Experience : Expertise in data transformation techniques, aggregation,enrichment, and normalization using Azure cloud technologies.

Understanding of data governance principles, data privacyregulations and experience working with high-sensitivity data, andknowledge of best practices for data security and compliance inAzure.

Ability to monitor and troubleshoot integration processesand implement efficient data processing techniques in Azure.Expertise with Microsoft Power Platform, Logic Apps.

Familiaritywith version control systems (e.g., Azure Repos) and collaborationtools (e.g., Azure DevOps) for managing code, tracking changes, andcollaborating with team members.

Experience with SQL ServerManagement Studio, Azure data management tools, XRM toolbox, datamodeling tools (ERWIN or PowerDesigner).

Familiarity with datawarehousing concepts and experience working with Azure SynapseAnalytics. Experience with PowerApps platform, Power Automate,Dynamics CE and F&O Microsoft Dynamics 365 CRM & ERPApplications and Azure Cloud Experience : Demonstrated experience ofMicrosoft (MS) Azure Cloud technology especially MS Dynamics 365Customer Relationship Management (CRM) and Enterprise ResourcePlanning (ERP) applications such as Customer Engagement and Finance& Operations, PowerApps, Power Automate and Power BI, DataFactory and Data Pipelines.

Data Manipulation Skills andExperience : Demonstrated experience with ETL development, datapipelines, workflow orchestration and data ingestion,transformation, and movement.

Demonstrated experience inintegrating various data sources and systems, both on-premises andin the cloud, using Azure ETL services or other ETL toolsDemonstrated experience with data manipulation languages (T-SQL,PL / SQL), data definition languages, query performance analysis& tuning.

Testing and Quality Assurance : Demonstratedexperience of creation and of test cases, test scripts, and testdata based on functional and technical specifications.

Maintaincomprehensive testing documentation, including test plans, testcases, test results, and defect reports and ensure alldocumentation is up-to-date and accessible to relevant parties.

Identify potential risks related to testing and implementmitigation strategies. Communication Skills : Ability to effectivelycommunicate complex technical information to non-technicalstakeholders.

Ability to work collaboratively with cross-functionalteams. Strong interpersonal skills to build relationships withstakeholders.