← Back to jobs

Avance Consulting Logo
Senior Data Engineering Technical Lead

Avance Consulting

 

Bridgewater, NJ, USA

Posted On: Just posted
Experience: 15+ years
Availability: Remote
Openings: 1
Category: Senior Data Engineer
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

Experience: 15+ Years
Role: Technical Lead – Enterprise Data Modernization & Migration

Job Description

We are seeking a hands-on Technical Lead with extensive experience in enterprise data warehouse modernization and migration using Informatica PowerCenter/IICS, Snowflake, and Azure Synapse. The candidate will lead end-to-end migration programs, drive architecture decisions, manage technical risks, and coordinate with customer stakeholders and offshore engineering teams.

Key Responsibilities

Lead large-scale data warehouse modernization and migration from Azure Synapse, Oracle/Exadata, and legacy platforms to Snowflake.

Own end-to-end integration decisions, migration strategies, and technical risks across source systems, ETL platforms, and downstream applications.

Drive solution design covering 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 IICS.

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

Lead troubleshooting of complex migration, integration, reconciliation, and performance issues.

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

Lead technical discussions with customer architects and stakeholders.

Coordinate onsite/offshore engineering teams and act as the technical bridge between customers and delivery teams.

Ensure technical governance and successful production deployment.

Required Skills

Strong expertise in Snowflake architecture and enterprise data migration.

Informatica PowerCenter and IICS/IDMC.

Complex EDW migration, preferably Oracle/Exadata or Azure Synapse to Snowflake.

Databricks, PySpark, and Azure data engineering.

Legacy ETL modernization and reverse engineering.

SQL, PL/SQL conversion, data modelling, and performance tuning.

Enterprise data reconciliation and migration cutover.

Hands-on technical leadership and client-facing communication.

Experience managing onsite/offshore delivery teams.

Good-to-Have Skills

Oracle Exadata and PL/SQL.

Azure Synapse.

Informatica IDMC.

Enterprise data reconciliation and performance optimization.

Production cutover and parallel-run validation

Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs