Description

You will lead the migration of legacy Informatica ETL jobs to a modern dbt on Snowflake architecture on Azure. You own the technical strategy, hands-on development, and quality assurance for this large-scale modernization.

This role is on-site.

Responsibilities

• Define target ELT architecture using dbt on Snowflake, integrated with Azure services including ADF, ADLS, Synapse/Databricks, and Key Vault.
• Translate legacy Informatica mappings, workflows, and sessions into modular dbt models across staging, core, and mart layers.
• Lead the migration strategy, roadmap, and wave planning, including designing a repeatable migration factory with templates and playbooks.
• Oversee conversion, unit testing, and parallel runs to validate that dbt models match legacy outputs for row counts and business rules.
• Implement performance-optimized patterns in dbt and Snowflake, including incremental models, clustering, partitioning, and query tuning.

Required Skills

• 8+ years total experience in Data Engineering, ETL, or Data Warehousing.
• 3+ years hands-on experience with dbt (Core or Cloud) building production-grade pipelines.
• Proven experience leading an Informatica to dbt migration on Snowflake/Azure or similar large-scale ETL modernization.
• Strong Snowflake experience: designing schemas, views, warehouses, and performance optimization.
• Solid working knowledge of the Azure data stack: Azure Data Factory (ADF) and Azure Data Lake Storage (ADLS).
• Experience with Azure DevOps or GitHub for CI/CD and version control.
• Ability to define and enforce code quality practices, including modular reusable models, code reviews, and pull requests.

Key Skills

Education

Any Graduate