Informatica IICS Powercenter / Data integration Branchville, NJ

Executive Staff Recruiters / ESR Healthcare

New Jersey

On-site

USD 110,000 - 150,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Executive Staff Recruiters / ESR Healthcare in New Jersey is seeking an experienced Informatica/Data Integration engineer to lead development and support of data pipelines. You will work with PowerCenter or IICS, optimize SQL, profile data, and ensure reliability in production environments.

Responsibilities include designing mappings, workflows, and deployment artifacts, collaborating with architects, and documenting interfaces and data models.

Qualifications

  • 5–8+ years hands-on experience in data warehousing or data integration.

Responsibilities

  • Hands-on development and support of data integration apps using Informatica.

Skills

Informatica PowerCenter
Informatica IICS
SQL
Data Warehousing
ETL/ELT
Performance tuning
Data modeling
Communication
Databricks
Informatica platform

Tools

Databricks
Informatica

Job description

Informatica IICS Powercenter / Data integration Branchville, NJ (Short Hills, NJ by Oct/Nov) - Need locals

Here is the JD:

Key Responsibilities
  • - Hands‑on development and support of new and existing data integration applications using Informatica (PowerCenter, IICS, or equivalent), with a strong focus on code quality, deployments, and operational stability.
  • - Informatica coding and implementation: design and build mappings, mapplets, reusable transformations, workflows, sessions, parameter files, and deployment artifacts; implement error handling, logging, and restartability.
  • - SQL analysis and optimization: author and tune complex SQL queries, analyze execution plans, optimize joins/index usage, and implement set‑based transformations for performance and scalability.
  • - Translate business requirements into data solutions: work with business analysts to profile source data, define transformation logic, and validate outputs against business rules.
  • - Architectural collaboration: work closely with Application and Enterprise Architects to implement low‑level designs aligned with established data flow and governance standards.
  • - Production support and incident management: troubleshoot production issues, perform root‑cause analysis, and implement fixes to ensure data pipeline reliability and performance.
  • - Code quality and standards: follow established coding standards, participate in code reviews, and ensure maintainable and reusable development practices.
  • - Documentation and knowledge transfer: maintain clear and detailed technical documentation for mappings, data models, interfaces, and downstream integrations.
  • - Prioritization and execution: work with product owners and project managers to deliver enhancements, new development, and maintenance tasks within defined timelines.
  • - Exposure to modern platforms: contribute to initiatives involving ELT/modern data platforms (Databricks preferred), automation, and orchestration tools.
  • - Stakeholder communication: provide regular updates on development progress, risks, and blockers to technical and business stakeholders.
Required Qualifications
  • - 5–8+ years of hands‑on experience developing Data Warehouse, data integration, or data engineering solutions.
  • - Strong Informatica expertise: experience building and maintaining mappings, workflows, parameterization, reusable components, and deployment packages.
  • - Advanced SQL skills: ability to write, profile, and optimize complex SQL; experience with query tuning, indexing strategies, and analyzing execution plans.
  • - Data modeling knowledge: understanding of dimensional and normalized modeling, including star/snowflake schemas.
  • - Experience with ELT and modern stacks: exposure to Databricks or INFORMATICA platforms preferred.
  • - Strong troubleshooting skills for production support, performance issues, and data quality problems.
  • - Good communication skills: able to work effectively with technical teams and business stakeholders and contribute to clear documentation.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Informatica Data Integration Engineer - PowerCenter/IICS
Informatica Data Integration Engineer - PowerCenter/IICS

Executive Staff Recruiters / ESR Healthcare • New Jersey

On-site
USD 110,000 - 150,000
Informatica Developer - Bloomington, IL
Informatica Developer - Bloomington, IL

AHU Technologies Inc. • United States

Remote
USD 120,000 - 170,000
Data Analyst - IICS/PowerCenter
Data Analyst - IICS/PowerCenter

Golden Technology • Cincinnati (OH)

On-site
USD 70,000 - 90,000
Imformatica Lead
Imformatica Lead

Diligent Tec, Inc • Santa Ana (CA)

On-site
USD 110,000 - 160,000
Informatica Developer
Informatica Developer

TechDigital Group • Denver (CO)

On-site
USD 95,000 - 120,000
ETL Developer - Informatica PowerCenter & Automation
ETL Developer - Informatica PowerCenter & Automation

Compunnel Inc. • Charlotte (NC)

Hybrid
USD 90,000 - 120,000
Onsite Informatica Tech Lead - Data Warehousing & Analytics
Onsite Informatica Tech Lead - Data Warehousing & Analytics

Bright Vision Technologies • Short Hills (NJ)

On-site
USD 120,000 - 180,000
Informatica Developer - Only Local Consultant
Informatica Developer - Only Local Consultant

Pyramid Consulting Inc. • Atlanta (GA)

On-site
USD 80,000 - 110,000
Senior Technical Lead
Senior Technical Lead

TechDigital Group • Cedar Rapids (IA)

On-site
USD 95,000 - 130,000
Informatica Admin
Informatica Admin

Everest Technologies, Inc. • United States

Remote
USD 90,000 - 130,000