Remote Data Migration Engineer - Informatica to dbt

NTT DATA, Inc.; Austin (TX); Remote; USD 85,000 - 148,000; Full time

Benefits offered by this job

Medical, dental, vision insurance

401k with company match

Paid time off

Life and AD&D insurance

Disability coverage

Employee assistance

Job summary

NTT DATA seeks a Senior Data Migration Engineer (Informatica/DBT) to implement Python-based ETL pipelines, dbt transformations, and Airflow orchestration for a large-scale Informatica migration to a modern data stack. The role emphasizes converting complex Informatica workflows into maintainable Python, dbt, and Airflow components.

The position is remote in the US with a compensation range of $84,996–$147,563 annually.

Qualifications

• 5+ years of Informatica PowerCenter experience
• 3+ years of hands-on dbt Core experience
• Any number of years of Airflow experience - DAG authoring
• 5+ years of Python experience, including production use of parallelism and batch data processing
• 5+ years of SQL experience - complex joins, window functions, large datasets
• Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP / BULK INSERT for high-volume data movement

Responsibilities

• Translate Informatica workflows into Python EL scripts and dbt models
• Develop Python EL pipelines to land high-volume data into target warehouse
• Design dbt transformation models based on mapping logic
• Create dbt native tests and Python unit tests for data quality
• Develop Airflow DAGs to orchestrate Python EL and dbt scripts
• Contribute to GitLab CI/CD for dbt and Airflow code
• Perform peer code reviews and troubleshoot SIT/UAT data issues
• Document runbooks and handover materials

Skills

Python

SQL

Airflow

dbt Core

Informatica PowerCenter

Tools

dbt

SQLAlchemy

cx_Oracle

pyodbc

Oracle Data Pump

SQL Server BCP

Job description

NTT DATA seeks a Senior Data Migration Engineer (Informatica/DBT) to implement Python-based ETL pipelines, dbt transformations, and Airflow orchestration for a large-scale Informatica migration to a modern data stack. The role emphasizes converting complex Informatica workflows into maintainable Python, dbt, and Airflow components.

The position is remote in the US with a compensation range of $84,996–$147,563 annually.