Search Jobs | Dice.com

Job Details

Skills

Informatica PowerCenter
Informatica
Data Engineering
SQL
Root Cause Analysis
Snow Flake Schema
Unit Testing
Interfaces
ELT
Databricks
Data Warehouse
Data Modeling
Analytical Skill
informatica IICS

Summary

Informatica Lead Developer

Branchville, NJ (Short Hills, NJ from October)

Onsite (5 Days a week)

Key Responsibilities

Lead hands‑on development and support of new and existing data integration applications using Informatica (PowerCenter, IICS, or equivalent), owning 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: partner with Application and Enterprise Architects to review low‑level designs and ensure alignment with high‑level data flow and governance standards.
Production support and incident management: lead troubleshooting, root‑cause analysis, and remediation for production incidents; implement preventive fixes and runbooks.
Mentorship and technical guidance: coach developers on Informatica best practices, coding standards, unit testing, and performance tuning.
Documentation and knowledge transfer: maintain detailed technical documentation for mappings, data models, interfaces, and downstream integrations.
Prioritization and planning: assist product owners and project managers in prioritizing enhancements, new development, and maintenance; estimate effort and contribute to release planning.
Evaluate new technologies: assess ELT/modern data platforms (Databricks preferred), automation, and orchestration tools for fit and adoption.
Risk escalation and stakeholder communication: surface technical risks, propose mitigation strategies, and communicate status to technical and business stakeholders.

Required Qualifications

15+ years of experience leading and/or hands‑on developing Data Warehouse, data integration, or data engineering projects.
Proven leadership: history of owning deliverables and guiding teams to complete complex, time‑boxed projects.
Strong Informatica expertise: extensive 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: dimensional and normalized modeling, star/snowflake schemas, and metadata management.
Experience with ELT and modern stacks: Databricks or INFROMATICA platforms preferred.
Solid troubleshooting skills for production support, performance issues, and data quality problems.
Excellent communication skills: able to explain technical tradeoffs to business stakeholders and produce clear documentation.

Leadership & Behavioral Attributes

Mentor and coach who builds team capability and encourages knowledge sharing.
Customer‑focused with the ability to balance urgent fixes and long‑term architecture.
Analytical problem solver who uses data to drive decisions.
Organized and detail oriented with a bias for documentation and repeatable processes.
Collaborative across architects, QA, business analysts, and operations.

Logistics

Consultant is supposed to work from onsite for 5 days a week.
Location: Onsite at Branchville, New Jersey — full onsite presence required.

Selective head quarter will be moving to Short hills, NJ in Q3/Q4 2026 hence the consultant work location will change accordingly.

Schedule: Standard business hours with occasional extended hours for critical releases or production incidents.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 10121769
Position Id: 9028377
Posted 1 day ago

Fitment

Dice Job Match Score™

🛠️ Calibrating flux capacitors...

Contact the job poster

Imran khan

Recruiter @ Central Business Solutions

View Profile

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Branchville, New Jersey

•

3d ago

Position: Informatica Power Center Developer Location- Branchville, NJ Duration: Long term Contract Work Mode: X Days onsite This position requires onsite in Branchville NJ . We are seeking a consultant who is local to New Jersey. 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. - Infor

Easy Apply

Third Party, Contract

Depends on Experience

ETL Informatica Developer

Hybrid in Morristown, New Jersey

•

16d ago

The Informatica Developer will be primarily responsible for developing and supporting ETL code in Informatica PowerCenter for an enterprise data warehouse. Job Responsibilities: Develop new ETL and enhancements and modify existing code using Informatica PowerCenter.Work independently to develop, configure, and unit test programs from specs (source to target mappings).Work closely with data architects, reporting team and application team on ETL development efforts.Design and document ETL soluti

Easy Apply

Contract

70 - 78

Data Engineer

Millburn, New Jersey

•

Today

A services organization in New Jersey is looking to fill an immediate need with the addition of a new Data Engineer to their team. About the Opportunity: Shift: Day shift Schedule: Monday to Friday Hours: Standard business Setting: Hybrid (at least 2 days onsite per week) Responsibilities: Develop and support new and existing data applications. Partner with business users and analysts to understand data needs and recommend effective long-term solutions. Work with application and enterprise archi

Easy Apply

Contract

$69 - $70 per hour

Informatica Developer

Jersey City, New Jersey

•

Today

Job#: 3042067 Job Description: Informatica Developer Location: Jersey City, NJ or Addison, TX (HYBRID - 3 days onsite/2 days remote) Contract length: 12-18 months Pay rate: $68/hr W2 Max Position Overview We are seeking a skilled Informatica ETL Developer with experience in Data Warehouse, PL/SQL, and Unix scripting. The ideal candidate will have expertise in designing, developing, and optimizing complex ETL solutions using Informatica PowerCenter and supporting enterprise-scale data wareh

Easy Apply

Full-time

$65 - $68 per hour

Filter Results

Job post features

Posted date

Work settings

Employment type

Distance

Employer type

Work authorization

Informatica Lead Developer

Skills

Summary

Dice Job Match Score™

Imran khan

Similar Jobs

Informatica Lead Developer

Job Details

Skills

Summary

Dice Job Match Score™

Imran khan

Similar Jobs