CrawlJobs Logo

Senior Data Migration Engineer

India, Gurgaon · Job Posted June 15, 2026
Apply Position
Job Link Share

Job Description

The Senior Data Migration Engineer serves as a hands-on technical contributor and delivery anchor, responsible for designing and implementing Python-based extract/load pipelines, dbt-based transformations, and Airflow-based orchestration for a large-scale migration from Informatica PowerCenter to a modern data stack. This role requires deep expertise in converting complex Informatica workflows into Python, dbt, and Airflow, and the ability to deliver production-quality, functionally equivalent output at enterprise scale.

Job Responsibility

  • Assess complex Informatica workflows including sessions, mappings, and parameterizations and translate them into equivalent Python EL scripts and dbt transformation models
  • Develop and maintain Python EL pipelines to land high-volume data, including billion-row tables, into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools such as Oracle Data Pump and SQL Server BCP
  • Design and develop dbt transformation models based on Informatica mapping logic, incorporating dbt best practices including model layering, macros, incremental strategies, and snapshot patterns
  • Develop dbt-native tests as well as custom Python unit tests to validate transformation correctness and data quality
  • Develop Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end, producing output that is functionally equivalent to the source Informatica workflows
  • Contribute to GitLab CI/CD pipeline for dbt and Airflow code, including lint gates, automated testing, and deployment to shared NAS
  • Perform peer code reviews and provide constructive technical feedback to fellow engineers
  • Troubleshoot performance issues and data discrepancies during SIT and UAT, including row-count reconciliation between source Oracle/SQL Server systems and the target warehouse
  • Contribute to technical documentation, runbooks, and handover materials

Requirements

  • 5+ years of Informatica PowerCenter experience - mappings, sessions, workflows, and parameterization
  • 3+ years of hands-on dbt Core experience - model layering, macros, tests, incremental materializations
  • 3+ years of Airflow experience - DAG authoring, task dependencies, and incorporation with scheduling tool
  • 5+ years of Python experience, including production use of parallelism and batch data processing
  • 5+ years of SQL experience - complex joins, window functions, aggregations across large datasets
  • Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP / BULK INSERT for high-volume data movement

Nice to have

  • Experience with SQLAlchemy, cx_Oracle, or pyodbc for Python-based database connectivity
  • Experience mentoring junior and mid-level engineers in offshore delivery models

Looking for more opportunities?

Search for other job offers that match your skills and interests.

Similar Jobs for

Senior Data Migration Engineer

8 matching positions

Senior Data Migration Engineer

We are currently seeking a Senior Data Migration Engineer to join our team in Ba...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of Informatica PowerCenter experience - mappings, sessions, workflows, and parameterization
  • 3+ years of hands-on dbt Core experience - model layering, macros, tests, incremental materializations
  • 3+ years of Airflow experience - DAG authoring, task dependencies, and incorporation with scheduling tool
  • 5+ years of Python experience, including production use of parallelism and batch data processing
  • 5+ years of SQL experience - complex joins, window functions, aggregations across large datasets
  • Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP / BULK INSERT for high-volume data movement
Job Responsibility
Job Responsibility
  • Assess complex Informatica workflows including sessions, mappings, and parameterizations and translate them into equivalent Python EL scripts and dbt transformation models
  • Develop and maintain Python EL pipelines to land high-volume data, including billion-row tables, into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools such as Oracle Data Pump and SQL Server BCP
  • Design and develop dbt transformation models based on Informatica mapping logic, incorporating dbt best practices including model layering, macros, incremental strategies, and snapshot patterns
  • Develop dbt-native tests as well as custom Python unit tests to validate transformation correctness and data quality
  • Develop Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end, producing output that is functionally equivalent to the source Informatica workflows
  • Contribute to GitLab CI/CD pipeline for dbt and Airflow code, including lint gates, automated testing, and deployment to shared NAS
  • Perform peer code reviews and provide constructive technical feedback to fellow engineers
  • Troubleshoot performance issues and data discrepancies during SIT and UAT, including row-count reconciliation between source Oracle/SQL Server systems and the target warehouse
  • Contribute to technical documentation, runbooks, and handover materials
  • Fulltime
