Senior MS Dynamics CRM Data Migration Developer

Roles & Responsibilities

• Design, develop, and execute enterprise CRM data migration solutions using KingswaySoft and Microsoft SQL Server Integration Services (SSIS).
• Perform data extraction from legacy SQL databases and other source systems.
• Develop ETL processes for transforming, cleansing, validating, and loading data into Microsoft Dynamics CRM/365.
• Analyze source system data structures and map data elements to Dynamics CRM entities and relationships.
• Develop and optimize SQL queries, stored procedures, views, and SSIS packages.
• Migrate both structured and unstructured data, including images, attachments, and correspondences.
• Support Dynamics CRM development activities related to integrations, plugins, workflows, and customizations.
• Conduct data quality assessments and remediation activities.
• Troubleshoot migration and performance issues across development, test, and production environments.
• Collaborate with business analysts, solution architects, developers, and project managers during implementation activities.
• Support mock migrations, validation testing, reconciliation, and production cutover activities.
• Document migration architecture, mappings, transformation logic, and operational procedures.
• Ensure compliance with organizational security and data governance standards.

Required Skills & Experience

• 7+ years of hands-on experience using KingswaySoft for Dynamics CRM/365 data migrations.
• 7+ years of Microsoft Dynamics CRM/365 development experience.
• 10+ years of strong SQL Server and SSIS development experience.
• Demonstrated experience extracting, transforming, and loading data from legacy SQL databases into Dynamics CRM using KingswaySoft.
• Experience working with both structured and unstructured data, including images and correspondences.
• Experience with at least two full-cycle CRM data migration and implementation projects.
• Strong understanding of ETL methodologies, data mapping, and data quality management.
• Experience developing complex SQL queries, stored procedures, and SSIS packages.
• Strong troubleshooting and performance tuning skills.
• Excellent written and verbal communication skills.

Preferred Experience

• Experience within tolling, transportation, utility, or back-office implementation environments preferred but not required.
• Experience with Azure DevOps, CI/CD pipelines, or cloud-based integration technologies is a plus.
• Familiarity with Dynamics CRM security models and data governance practices.