
Senior Data Migration Engineer
Largeton · Remote
Strong hiring record · median 1 days open
- First seen
- 18 November 2026
- Reposted
- Not since September 2026
- Last checked
- Today · still on the employer's board
All reasons
- No location stated
In its favour
- Posted yesterday
- Still listed on the employer's own board
- Publishes a salary range
Title: Senior Data Migration Engineer
Location: Remote
Experience: 15+ years (Need Very strong candidate)
Client: SEI Investments Company
NOTE: Banking/Investment Banking Domain Candidates needed.
Job Description
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. 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 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.
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 SQL Alchemy, 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.
Required Skills & Experience
- 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
Preferred
- Experience with SQL Alchemy, cx_Oracle, or pyodbc for Python-based database connectivity
- Experience mentoring junior and mid-level engineers in offshore delivery models
More jobs at Largeton
All 23- Senior Integration Developer - API PlatformLargeton · Palm Beach Gardens, FL, United States · USD 55–60/hrtoday
- Networking - Sr Engineer (Control Plane API)Largeton · Remote · USD 65/hrtoday
- QA Engineer- Medical DevicesLargeton · Waltham, MA, MA, United States · USD 60–65/hrtoday
- Product Owner DevopsLargeton · Remote · USD 48–50/hrtoday
- Senior Business Systems AnalystLargeton · Remote · USD 50/hrtoday
Similar roles
- Databricks Migration EngineerConsultNet · South Jordan, UTtoday
- GCP Migration Engineer (Infrastructure)Diverse Lynx · New York, NY · USD 65–67/hryesterday
- GCP Migration Engineer (Infrastructure)Diverse Lynx · New York City NY (5 days onsite)2d ago
- Senior SAS DI Migration EngineerNucleusTeq · Madhya Pradesh, Indiayesterday
- Cloud IaaS-Migration and Engineering-AWSZensar · Pune, Maharashtra, Indiayesterday
- ESX Migration EngineerSunrise Systems · Remote · USD 44–47/hr5d ago