Informatica IICS Powercenter / Data integration Branchville, NJ

Executive Staff Recruiters / ESR Healthcare; New Jersey; On-site; USD 110,000 - 150,000; Full time

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.