Read More
Arrow Right

Senior Data Migration Engineer

We are currently seeking a Senior Data Migration Engineer to join our team in Ba...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of Informatica PowerCenter experience - mappings, sessions, workflows, and parameterization
  • 3+ years of hands-on dbt Core experience - model layering, macros, tests, incremental materializations
  • 3+ years of Airflow experience - DAG authoring, task dependencies, and incorporation with scheduling tool
  • 5+ years of Python experience, including production use of parallelism and batch data processing
  • 5+ years of SQL experience - complex joins, window functions, aggregations across large datasets
  • Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP / BULK INSERT for high-volume data movement
Job Responsibility
Job Responsibility
  • Assess complex Informatica workflows including sessions, mappings, and parameterizations and translate them into equivalent Python EL scripts and dbt transformation models
  • Develop and maintain Python EL pipelines to land high-volume data, including billion-row tables, into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools such as Oracle Data Pump and SQL Server BCP
  • Design and develop dbt transformation models based on Informatica mapping logic, incorporating dbt best practices including model layering, macros, incremental strategies, and snapshot patterns
  • Develop dbt-native tests as well as custom Python unit tests to validate transformation correctness and data quality
  • Develop Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end, producing output that is functionally equivalent to the source Informatica workflows
  • Contribute to GitLab CI/CD pipeline for dbt and Airflow code, including lint gates, automated testing, and deployment to shared NAS
  • Perform peer code reviews and provide constructive technical feedback to fellow engineers
  • Troubleshoot performance issues and data discrepancies during SIT and UAT, including row-count reconciliation between source Oracle/SQL Server systems and the target warehouse
  • Contribute to technical documentation, runbooks, and handover materials
Read More
Arrow Right

Senior Data Migration Engineer

We are currently seeking a Senior Data Migration Engineer to join our team in Ba...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of Informatica PowerCenter experience - mappings, sessions, workflows, and parameterization
  • 3+ years of hands-on dbt Core experience - model layering, macros, tests, incremental materializations
  • 3+ years of Airflow experience - DAG authoring, task dependencies, and incorporation with scheduling tool
  • 5+ years of Python experience, including production use of parallelism and batch data processing
  • 5+ years of SQL experience - complex joins, window functions, aggregations across large datasets
  • Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP / BULK INSERT for high-volume data movement
Job Responsibility
Job Responsibility
  • Assess complex Informatica workflows including sessions, mappings, and parameterizations and translate them into equivalent Python EL scripts and dbt transformation models
  • Develop and maintain Python EL pipelines to land high-volume data, including billion-row tables, into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc, and bulk export tools such as Oracle Data Pump and SQL Server BCP
  • Design and develop dbt transformation models based on Informatica mapping logic, incorporating dbt best practices including model layering, macros, incremental strategies, and snapshot patterns
  • Develop dbt-native tests as well as custom Python unit tests to validate transformation correctness and data quality
  • Develop Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end, producing output that is functionally equivalent to the source Informatica workflows
  • Contribute to GitLab CI/CD pipeline for dbt and Airflow code, including lint gates, automated testing, and deployment to shared NAS
  • Perform peer code reviews and provide constructive technical feedback to fellow engineers
  • Troubleshoot performance issues and data discrepancies during SIT and UAT, including row-count reconciliation between source Oracle/SQL Server systems and the target warehouse
  • Contribute to technical documentation, runbooks, and handover materials
Read More
Arrow Right

Senior Data Migration Engineer

As a Senior Data Migration Engineer, you will be a core execution member of the ...
Location
Location
Poland , Wrocław; Bielsko-Biała
Salary
Salary:
135.00 - 170.00 PLN / Hour
cshark.com Logo
Cshark
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Proven experience with large-scale data migration projects: ETL or systems integration on enterprise-scale projects, transformation pipelines, cutover planning
  • Experience working with XML-based data transformation (mapping files, XSLT, or equivalent config-driven ETL)
  • Proven ability to diagnose complex migration errors under time pressure: root-cause analysis, staging data fixes, re-run coordination
  • Experience coordinating with business stakeholders during UAT and cutover
  • clear written and verbal communication in English
  • Experience with legacy database analysis: reverse-engineering un(der)documented schemas, understanding data semantics and relationships without complete documentation and dealing with corrupted or ambiguous data or metadata
  • Comfortable working with SQL at an advanced level: complex queries, schema analysis, data profiling, and diagnosing data quality issues
  • Strong proficiency in SQL across at least two of: PostgreSQL, Oracle, SQL Server, DB2
  • Solid Java skills (Java 21 ecosystem preferred)
  • comfortable building and extending internal tooling – data pipelines, automation scripts, validation frameworks – with clean, testable code
