Senior ETL Software Developer

Overview

On Site
$80 - $80
Accepts corp to corp applications
Contract - 12 month(s)
No Travel Required

Skills

ETL Software Developer

Job Details

Job Description:

Requirement/Must Have:

  • 5+ years of proven working experience in an ETL role, with a strong understanding of ETL principles (data extraction, transformation, and loading).
  • Strong SQL skills and experience with Azure SQL Databases and Dataverse.
  • Knowledge of Microsoft Dynamics 365 Customer Engagement (CE).
Experience:
  • Experience with data migration from legacy applications to Dynamics 365 CE.
  • Experience with ETL development, data pipelines, workflow orchestration, and integrating various data sources (on-premises and cloud) using Azure ETL services.
  • Experience working with Azure Synapse workspaces, including pipelines, data flows, integration runtimes, triggers, and monitoring.
  • Experience designing, implementing, and supporting automated data migration testing solutions for Dynamics 365.
  • Experience with SQL Server, Azure SQL Databases, and Dataverse.
  • Experience conducting application data migration testing or data quality testing for Dynamics 365 model-driven apps.
Responsibilities:
  • Analyze data in legacy applications to understand structure, quality, and relationships.
  • Review existing migration code to determine mapping from legacy systems to Dynamics 365 CE.
  • Conduct thorough testing to verify data migration accuracy and integrity.
  • Define test cases, perform data reconciliation, and resolve issues or discrepancies.
  • Develop KPIs to track migration progress, completeness, and quality.
  • Create comprehensive test plans, test cases, and scripts for data migration.
  • Modify the migration code to address data issues.
  • Maintain detailed documentation of test activities and results.
  • Provide post-migration support and optimize data management processes.
  • Ensure compliance with security, architecture, and technology standards.
  • Transfer knowledge to designated staff.
Should Have:
  • Azure cloud certifications (Azure Fundamentals, Azure Data Engineer Associate, Azure Database Administrator Associate).
  • Familiarity with Dataverse / Common Data Service (CDS), data entities, APIs, and Azure storage technologies.
  • Expertise in data cleansing, aggregation, enrichment, and normalization using Azure cloud technologies.
  • Understanding of data governance, privacy regulations, and best practices for data security and compliance.
  • Familiarity with version control systems (Azure Repos) and collaboration tools (Azure DevOps).
  • Experience with CI/CD processes for data workflows and Synapse workspaces.
  • Experience with SQL Server Candidateagement Studio, Azure data management tools, and XRM Toolbox.
Qualification and Education:
  • Bachelor s degree in Computer Science, Information Technology, or a related field (or equivalent experience).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.