Role: Data Migration Analyst

Location: Pune, Maharashtra - Onsite Hybrid

Duration: Full time

Experience: 8+ years

Working Hours: UK time shift

Notice Period: Immediate or 15 days max..

Position Overview:

- Experienced Data Migration Analyst to support enterprise data migration and remediation activities across Microsoft Dynamics ERP and Salesforce environments.
- The Data Migration Analyst will be responsible for reviewing and resolving a backlog of data issues, performing data analysis and cleansing, preparing migration files, executing data migrations using Microsoft Dynamics ERP in-built data management tools and ExcelConnect/Excel-based Salesforce migration tools, and validating/reconciling migrated data.
- The ideal candidate is highly detail-oriented, hands-on with data, comfortable working with large Excel files and ERP/CRM data, and able to independently investigate data issues through resolution.
- This is an execution-focused role requiring strong data analysis, migration, troubleshooting, and business-user collaboration skills.

Required Skills & Experience:

- 5-7 years of experience in data migration, data analysis, data conversion, data quality, or related roles.
- Practical experience using Dynamics ERP in-built data migration/data management tools.
- Hands-on experience with ExcelConnect or equivalent Excel-based batch-upload migrations.
- Strong experience with data cleansing, transformation, validation, and reconciliation.
- Experience troubleshooting data migration errors and exceptions.
- Ability to work through a large backlog of data issues systematically.
- Ability to work independently and meet migration deadlines.

Key Responsibilities: 1. Data Issue Backlog Management

- Review and analyze the existing data issues backlog.




- Categorize issues by data domain, source system, severity, root cause, and business impact.
- Investigate data discrepancies across Dynamics ERP, Salesforce, and source files/systems.
- Prioritize issues based on business impact and migration dependencies.
- Track issues through remediation, validation, and closure.
- Maintain clear documentation of root cause and resolution.

2. Data Analysis & Cleansing

- Extract and analyze data from ERP, CRM, spreadsheets, and other source systems.
- Perform data profiling and identify data-quality problems.
- Cleanse, standardize, transform, and enrich data prior to migration.
- Identify duplicates and inconsistent records.
- Validate required fields, formats, codes, relationships, and reference values.
- Perform data comparisons between source and target systems.
- Use Excel extensively for data analysis, manipulation, reconciliation, and migration preparation

3. Data Migration

- Execute data migration activities using Microsoft Dynamics ERP’s built-in data management/data migration tools.
- Prepare data entities/templates for Dynamics migration.
- Import and export data using Dynamics data management capabilities.
- Map source data to Dynamics entities and fields.
- Execute bulk data loads and updates.
- Monitor migration jobs and investigate failed records.
- Troubleshoot validation, mapping, data-type, reference-data,



and relationship errors.
- Perform incremental migration and correction loads.
- Validate migrated data within Dynamics.
- Reconcile source versus target data following each migration cycle.
- Support mock migrations, testing cycles, cutover, and post-go-live remediation.
- Support Salesforce data migration and remediation activities.
- Prepare Salesforce data for migration using approved templates and migration tools.
- Perform data cleansing and transformation before loading.
- Map source fields to Salesforce objects and fields.
- Understand Salesforce relationships and dependencies between objects.
- Manage external IDs and lookup relationships during migration.
- Execute batch uploads and updates.
- Validate migrated records and investigate failed loads.
- Perform post-load reconciliation and data-quality checks.
- Support correction and re-load activities as required.

4. Data Validation & Reconciliation

- Perform pre-migration validation to ensure data is migration-ready.
- Execute post-migration validation against source data.
- Compare record counts, field values, relationships, and key business attributes.
- Identify migration discrepancies.
- Prepare reconciliation reports.
- Investigate and resolve migration exceptions.
- Obtain business validation/sign-off where required.
- Maintain evidence of successful migration and issue resolution.

5. Migration Testing & Execution

- Preparing migration datasets.
- Executing test loads.
- Recording errors and exceptions.
- Remediating failed records.
- Re-running migration loads.
- Supporting UAT data preparation.
- Supporting cutover and production migration.
- Performing post-migration verification.

📌 Data Migration Analyst (Pune)
🏢 Quantum Integrators
📍 Pune