Remote Data Migration Engineer - Python, dbt & Airflow

JobDiva, Inc.; Town of Texas (WI); Remote; USD 81,000 - 135,000; Full time

Benefits offered by this job

Remote work

Job summary

NTT DATA is seeking a Senior Data Migration Engineer to design and implement Python-based extract/load pipelines, dbt transformations, and Airflow orchestration for a large-scale Informatica PowerCenter migration to a modern data stack. This hands-on role emphasizes delivering production-quality, functionally equivalent output at enterprise scale.

The candidate will translate complex Informatica workflows into Python EL scripts, dbt models, and Airflow DAGs, participate in code reviews, and

Qualifications

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

Responsibilities

• Assess Informatica workflows and translate them into Python EL scripts and dbt models.
• Develop Python EL pipelines to land high-volume data into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc and bulk export tools.
• Design and develop dbt transformation models with best practices (layering, macros, incremental, snapshots).
• Develop dbt-native tests and Python unit tests for data quality and correctness.
• Create Airflow DAGs to orchestrate Python EL and dbt scripts end-to-end.
• Contribute to GitLab CI/CD for dbt and Airflow code, including lint gates and automated testing.
• Peer code reviews and troubleshooting performance issues and data discrepancies during SIT/UAT.
• Document runbooks and handover materials.

Skills

Informatica PowerCenter

dbt Core

Airflow

Python

SQL

Oracle Data Pump

SQL Server BCP

Tools

SQLAlchemy

cx_Oracle

pyodbc

Job description

NTT DATA is seeking a Senior Data Migration Engineer to design and implement Python-based extract/load pipelines, dbt transformations, and Airflow orchestration for a large-scale Informatica PowerCenter migration to a modern data stack. This hands-on role emphasizes delivering production-quality, functionally equivalent output at enterprise scale.

The candidate will translate complex Informatica workflows into Python EL scripts, dbt models, and Airflow DAGs, participate in code reviews, and