Job Responsibility
Job Responsibility
  • Work hands-on across the full migration lifecycle – from extraction and mapping through conversion, validation, and cutover
  • Actively building the tooling and accelerators that make future migrations faster and safer (e.g.: artifact observability, version-controlled mapping pipelines, automated validation checks, and reusable migration templates)
  • Shape the process, own the tooling, and directly influence delivery velocity
  • Mentor and technically lead parallel migration teams
What we offer
What we offer
  • 100% remote work
  • Flexible hours
  • International projects
  • Business english lessons
  • Participation in charity actions
  • In-house technology workshops
  • Fulltime
Read More
Arrow Right

Senior Data Engineer, Big Data

This role is essential for designing and developing data architectures across on...
Location
Location
United States , New York; Philadelphia
Salary
Salary:
105100.00 - 189600.00 USD / Year
https://www.t-mobile.com Logo
T-Mobile
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor's Degree plus 5 years of related work experience OR Advanced degree with 3 years of related experience
  • 4-7 years Developing cloud solutions using data series
  • experience with cloud platforms (Amazon Web Services, Azure, or Google Cloud)
  • 4-7 years Hands-on development using and migrating data to cloud platforms
  • 4-7 years Experience in SQL, NoSQL, and/or relational database design and development
  • 4-7 years Advanced knowledge and experience in building complex data pipelines with Python, Experience in languages such as SQL, DAX Python, Java, Scala, and/or Go
  • At least 18 years of age
  • Legally authorized to work in the United States
Job Responsibility
Job Responsibility
  • Develop data engineering solutions that enable data pipelines, visualization, and analytical tools to support business requirements
  • Design and develop data architectures across on-premise, cloud, and hybrid platforms to ensure scalable data infrastructure
  • Perform data wrangling, exploration, and discovery of heterogeneous data to generate new business insights
  • Contribute to team knowledge sharing and drive the advancement of new data engineering capabilities
  • Mentor team members to build and enhance their data engineering skillsets and professional growth
  • Assist management in project definition, including estimating, planning, and scoping work to meet objectives
  • Also responsible for other duties/projects as assigned by business management as needed
What we offer
What we offer
  • annual stock grant
  • employee stock purchase plan
  • 401(k)
  • free, year-round money coaches
  • medical insurance
  • dental insurance
  • vision insurance
  • flexible spending account
  • paid time off
  • up to 12 paid holidays
  • Fulltime
Read More
Arrow Right

Senior Data Engineer (with Data Analyst skills)

As a Senior Data Engineer (with Data Analyst skills), your primary task will be ...
Location
Location
Ukraine
Salary
Salary:
Not provided
n-ix.com Logo
N-iX
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • You have 4+ years of relevant work experience as a Data Analytics Engineer
  • You are analytical, curious, and detail-oriented
  • You get energy from diverse work and solving complex data questions
  • You have extensive knowledge of SQL or other languages. Preferably experience with GTM, A/B testing, and dashboarding
  • Strong communication skills - you can explain insights and analytical solutions to technical and non-technical stakeholders
  • High motivation, proactiveness, and a genuine enthusiasm for data and product analytics
  • English level - at least Upper-Intermediate, both spoken and written
Job Responsibility
Job Responsibility
  • Migrating dashboards and underpinning analytics models from (Snowflake, dbt, Qlik) to (AWS, python) data platform
  • Measuring the effectiveness of a new feature on the platform
  • Analyzing and advising on the customer journey (of B2B and B2C customers)
  • Analyzing the effectiveness of website personalization
  • Maintaining the tag management system and Snowplow data models in DBT/SQL
