Data Migration Engineer

Role Overview

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:
• o SSIS
• o Oracle

o MS SQL Server (MSSQL)

• o 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)