Data Migration Engineer

Overall Experience: 7+ years

Mandatory: Proven data migration experience across Core systems.

Role Overview

The Migration Engineer will be responsible for planning, designing, executing, and validating end to end data migration activities across on premise and cloud environments. The role requires strong hands on expertise in ETL, database technologies, and migration frameworks, along with the ability to handle complex data transformation and modernization journeys.

Key Responsibilities

• Design and execute data migration strategies, including extraction, transformation, validation, and loading (ETL).
• Work hands on with SSIS, Oracle, MS SQL Server, and PostgreSQL to deliver high quality migration outcomes.
• Perform impact analysis, data mapping, and reconciliation to ensure data accuracy and completeness.
• Optimize and troubleshoot ETL jobs, SQL queries, pipelines, and batch processes.
• Support full migration lifecycle including assessment, planning, execution, testing, cutover, and post migration validation.
• Collaborate with cross functional teams, including application owners, infrastructure teams, and business SMEs.
• Prepare documentation such as data mapping sheets, migration checklists, and validation reports.
• Ensure compliance with internal controls, data governance, and audit requirements.
• Participate in migration projects involving on premises to Cloud (AWS/Azure) migrations where applicable.
• Communicate clearly with internal stakeholders and external partners on migration progress, risks, and dependencies.
  
  

Skills

• Strong hands-on experience in:
• SSIS
• Oracle
• MS SQL Server (MSSQL)
• PostgreSQL
• Solid understanding of ETL concepts and data transformation logic.
• Proven experience in end-to-end migration projects.
• Strong SQL programming, performance tuning, and debugging skills.
• Ability to work independently and manage complex workloads.
• Excellent communication and stakeholder coordination skills.
  
  

Good To Have Skills

• Experience with other ETL tools (Informatica, DataStage, Talend, etc.).
• Exposure to .NET technologies for custom components or automation.
• Experience with OBIEE reporting environments.
• Hands on expertise in cloud migrations involving AWS or Azure (preferred).
• Understanding of CI/CD pipelines, DevOps, or script-based automation.
  
  

Qualifications

• Bachelor’s degree in computer science, Engineering, Information Technology, or related field.
• Relevant certifications in databases, ETL tools, or cloud platforms (preferred).