Onsite_Azure-Data integration lead_ NJ

THEMESOFT

Location
Whitehouse Station, NJ, US
Role
Leadership
Pay
Not disclosed
Listed
Nov 18, 2026
Apply on the original listing →

Location: : Whitehouse Station, NJ / Exchange Place NJ. Hybrid - 3 days a week

Work Arrangement: Onsite

Employment Type: Contract

Contract Duration: 6-12 Months

Key Responsibilities

15+ 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.

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.

This is a critical, client-facing position. Technical expertise, architecture experience, and the ability to engage independently with customer stakeholders are essential and must not be compromised.

Top 3 required skills 1. Informatica IICS, Snowflake + complex EDW migration, ideally Oracle/Exadata or Synapse Snowflake,

2. Databricks / PySpark / Azure data engineering 3. Hands-on Technical Leadership, architecture through migration, reconciliation and production cutover

Top 3 preferred skills 1. Informatica IICS / IDMC

2. Oracle PL/SQL / Exadata / Azure Synapse 3. Enterprise data reconciliation, performance tuning & migration cutover

Work Authorization

Applicants must be legally authorized to work in the United States.

Equal Employment Opportunity

Themesoft Inc is an Equal Employment Opportunity employer. We consider qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other status protected by applicable federal, state, or local law.

Apply on the original listing →

This listing was collected from a public job posting. Applications go through the original listing. It may close without notice.

The iPaaS Brief

The iPaaS newsletter, by email.

What is changing in integration work, who is hiring, and what it pays. From the team behind iPaaS Jobs.

Free. One email to confirm, unsubscribe anytime.