Description

Lead the migration of legacy Informatica ETL workloads to a modern dbt-on-Snowflake architecture on Azure.

This role is on-site.

Responsibilities

• Define target ELT architecture using dbt on Snowflake, integrated with Azure services (ADF, ADLS, Synapse/Databricks, Key Vault, Azure DevOps/GitHub).
• Translate legacy Informatica mappings, workflows, and sessions into modular dbt models across staging, core, and mart layers.
• Establish modeling standards, including naming conventions, layer design, and folder/package structures.
• Implement performance-optimized patterns in dbt and Snowflake, such as incremental models, clustering, partitioning logic, and query tuning.
• Oversee conversion, unit testing, and parallel runs to validate that dbt models match legacy outputs for row counts, aggregates, and business rules.

Required Skills

• 10+ years of total experience in Data Engineering, ETL, or Data Warehousing.
• 3+ years of hands-on experience with dbt (Core or Cloud) building production-grade pipelines.
• Proven experience leading an Informatica to dbt migration on Snowflake or similar large-scale ETL modernization.
• Strong Snowflake experience: designing schemas, views, warehouses, and performance optimization.
• Solid working knowledge of Azure data stack: Azure Data Factory (ADF), ADLS, Azure DevOps/GitHub.
• Experience with Synapse and Databricks.
• Ability to design repeatable migration factories, including templates, accelerators, and conversion playbooks.

Preferred Skills

• Hands-on development of dbt seeds, snapshots, tests, macros, and documentation.
• Experience defining testing strategies using dbt schema tests, data tests, and custom tests.

Key Skills

Education

Any Graduate