Job Title:  Manager | Data Migration Specialist | Delhi | Operations, Industry & Domain Solutions | DigiGov

Key Responsibilities

Data Migration Planning & Execution

• Analyze source and target systems to define migration strategies, approaches, and execution plans.
• Perform data discovery, profiling, and assessment activities to identify migration challenges and dependencies.
• Design and execute end-to-end data migration processes including extraction, transformation, cleansing, loading, and validation.
• Develop migration runbooks, cutover plans, rollback procedures, and migration schedules.
• Support multiple migration cycles including mock migrations, testing, and production cutovers.
• Ensure minimal business disruption during migration activities.

Data Mapping & Transformation

• Collaborate with business and technical teams to define source-to-target mapping rules.
• Design and implement data transformation, standardization, and cleansing processes.
• Handle complex data conversions, schema transformations, and data enrichment requirements.
• Resolve data inconsistencies, duplication issues, and quality concerns prior to migration.

Validation & Reconciliation

• Develop automated reconciliation and validation processes to verify migrated data.
• Perform data quality checks and exception management.
• Identify, investigate, and resolve migration-related issues.
• Produce migration audit reports and validation documentation.

Technical Delivery

• Build and maintain migration utilities, scripts, and automation frameworks.
• Optimize migration performance for large-volume datasets.
• Support migration activities involving structured, semi-structured, and legacy data sources.
• Collaborate with infrastructure and application teams during deployment and cutover activities.

Stakeholder Collaboration

• Work closely with business users, application owners, data architects, and project managers.
• Communicate migration risks, dependencies, and progress to stakeholders.
• Provide recommendations for improving migration efficiency and reducing operational risks.

Required Experience

• 6–12+ years of experience in Data Migration, Data Engineering, ETL Development, or Database Administration.
• Proven experience delivering large-scale data migration projects across enterprise applications and databases.
• Strong understanding of migration lifecycle, cutover planning, validation, and reconciliation processes.
• Experience working with legacy systems, ERP/CRM migrations, cloud migrations, or application modernization initiatives.
• Ability to manage complex migration scenarios involving large data volumes and multiple source systems.

Technical Skills

Databases

• PostgreSQL
• MySQL / MariaDB
• SQL Server
• Oracle
• MongoDB or other NoSQL databases

Open Source Technologies (Preferred)

• Apache NiFi
• Talend Open Studio
• Pentaho Data Integration (Kettle)
• Apache Airflow
• Debezium
• Kafka
• Apache Spark

Data Engineering & ETL

• Data Extraction, Transformation, and Loading (ETL/ELT)
• Data Profiling and Data Quality Assessment
• Data Cleansing and Standardization
• Data Reconciliation and Validation
• Batch and Incremental Data Migration

Programming & Scripting

• SQL
• Python
• Shell Scripting (Linux)
• PySpark (preferred)

Cloud Platforms (Preferred)

• AWS
• Azure
• Google Cloud Platform

Migration Methodologies

• Source-to-Target Mapping
• Data Quality Frameworks
• Migration Testing
• Mock Cutovers
• Production Cutover Planning
• Rollback and Recovery Procedures

Preferred Qualifications

• Experience with open-source data integration and migration frameworks.
• Experience migrating data between on-premise and cloud environments.
• Exposure to ERP, CRM, HRMS, Finance, or Supply Chain application migrations.
• Familiarity with data governance, audit, and compliance requirements.
• Knowledge of Change Data Capture (CDC) and real-time migration approaches.
• Experience with large-scale modernization or platform consolidation programs.

What Success Looks Like

• Delivers data migrations with high accuracy, minimal downtime, and complete traceability.
• Ensures data integrity and reconciliation across all migration phases.
• Identifies migration risks proactively and develops effective mitigation strategies.
• Automates migration and validation processes to improve efficiency and reliability.
• Serves as a trusted technical expert for complex migration and data conversion initiatives.