Jobs → Data & Analytics → Data Migration Engineer

About the Role We are seeking a hands-on Data Migration Engineer with strong experience in Informatica PowerCenter, Python, dbt Core, and Apache Airflow to support a large-scale migration from legacy Informatica workflows to a modern data engineering platform. Key Responsibilities • Analyze and migrate Informatica PowerCenter mappings, sessions, workflows, and parameterization into Python-based EL pipelines and dbt transformation models • Develop scalable Python extraction and loading pipelines for high-volume datasets, including billion-row tables • Use Oracle Data Pump, SQL Server BCP, BULK INSERT, SQLAlchemy, cx_Oracle, or pyodbc for efficient database connectivity and bulk data movement • Build dbt Core models using modular layering, reusable macros, incremental materializations, snapshots, and automated tests • Develop and maintain Apache Airflow DAGs for end-to-end orchestration, scheduling, dependencies, and error handling • Implement GitLab CI/CD pipelines, automated testing, code quality checks, and deployment processes • Perform source-to-target reconciliation, row-count validation, data quality checks, and performance tuning during SIT and UAT • Participate in peer code reviews, technical documentation, operational runbooks, and knowledge transfer Requirements • 5+ years of Informatica PowerCenter experience, including mappings, sessions, workflows, and parameterization • 5+ years of Python development experience, including parallel processing and batch data pipelines • 5+ years of SQL experience, including complex joins, window functions, and large-scale data processing • 3+ years of hands-on dbt Core experience, including models, macros, tests, and incremental strategies • Hands-on Apache Airflow experience building and managing DAGs and task dependencies • Experience with Oracle Data Pump (expdp/impdp), SQL Server BCP, or BULK INSERT • Strong understanding of ETL migration, data validation, source-to-target reconciliation, and production troubleshooting