Remote Azure Data Migration Engineer: Dataverse & DB2

Main Digital

United States

Remote

USD 120,000 - 170,000

Full time

5 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Main Digital is seeking a Senior Data Migration Engineer to lead the technical execution of a complex data migration, enabling IBM BPM and DB2 decommissioning. This hands-on consulting role requires ownership of migration design, delivery, and cross‑team collaboration in a client-facing setting.

You will analyze legacy data, build and validate pipelines, and drive production readiness and stabilization. Strong Azure Data Factory and DB2 skills are essential, with experience in Dataverse/Dynamics

Qualifications

  • Strong hands-on experience extracting and analyzing IBM DB2 data using SQL.
  • Demonstrated experience parsing XML and transforming nested or semi-structured source data into structured staging tables or files.
  • Strong experience designing, developing, deploying, and troubleshooting Azure Data Factory (ADF) pipelines.
  • Experience using Azure SQL and/or Azure Blob Storage as part of staging and migration architectures.
  • Hands-on experience migrating data into Microsoft Dataverse/Dynamics 365, including data loading, deployment, troubleshooting, and production support.
  • Experience defining detailed source-to-target mappings, including column mappings, data-type conversions, transformation rules, keys, relationships, and load sequencing.
  • Demonstrated experience with migration testing, data validation, reconciliation, and data-quality issue resolution.
  • Experience supporting production cutovers, go-live activities, troubleshooting, and post-production stabilization.

Responsibilities

  • Analyze DB2 source data, database structures, and XML content to determine extraction requirements and develop reliable extraction logic.
  • Partner with application teams to investigate and resolve source-data questions, inconsistencies, and undocumented data behaviors.
  • Transform XML and other source data into structured staging tables or files, including handling nested structures, data-type conversions, inconsistent source values, and other data-quality complexities.
  • Design, build, deploy, monitor, and troubleshoot Azure Data Factory pipelines using Azure SQL and/or Azure Blob Storage for staging and Microsoft Dataverse for target loading.
  • Work with target-solution owners to develop and document source-to-target column mappings, transformation rules, keys, entity relationships, dependencies, and load sequencing.
  • Establish validation and reconciliation processes to confirm migration completeness and accuracy.
  • Investigate missing records, failed loads, mapping discrepancies, reconciliation differences, and data-quality issues and drive them through resolution.
  • Execute migration testing across lower environments and coordinate the approved use of appropriately masked production data when production-representative test data is required.
  • Validate migration results and resolve defects before production deployment.
  • Support production migration planning, cutover readiness, go-live execution, reconciliation, troubleshooting, and post-go-live stabilization.
  • Coordinate technical dependencies including environment readiness, service principal permissions, Azure Key Vault access, connectivity, and prerequisites for pipelines.
  • Collaborate across teams to resolve migration design decisions and technical dependencies.
  • Create and maintain migration mappings, technical documentation, validation procedures, and repeatable migration processes.
  • Proactively communicate migration risks, blockers, dependencies, data-quality concerns, and recommended solutions to Main Digital and client stakeholders.

Skills

IBM DB2 data extraction
XML parsing and data transformation
Azure Data Factory pipelines
Azure SQL / Azure Blob Storage
Dataverse / Dynamics 365 data loads
Source-to-target mapping design
Migration testing & data validation
Production cutovers & go-live support
Azure Key Vault & service principal
Cross‑team collaboration & client‑faci

Tools

Azure Data Factory
Azure SQL
Azure Blob Storage
Dataverse/Dynamics 365

Job description

Main Digital is seeking a Senior Data Migration Engineer to lead the technical execution of a complex data migration, enabling IBM BPM and DB2 decommissioning. This hands-on consulting role requires ownership of migration design, delivery, and cross‑team collaboration in a client-facing setting.

You will analyze legacy data, build and validate pipelines, and drive production readiness and stabilization. Strong Azure Data Factory and DB2 skills are essential, with experience in Dataverse/Dynamics

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Migration Engineer, Azure & Dataverse
Senior Data Migration Engineer, Azure & Dataverse

Main Digital • United States

Remote
USD 120,000 - 170,000
Remote Senior Data Engineer — IBM DB2 Legacy Modernization
Remote Senior Data Engineer — IBM DB2 Legacy Modernization

Software Estratégico • United States

Remote
USD 120,000 - 180,000
Senior DB2 DBA - Remote, Cloud Migration & Modernization
Senior DB2 DBA - Remote, Cloud Migration & Modernization

IDR, Inc. • Austin (TX)

Remote
USD 110,000 - 140,000
Full Benefits; Medical, Vision, Dental
Competitive compensation package
Employee Stock Ownership Program
Senior DB2 Engineer - Databricks Migration Expert (Remote)
Senior DB2 Engineer - Databricks Migration Expert (Remote)

Tata Consultancy Services Limited • Oregon

Hybrid
USD 100,000 - 130,000
Discretionary annual incentive
Comprehensive medical coverage
Dental & Vision coverage
+1
1873 Sr Data Engineer – IBM DB2
1873 Sr Data Engineer – IBM DB2

Software Estratégico • United States

Remote
USD 120,000 - 180,000
Remote Senior DB2 to Databricks Migration Lead
Remote Senior DB2 to Databricks Migration Lead

Tata Consultancy Services Limited • Oregon

Hybrid
USD 120,000 - 150,000
Discretionary Annual Incentive
Comprehensive Medical Coverage
Family Support Leaves
+3
Data Migration Specialist
Data Migration Specialist

Pi Square Technologies • United States

Remote
USD 90,000 - 130,000
DB2 Warehouse Architect – AWS Data Migration
DB2 Warehouse Architect – AWS Data Migration

Expedite Talent Solutions • Lincoln (NE)

On-site
USD 90,000 - 120,000
Senior Mainframe DB2 Tools Architect
Senior Mainframe DB2 Tools Architect

TechDigital Group • Texas

Hybrid
USD 120,000 - 155,000
Db2-databricks Consulting Partner
Db2-databricks Consulting Partner

Tata Consultancy Services Limited • Oregon

Hybrid
USD 120,000 - 150,000
Discretionary Annual Incentive
Comprehensive Medical Coverage
Family Support Leaves
+3