Data Engineer Advisor

About the role

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.

What you'll do

• Assess complex Informatica workflows including sessions, mappings, and parameterizations and translate them into equivalent Python EL scripts and dbt transformation…
• Develop and maintain Python EL pipelines to land high-volume data, including billion-row tables, into the target warehouse using SQLAlchemy, cx_Oracle, pyodbc
• Design and develop dbt transformation models based on Informatica mapping logic, incorporating dbt best practices including model layering, macros
• 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

What you need

• 5–9 years in data science & ai
• Python
• SQL
• dbt
• Airflow
• Informatica
• SQL Server
• Any graduate

Good to have

• VBA
• CI/CD
• Test automation
• Oracle Database
• Git
• Reconciliation