Data Migration Engineer (SWP Workstream)
NTT DATA (company site, opens in a new tab)5+ yrsGurugramOn-siteDirect career pageEst. 12–20 LPA
Posted 6d ago
Reach people at NTT DATA
People at this company you can reach
Log in to see who works here
Create a free account or log in to see the people at NTT DATA you could write to:
- Recruiters & HR
- People in this function
- Work addresses
Your match
Against your primary resume
Log in to see your match score
Create a free account or log in to unlock your CV match score across:
- Role fit
- Experience
- Industry relevance
Protocol Intelligence
How competitive this role is
Competition
Background fit
Strictness
Log in to see why each signal reads the way it does.
Job description
Structured overview of role & requirements
About This Role
- Own the conversion of complex Informatica PowerCenter workflows into production-equivalent Python extract/load pipelines and dbt transformations.
- Build Airflow orchestration and contribute to GitLab CI/CD, automated testing, and deployment for the migration to a modern data stack.
- Validate large-scale migration outputs through performance troubleshooting and source-to-target row-count reconciliation during SIT/UAT; contribute code reviews and handover documentation.
Minimum Requirements
- Work Experience Required: 5+ years with Informatica PowerCenter; 5+ years with Python and SQL; 3+ years with dbt Core; and 3+ years with Airflow.
- Hands-on expertise in Informatica mappings, sessions, workflows and parameterization; dbt model layering, macros, tests and incremental materializations; and Airflow DAGs and task dependencies.
- Production Python experience with parallelism and batch processing, plus SQL skills for complex joins, window functions and large-dataset aggregations.
- Experience with Oracle Data Pump or SQL Server BCP/BULK INSERT for high-volume data movement.
Ideal Candidate Profile
- Has directly translated complex legacy Informatica workflows into functionally equivalent Python, dbt and Airflow implementations.
- Is suited to high-volume enterprise migrations, including billion-row data movement, reconciliation and production performance troubleshooting.
- Can contribute across implementation and delivery practices such as CI/CD, testing, code reviews and technical handover; database connectivity tools or offshore mentoring are preferred.