Senior Remote Data Migration Engineer: Informatica to dbt

NTT DATA, Inc.; Oregon; Hybrid; USD 120,000 - 170,000; Full time

Job summary

NTT DATA, Inc. is seeking a Senior Data Migration Engineer (Informatica/DBT) to join our team remotely in the US.

This hands-on role designs and implements 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. The engineer will convert Informatica workflows into Python, dbt, and Airflow, delivering production-quality, functionally equivalent output at enterprise scale while

Qualifications

• 5+ years of Informatica PowerCenter experience including 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 scheduling integration.
• 5+ years of Python experience, including production use of parallelism and batch data processing.
• 5+ years of SQL experience with complex joins, window functions, and large datasets.
• Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP / BULK INSERT for high-volume data movement.

Responsibilities

• Translate complex Informatica workflows into Python EL scripts and dbt transformation models.
• Develop and maintain Python EL pipelines to land high-volume data into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc.
• Design and develop dbt transformation models with best practices including layering, macros, incremental strategies, and snapshot patterns.
• Develop dbt-native tests and custom Python unit tests to validate transformations and data quality.
• Create Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end, ensuring production-quality outputs.
• Contribute to GitLab CI/CD pipelines for dbt and Airflow with lint gates, tests, and deployments.
• Perform peer code reviews and provide technical feedback to engineers.
• Troubleshoot performance issues and data discrepancies during SIT/UAT, reconciling row counts between source and target.
• Contribute to technical docs, runbooks, and handover materials.

Skills

Informatica PowerCenter

dbt Core

Airflow

Python

SQL

Oracle Data Pump/BCP

Tools

SQLAlchemy

cx_Oracle

pyodbc

Job description

NTT DATA, Inc. is seeking a Senior Data Migration Engineer (Informatica/DBT) to join our team remotely in the US.

This hands-on role designs and implements 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. The engineer will convert Informatica workflows into Python, dbt, and Airflow, delivering production-quality, functionally equivalent output at enterprise scale while