Senior Data Migration Engineer
Core
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.
Role type
Senior Data Migration Engineer
Builds
Production data pipelines and transformation models migrating enterprise data from legacy Informatica workflows to modern cloud warehouses
Domain
Data Engineering / ETL / Data Migration
Required skills
Informatica PowerCenter, Python, dbt Core, Apache Airflow, SQL, Oracle Data Pump, SQL Server BCP
Preferred skills
SQLAlchemy, cx_Oracle, pyodbc, mentoring junior engineers
Technologies
Python, dbt, Airflow, GitLab CI/CD, Oracle, SQL Server, NAS
Responsibilities
Translate complex Informatica workflows into Python EL scripts and dbt models; Develop and maintain high-volume Python EL pipelines; Design dbt transformation models with best practices; Develop Airflow DAGs for end-to-end orchestration; Contribute to GitLab CI/CD pipelines; Perform peer code reviews; Troubleshoot performance issues and data discrepancies; Contribute to technical documentation
Seniority
Senior, hands-on IC