Data Migration Engineer; Informatica​/DBT

Select how often (in days) to receive an alert:
Create Alert

Date: Oct 22, 2026

Location: Remote, TX, US

Company: NTT DATA Services

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us.

We are currently seeking a Data Migration Engineer (Informatica/DBT) to join our team remotely in the US.

• 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 Power Center 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.

• 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 SQL Alchemy, , 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 Git Lab 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.

• 5+ years of Informatica Power Center experience - mappings, sessions, workflows, and parameterization
• 3+ years of hands‑on dbt Core experience - model layering, macros, tests, incremental materializations
• Any number of 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

• Experience with SQL Alchemy, , or pyodbc for Python‑based database connectivity
• Experience mentoring junior and mid‑level engineers in offshore delivery models

NTT DATA provides a reasonable range of compensation for U.S.

-based positions. The starting pay range for this remote role is $84,996-$147,563. This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on a number of factors, including the candidate’s actual work location, relevant experience, technical skills, and other qualifications.

This position may also be eligible for incentive compensation based on individual and/or company performance.

This position is eligible for company benefits including medical, dental, and vision insurance with an employer contribution, flexible spending or health savings account, lifeand AD&D…