PC Technowledge Center logo

Data Migration Engineer

PC Technowledge Center

5 - 7 years

11 - 14 Lacs

Mumbai

Posted:15 hours ago

Job Description

Role & responsibilities

Role Summary ::

We are looking for an experienced Data Migration Engineer with strong hands-on expertise in migrating large and complex databases from IBM DB2 to PostgreSQL. The role will be responsible for end-to-end migration activities including assessment, data mapping, extraction, transformation, loading, reconciliation, performance optimization, mock migrations and production cutover.

  • Analyze existing DB2 database schemas, tables, relationships, constraints, indexes and data volumes.
  • Perform detailed source-to-target mapping from DB2 to PostgreSQL.
  • Identify DB2-specific data types and database constructs requiring conversion for PostgreSQL.
  • Develop and maintain migration/ETL scripts, SQL and utilities for data extraction, transformation and loading.
  • Migrate master, transactional, historical, reference and audit data while maintaining data relationships and integrity.
  • Handle large-volume data migration using batching, parallel processing and optimized bulk-loading techniques.
  • Implement appropriate handling for:
    • Data type conversions
    • NULL/default values
    • Date and timestamp formats
    • Sequences/identity columns
    • Primary and foreign keys
    • Large objects such as BLOB/CLOB data
    • Special characters and encoding
  • Perform data cleansing and identify duplicate, invalid, inconsistent and orphan records before migration.
  • Develop automated source-to-target reconciliation covering:
    • Record counts
    • Control totals
    • Key business values
    • Referential integrity
    • Critical field-level comparison
  • Implement error logging, rejected-record handling, restart/recovery and reprocessing mechanisms.
  • Optimize SQL and migration jobs to achieve acceptable migration and cutover timelines.
  • Support full and incremental/delta migration where required during coexistence.
  • Conduct multiple mock migration/dress rehearsal cycles before production migration.
  • Prepare and maintain migration runbooks, execution plans, rollback procedures and reconciliation reports.
  • Support production cutover and perform post-migration validation and reconciliation.
  • Work closely with DBAs, application development, architecture, testing, infrastructure and business teams to resolve migration issues.

Required Skills

  • Strong hands-on experience with IBM DB2 and PostgreSQL.
  • Strong knowledge of SQL and database concepts.
  • Practical experience in DB2/Oracle to PostgreSQL migration.
  • Experience with ETL/data migration tools or custom migration frameworks.
  • Strong understanding of data mapping, transformation, cleansing, validation and reconciliation.
  • Experience handling high-volume transactional databases.
  • Knowledge of PostgreSQL bulk-loading and performance-optimization techniques.
  • Experience with Python and/or Shell scripting for migration automation.
  • Strong understanding of database constraints, indexes, sequences, partitions and referential integrity.
  • Ability to troubleshoot migration failures and database performance issues.

Preferred Experience

  • 5+ years of database/data engineering experience.
  • At least 23 years of hands-on data migration experience.
  • Experience completing at least one large DB2/Oracle-to-PostgreSQL production migration is preferred.
  • Experience in financial services or other high-volume transactional systems would be an advantage.
  • Exposure to migration where legacy and new platforms coexist during the transition period is desirable.

Key Deliverables

  1. DB2-to-PostgreSQL source-to-target mapping
  2. Data conversion and transformation rules
  3. Migration scripts/jobs
  4. Data quality and exception reports
  5. Automated reconciliation framework
  6. Mock migration results
  7. Performance and volume test results
  8. Production migration runbook
  9. Cutover and rollback plan
  10. Post-migration reconciliation report

Preferred candidate profile

Other qualifications:

Experience

5+ years of database/data engineering experience.

At least 23 years of hands-on data migration experience.

Budget:

Gender

Notice period

Job Location

Interview process:

Educational Qualification

Skills Required

Data modeling Data integration Modeling Integration Extraction Data migration Indexing Data Mapping

Learn the skills this job asks for

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
PC Technowledge Center logo
PC Technowledge Center

RecommendedJobs for You

PC Technowledge Center logo

Data Migration Engineer

PC Technowledge Center

Mumbai

Naukri Assist logo

Hyderabad, Chennai, Bengaluru

Honeybee Tech Solutions logo

Data Migration Engineer

Honeybee Tech Solutions

Pune

PC Technowledge Center logo

Data Migration Engineer

PC Technowledge Center

Mumbai

Naukri Assist logo

Hyderabad, Chennai, Bengaluru

Honeybee Tech Solutions logo

Data Migration Engineer

Honeybee Tech Solutions

Pune