BENGALURU · FULLTIME
SEI - Data Migration Engineer (SWP) (Expanded Resources)
NTT DATA BUSINESS SOLUTIONS
Bengaluru · onsite · Posted 61d ago
Sourced from
Undisclosed5–10 yrsfulltimeBengaluru
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.5s
- Found the form on Naukri · 10 questions to answer1.3s
- Decided the answers for all of them3.2s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Req ID: phone_number
We are currently seeking a SEI - Data Migration Engineer (SWP) (Expanded Resources) to join our team in Bangalore, Karnataka (IN-KA), India (IN).
Role Overview - 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 modern data stack.
- 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.
- 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 technical feedback to fellow engineers.
- Troubleshoot performance issues and data discrepancies during SIT and UAT, including row-count reconciliation between source Oracle/SQL Server systems and the target warehouse.
- Contribute to technical documentation, runbooks, and handover materials.
- 5+ years of Informatica PowerCenter experience - 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 incorporation with scheduling tool
- 5+ years of Python experience, including production use of parallelism and batch data processing
- 5+ years of SQL experience - complex joins, window functions, aggregations across large datasets
- Experience with Oracle Data Pump (expdp/impdp) or SQL Server BCP / BULK INSERT for high-volume data movement
- Experience with SQLAlchemy, cx_Oracle, or pyodbc for Python-based database connectivity
- Experience mentoring junior and mid-level engineers in offshore delivery models.
Sourced from naukri
Section · 02
Skills
data qualityInformatica PowercenterInformaticaGitlabExportimpdpautomated testingapache airflowdbtAuthoringLINTgitlab ciMappingClient SuccessBankingDatabase ConnectivitydeploymentData MigrationcloudData ProcessingArtificial Intelligence
Section · Company
About NTT DATA Business Solutions
NTT DATA BUSINESS SOLUTIONS
IT Services & Consulting
4k+
employees
1989
37 years old
Hyderabad / Secunderabad, Telangana
India
About
NTT DATA Business Solutions helps clients innovate and transform through expert SAP solutions, advisory, implementation, and managed services.
Industries
IT Services & Consulting
Employee ratings
2,105 reviews
4.1/ 5
Culture
4.0
Career growth
3.5
Work-life
4.0
Employees rate it well for
Work Life Balance176Salary146Senior Management116Work Culture99Work Environment83
Find them on