What we offer
What we offer
  • Flexible working format - remote, office-based or flexible
  • A competitive salary and good compensation package
  • Personalized career growth
  • Professional development tools (mentorship program, tech talks and trainings, centers of excellence, and more)
  • Active tech communities with regular knowledge sharing
  • Education reimbursement
  • Memorable anniversary presents
  • Corporate events and team buildings
  • Other location-specific benefits
Read More
Arrow Right

Senior Data Engineer

Senior Data Engineer. Must Haves: Strong hands-on experience building and suppor...
Location
Location
United States , Los Angeles
Salary
Salary:
Not provided
bhsg.com Logo
Beacon Hill
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Strong hands-on experience building and supporting production-grade data pipelines using PySpark and Apache Spark
  • Extensive experience working within Databricks environments
  • Experience with Databricks Unity Catalog migrations and modernization initiatives
  • Experience with Databricks Unity Catalog governance and security models
  • Strong understanding of ETL/ELT design, data modeling, and incremental data processing
  • Experience modernizing legacy data platforms and data migration projects
  • Experience working with large-scale datasets in cloud-based data platforms
  • Experience with workflow orchestration, scheduling, and pipeline automation
  • Knowledge of cloud data platforms such as Snowflake and/or Google Cloud
  • Experience implementing data quality checks, monitoring, logging, and alerting
Job Responsibility
Job Responsibility
  • Migrate existing data assets and pipelines to Databricks Unity Catalog
  • Refactor and optimize existing pipelines using modern engineering standards and best practices
  • Build and maintain scalable PySpark-based data pipelines
  • Develop new source-of-truth datasets and modernize legacy data workflows
  • Design and implement workflow orchestration using Databricks Jobs
  • Deploy and manage pipelines using Databricks Asset Bundles
  • Ensure data pipelines are reliable, observable, and production-ready
  • Implement data quality controls, monitoring, and operational alerting
  • Support platform migrations, testing, validation, and production cutovers
  • Partner with engineering teams to improve platform stability, scalability, and data reliability
  • Fulltime
Read More
Arrow Right

Senior Data Engineer

We're looking for an experienced Senior Data Engineer to lead the design, develo...
Location
Location
United Kingdom; Netherlands; Germany; Sweden , Luton; Rijswijk; Hanover; Stockholm
Salary
Salary:
Not provided
https://www.tui.com Logo
TUI
Expiration Date
June 22, 2026
Flip Icon
Requirements
Requirements
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field, or equivalent professional experience in data engineering or software development
  • Master's degree in Computer Science, Data Science, or related field would be beneficial
  • Proven experience in data engineering and leading technical teams
  • Strong data engineering skills including SQL and Python, with experience managing codebases, CI/CD pipelines, and code reviews
  • Knowledge of cloud-based data systems such as Google Cloud Platform and cloud storage solutions like Snowflake/AWS
  • Deep understanding of data pipeline design, ETL processes, and data integration tools
  • Expertise in relational and NoSQL databases
  • Knowledge of data quality assurance methodologies
  • Excellent problem-solving, analytical, communication, and leadership skills
  • Professional certifications in cloud platforms
Job Responsibility
Job Responsibility
  • Lead the design and implementation of data pipelines and integration processes for customer and marketing data from digital sales channels
  • Design scalable ETL processes for analytics data
  • Develop data integration solutions between various platforms
  • Implement data transformation and enrichment processes
  • Establish and maintain data quality frameworks
  • Develop automated data quality checks and validation processes
  • Implement monitoring systems for data pipeline health
  • Create documentation and standards for data quality assurance
  • Collaborate with the Architect to implement technical designs
  • Translate architectural designs into implementation plans
What we offer
What we offer
  • Attractive remuneration
  • Discretionary bonus schemes
  • Generous travel benefits
  • Extensive health & well-being support
  • Flexible working
  • Access the TUI Learning Hub
  • Opportunities to work on global projects and teams
  • Local charity and sustainability initiatives
  • Fulltime
!
Read More
Arrow Right