ETL Data Migration Lead

Robotics Technologies

Whitehouse Station (NJ)

On-site

USD 150,000 - 210,000

Full time

13 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Robotics Technologies LLC is seeking an experienced Technical Lead to drive enterprise data modernization programs, focusing on Snowflake, Informatica PowerCenter/IICS, and Azure data services. This client-facing onsite role demands deep architectural and hands-on delivery leadership across the full migration lifecycle.

You will own integration decisions, migration patterns, and engineering standards, coordinating with customer architects and offshore teams to ensure successful reconciliation,

Qualifications

  • Extensive Snowflake architecture experience and data migration expertise.
  • Hands-on Informatica PowerCenter and IICS knowledge.
  • Experience in legacy ETL modernization, reverse engineering, and complex data integration.
  • Ability to lead technical discussions with customer architects and stakeholders.
  • Experience coordinating onsite/offshore teams and owning technical delivery.

Responsibilities

  • Lead end-to-end technical delivery of large-scale data warehouse modernization to Snowflake.
  • Own integration decisions and migration risks across the full landscape including source systems and ETL pipelines.
  • Drive solution design covering data modelling, schema migration, and data migration strategies.
  • Lead reverse engineering of legacy ETL workloads and design modern data integration approaches.
  • Provide hands-on technical oversight across Snowflake, Databricks, and Azure data services.
  • Define migration patterns and engineering standards; perform design/code reviews for complex objects.
  • Lead troubleshooting of migration, reconciliation, and performance issues.
  • Drive SIT, data reconciliation, parallel runs, and production readiness activities.
  • Coordinate with customer architects, platform, security, and application teams; bridge onsite/offshore delivery.

Skills

Snowflake architecture
Stakeholder leadership
Data modernization
ETL/ELT design
Onsite/offshore coordination

Tools

Informatica PowerCenter
Informatica IICS
Snowflake
Azure Synapse
Databricks
Oracle Exadata

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization: US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Roles &Responsibilities

10+ years of experience and seeking a strong, hands-on Technical Lead to lead complex enterprise data modernization and migration programs involving Informatica PowerCenter / IICS, Snowflake, Azure Synapse. This is a critical, client-facing onsite role that provides technical leadership, works closely with customer architects, application SMEs, platform teams and offshore engineering teams, and bridges the gap between the customer and offshore delivery teams.

The Technical Lead will own integration decisions and migration risks across the full landscape, not just the Snowflake or IICS implementation. The role also owns solution-level technical decisions, migration patterns, engineering standards, complex issue resolution, code/design reviews and technical readiness across build, testing, reconciliation and production cutover. This fits the proposed delivery model where Snowflake is the target platform, with migration of database objects, historical data, and IICS workloads together with end-to-end reconciliation and parallel-run validation.

Key Responsibilities :
  • Lead end-to-end technical delivery of large-scale data warehouse modernization from platforms such as Azure Synapse and Oracle/Exadata to Snowflake.
  • Own integration decisions and migration risks across the full landscape (source systems, legacy ETL, Informatica PowerCenter/IICS, Snowflake and downstream consumers), with accountability beyond any single tool or platform.
  • Drive solution design covering data modelling, schema migration, historical/incremental data migration, ETL/ELT, PL/SQL/SQL conversion and performance optimization.
  • Lead reverse engineering of legacy ETL (Informatica PowerCenter/IICS and related workloads) and design complex data integration and modernization approaches for the target platform.
  • Provide hands-on technical oversight across Snowflake, Databricks, Azure data services and Informatica IICS.
  • Define migration patterns and engineering standards and perform design/code reviews for complex objects and pipelines.
  • Lead troubleshooting of critical migration, reconciliation, performance and integration issues.
  • Drive SIT, data reconciliation, parallel runs, cutover and production readiness, including source-to-target validation.
  • Independently lead technical discussions with customer architects and stakeholders; coordinate closely with customer architecture, platform, security and application teams, and act as the bridge between the customer and the offshore teams - translating customer expectations, architecture decisions and priorities into clear technical direction for onsite/offshore engineering teams while owning technical delivery.
  • Support technical governance including architecture/design reviews and production-readiness discussions.
Required Experience
  • Strong Snowflake architecture and legacy data migration experience.
  • Hands-on Informatica PowerCenter / IICS knowledge.
  • Experience in legacy ETL modernization, reverse engineering, and complex data integration.
  • Ability to lead technical discussions with customer architects and stakeholders.
  • Experience coordinating onsite/offshore teams, bridging the gap between customer stakeholders and offshore delivery teams, and owning technical delivery.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

ETL Data Migration Lead
ETL Data Migration Lead

Robotic Technologies Automation • New Jersey

On-site
USD 140,000 - 190,000
ETL Data Migration Lead
ETL Data Migration Lead

CloudBigD • New Jersey

On-site
USD 180,000 - 230,000
ETL Data Migration Lead
ETL Data Migration Lead

Ethereum Technologies • New Jersey

On-site
USD 160,000 - 210,000
ETL Data Migration Lead
ETL Data Migration Lead

Quantum Technologies. LLC • New Jersey

On-site
USD 150,000 - 190,000
ETL Data Migration Lead
ETL Data Migration Lead

Valiant Technologies LLC • New Jersey

On-site
USD 150,000 - 230,000
Onsite_Azure-Data integration lead_ NJ
Onsite_Azure-Data integration lead_ NJ

Themesoft Inc • Whitehouse Station (NJ)

Hybrid
USD 120,000 - 150,000
Snowflake Technical Lead
Snowflake Technical Lead

Quantum Technologies LLC • New Jersey

On-site
USD 90,000 - 120,000
Snowflake Technical Lead
Snowflake Technical Lead

Robotic Process Automation LLC • New Jersey

On-site
USD 86,000 - 123,000
Snowflake Technical Lead
Snowflake Technical Lead

Valiant Technologies LLC • New Jersey

On-site
USD 86,000 - 123,000
Snowflake Technical Lead
Snowflake Technical Lead

Ethereum Technologies LLC • New Jersey

On-site
USD 90,000 - 120,000