Software Developer Etl Senior

Toronto, ON, Canada

Job Description

Role: Software Developer - ETL - Senior
Location: Toronto, Ontario (Hybrid)
Duration: 6 Months with possible extension
Experience and Skillset Requirements
Mandatory Requirements

  • 10+ years of experience working in IT software development and testing teams.
  • 5+ years of proven working experience in integrating various data sources and systems, preferably integration with Microsoft (MS) Azure Cloud technology especially MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as D365 Finance & Operations, using platform and tools such as PowerApps, Power Automate and Azure Data Factory, Azure Synapse Analytics.
  • 2+ years working experience of configuring D365 Customer Engagement security model to meet business requirement.
  • Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
  • Proficiency in Azure Data Factory, Azure Synapse workspaces
  • Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
  • Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies.
  • In-depth knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
  • Knowledge of integration technologies commonly used with Dynamics, such as DataVerse, Data Entities, and APIs.
  • Understanding of data pipeline architectures, Azure workflow orchestration tools, and concepts related to data ingestion, transformation, and movement.
Resumes Evaluation/Criteria:
Criteria 1: Microsoft Dynamics 365 CRM & ERP Applications and Azure Cloud Experience - 40 Points
  • Demonstrated experience of Microsoft (MS) Azure Cloud technology especially 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.
Criteria 2: Data Manipulation Skills and Experience - 30 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 on-premises and in the cloud, using Azure ETL services or other ETL tools
  • Demonstrated experience with data manipulation languages (T-SQL, PL/SQL), data definition languages, query performance analysis & 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 up-to-date and accessible to relevant parties.
  • Identify potential risks related to testing and implement mitigation strategies.
Criteria 4: Communication Skills - 10 Points
  • Ability to effectively communicate complex technical information to non-technical stakeholders.
  • Ability to work collaboratively with cross-functional teams.
  • Strong interpersonal skills to build relationships with stakeholders.
Must haves:
  • 10+ years of experience working in IT software development and testing teams.
  • 5+ years of proven working experience in integrating various data sources and systems, preferably integration with Microsoft (MS) Azure Cloud technology especially MS Dynamics 365 Customer Relationship Management (CRM) and Enterprise Resource Planning (ERP) applications such as D365 Finance & Operations, using platform and tools such as PowerApps, Power Automate and Azure Data Factory, Azure Synapse Analytics.
  • 2+ years working experience of configuring D365 Customer Engagement security model to meet business requirement.
  • Proficiency in Azure-specific scripting using PowerShell or Azure CLI, .NET, C#, Power Platform, Logic Apps
  • Proficiency in Azure Data Factory, Azure Synapse workspaces
  • Experience with continuous integration/continuous deployment (CI/CD) processes around DevOps, data workflows, Synapse workspaces.
  • Strong SQL skills and experience working with Azure SQL Databases and Dataverse; good understanding of Azure storage concepts and technologies

Skills Required

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD3293847
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Toronto, ON, Canada
  • Education
    Not mentioned