Description

You will lead the modernization of ETL processes from Informatica to modern ELT patterns on Snowflake using dbt.

Responsibilities

• Define and own the target ELT architecture utilizing dbt on Snowflake, integrated with Azure services.
• Translate complex legacy Informatica mappings, workflows, and sessions into modular dbt models across staging, core, and mart layers.
• Lead the end-to-end migration strategy, roadmap, and wave planning for converting Informatica jobs.
• Design and implement performance-optimized patterns within dbt and Snowflake, including incremental models and partitioning logic.
• Oversee conversion, unit testing, and parallel runs to validate dbt model outputs against legacy data.

Required Skills

• 8+ years total experience in Data Engineering, ETL, or Data Warehousing.
• 3+ years hands-on experience building production-grade pipelines with dbt (Core or Cloud).
• Proven experience leading an Informatica to Snowflake migration on Azure or similar large-scale modernization.
• Strong expertise in Snowflake: designing schemas, developing views, warehouses, and optimization.
• Solid working knowledge of the Azure data stack: ADF, ADLS, Azure DevOps/GitHub.
• Experience designing repeatable migration factories, including templates and conversion playbooks.
• Proficiency in analyzing existing Informatica ETL logic, dependencies, and schedules.

Key Skills

Education

Any Graduate