← Back to jobs

Avance Consulting Logo
Snowflake Technical Lead

Avance Consulting

 

Bridgewater, NJ, USA

Posted On: Just posted
Experience: 15+ years
Availability: Onsite
Openings: 1
Category: Snowflake Technical Lead
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

Experience: 15+ Years
Required Skills: Snowflake, Databricks, Informatica PowerCenter/IICS

Job Description

We are seeking a hands-on Snowflake Technical Lead to drive complex enterprise data warehouse modernization and migration programs involving Snowflake, Databricks, Informatica PowerCenter/IICS, and Azure Synapse. The candidate will own technical architecture, integration decisions, migration strategies, and end-to-end delivery while coordinating with customer stakeholders and offshore engineering teams.

Key Responsibilities

Lead end-to-end data warehouse migration from Azure Synapse and Oracle/Exadata to Snowflake.

Own integration architecture, migration decisions, and technical risks across source systems, legacy ETL, Snowflake, and downstream applications.

Drive data modelling, schema migration, historical and incremental data migration, ETL/ELT, and SQL/PL-SQL conversion.

Lead reverse engineering and modernization of Informatica PowerCenter/IICS workloads.

Provide hands-on technical leadership across Snowflake, Databricks, Azure data services, and Informatica.

Define migration patterns, engineering standards, and conduct architecture and code reviews.

Resolve complex migration, integration, reconciliation, and performance issues.

Lead SIT, source-to-target validation, data reconciliation, parallel runs, production cutover, and readiness.

Lead technical discussions with customer architects and stakeholders.

Coordinate customer and offshore engineering teams, ensuring clear technical direction and delivery alignment.

Drive technical governance and production-readiness reviews.

Required Skills

Strong Snowflake architecture and enterprise data migration experience.

Hands-on Informatica PowerCenter and IICS knowledge.

Databricks and Azure data engineering.

Experience in complex EDW migration, preferably Oracle/Exadata or Azure Synapse to Snowflake.

Legacy ETL modernization and reverse engineering.

SQL, PL/SQL, ETL/ELT, and data modelling.

Data reconciliation, performance tuning, and migration cutover.

Strong technical leadership and client-facing communication.

Experience managing onsite/offshore delivery teams.

Good-to-Have Skills

Informatica IDMC.

Oracle Exadata and Azure Synapse.

Parallel-run validation and enterprise data reconciliation.

Production migration and cutover experience

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs