Req ID: 379781

NTT DATA strives to hire exceptional, innovative and passionate individuals who
want to grow with us. If you want to be part of an inclusive, adaptable, and
forward-thinking organization, apply now.

We are currently seeking a SEI - Data Migration Engineer (SWP) (Expanded
Resources) to join our team in Bangalore, Karnātaka (IN-KA), India (IN).

Role Overview
o 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
contemporary data stack.
o 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.
Key Responsibilities
• 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

📌 SEI - Data Migration Engineer (SWP) (Expanded Resources)
🏢 NTT DATA Services
📍 Bengaluru