Dynamics 365 CRM Data Migration Consultant

Appworkshub; New York (NY); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Appworkshub is seeking an experienced Dynamics 365 CRM Data Migration Consultant to lead legacy mainframe data migration projects into Dynamics 365 CRM. You will extract data from mainframe systems into SQL databases and transform it for a clean CRM implementation.

This customer-facing role requires strong communication, stakeholder collaboration, and the ability to design ETL processes, validate data, and manage migration timelines with minimal supervision.

Qualifications

• Strong experience in data migration projects, especially legacy systems to Dynamics CRM.
• Hands-on data extraction from mainframe systems into SQL databases.
• Experience with Microsoft Dynamics 365 CRM data migration.
• Strong SQL skills including data transformation and validation.
• Experience with ETL tools such as SSIS, Azure Data Factory, or similar.
• Knowledge of data cleansing, mapping, and reconciliation techniques.
• Excellent communication and customer-facing skills.
• Ability to work independently and manage migration timelines.

Responsibilities

• Analyze legacy mainframe data structures and identify migration requirements.
• Extract data from mainframe systems and load into SQL Server or staging databases.
• Cleanse, transform, and map data for migration into Microsoft Dynamics 365 CRM.
• Design and implement ETL processes using appropriate migration tools and scripts.
• Validate data accuracy and ensure successful migration into Dynamics CRM.
• Work closely with business users to understand data requirements and validation criteria.
• Provide migration planning, timelines, and risk mitigation strategies.
• Troubleshoot migration issues and optimize data migration performance.
• Document migration processes, mapping documents, and data validation results.
• Participate in client meetings and provide regular status updates.

Skills

Legacy data migration

Mainframe data extraction

COBOL/VSAM/DB2 knowledge

SQL data transformation

Dynamics 365 CRM data migration

ETL tools (SSIS/Azure Data Factory)

Data cleansing & mapping

Communication / client-facing

Independent work / timeline management

Tools

SSIS

Azure Data Factory

SQL Server

Job description

Dynamics 365 CRM Data Migration Consultant

Data Migration Consultant (Mainframe to Dynamics 365 CRM)

We are seeking an experienced Data Migration Consultant with strong expertise in migrating legacy mainframe data to Microsoft Dynamics 365 CRM. The ideal candidate should have hands‑on experience extracting data from mainframe systems into SQL databases and transforming it for Dynamics CRM implementation. This role is customer‑facing and requires strong communication skills and the ability to work closely with stakeholders. The position is based in New Jersey, supporting a client located in New York.

Key Responsibilities

• Analyze legacy mainframe data structures and identify migration requirements.
• Extract data from mainframe systems and load into SQL Server or staging databases.
• Cleanse, transform, and map data for migration into Microsoft Dynamics 365 CRM.
• Design and implement ETL processes using appropriate migration tools and scripts.
• Validate data accuracy and ensure successful migration into Dynamics CRM.
• Work closely with business users to understand data requirements and validation criteria.
• Provide migration planning, timelines, and risk mitigation strategies.
• Troubleshoot migration issues and optimize data migration performance.
• Document migration processes, mapping documents, and data validation results.
• Participate in client meetings and provide regular status updates.

Required Skills & Qualifications

• Strong experience in data migration projects, especially legacy system to Dynamics CRM.
• Basic understanding of Mainframe systems (COBOL files, VSAM, DB2, etc.).
• Hands‑on experience extracting data from mainframe systems into SQL databases.
• Experience with Microsoft Dynamics 365 CRM data migration.
• Strong SQL skills including data transformation and validation.
• Experience with ETL tools such as SSIS, Azure Data Factory, or similar.
• Knowledge of data cleansing, mapping, and reconciliation techniques.
• Excellent communication and customer‑facing skills.
• Ability to work independently and manage migration timelines.

Preferred Qualifications

• Experience with public sector or large enterprise migrations.
• Experience with Azure integration tools and Power Platform.
• Microsoft Dynamics or Azure certifications.
• Experience with data governance and data quality frameworks.