Migration Lead: Informatica to dbt on Snowflake (Azure)

Valiant Technologies LLC; Chicago (IL); On-site; USD 120,000 - 180,000; Full time

Job summary

Valiant Technologies LLC in Chicago is seeking a senior data engineer to lead the migration of Informatica jobs to dbt on Snowflake hosted in Azure. You will define architecture, standardize modeling across staging, core, and mart layers, and optimize performance with incremental models and clustering.

You\'ll oversee migration strategy, testing, and hands-on development of dbt models, seeds, snapshots, and tests.

Qualifications

• Eight-plus years in data engineering/ETL/data warehousing.
• Three-plus years with dbt (Core or Cloud) in production pipelines.
• Proven lead on Informatica-to-dbt migrations to Snowflake on Azure.
• Strong Snowflake design, schemas, performance tuning.
• Solid know-how of Azure data stack: ADF, ADLS, DevOps/GitHub.

Responsibilities

• Define target ELT architecture using dbt on Snowflake integrated with Azure services.
• Translate legacy Informatica mappings into modular dbt models (staging/core/mart).
• Establish modeling standards for staging, integration, mart layers.
• Implement performance-optimized patterns (incremental, clustering, partitioning) and query tuning.
• Lead migration strategy, roadmap, and wave planning for Informatica-to-dbt on Snowflake.
• Analyze existing Informatica ETL logic and redesign in dbt.
• Design a repeatable migration factory with templates and playbooks.
• Oversee conversion, unit testing, and parallel runs to validate outputs.
• Hands-on development of dbt models, seeds, snapshots, tests, macros, docs.
• Define testing strategy using dbt tests and data quality checks.
• Set up dbt environments (dev/test/prod), profiles, Snowflake/Azure connections.
• Enforce code quality; conduct reviews and PRs.
• Develop modular, reusable models and packages.

Job description

Valiant Technologies LLC in Chicago is seeking a senior data engineer to lead the migration of Informatica jobs to dbt on Snowflake hosted in Azure. You will define architecture, standardize modeling across staging, core, and mart layers, and optimize performance with incremental models and clustering.

You\'ll oversee migration strategy, testing, and hands-on development of dbt models, seeds, snapshots, and tests.