Informatica Developer- IICS

Role: Informatica Developer

Duration: Long term

Type: Contract

Location: Branchville, NJ – Onsite

onRoles & Responsibiliti

• esLead hands‑on development and support of new and existing data integration applications using Informatica (PowerCenter, II CS, or equivalent), owning code quality, deployments, and operational stabilit
• y.Informatica coding and implementation: design and build mappings, mapplets, reusable transformations, workflows, sessions, parameter files, and deployment artifacts; implement error handling, logging, and restartabilit
• y.Author and tune complex SQL queries, analyze execution plans, optimize joins /index usage, and implement set‑based transformations for performance and scalabilit
• y.Work with BAs to profile source data, define transformation logic, and validate outputs against business rule
• s.Partner with Application and Enterprise Architects to review low‑level designs and ensure alignment with high‑level data flow and governance standard
• s.Lead troubleshooting, root‑cause analysis, & remediation for production incidents; implement preventive fixes & runbook
• s.Coach developers on Informatica best practices, coding standards, unit testing, and performance tunin
• g.Maintain detailed technical documentation for mappings, data models, interfaces, and downstream integration
• s.Assist product owners and project managers in prioritizing enhancements, new development, and maintenance; estimate effort and contribute to release plannin
• g.Assess ELT/modern data platforms (Databricks preferred), automation, and orchestration tools for fit and adoptio
• n.Surface technical risks, propose mitigation strategies, & communicate status to technical & business stakeholder
• s.7+ years of experience leading developing Data Warehouse, data integration, or data engineering project
• s.Proven leadership: history of owning deliverables and guiding teams to complete complex, time‑boxed project
• s.Strong Informatica expertise: extensive experience building and maintaining mappings, workflows, parameterization, reusable components, and deployment package
• s.Advanced SQL skills: ability to write, profile, and optimize complex SQL; experience with query tuning, indexing strategies, and analyzing execution plan
• s.Dimensional and normalized modeling, star/snowflake schemas, and metadata managemen
• t.Experience wit h E LT and modern stacks : Databricks or INFROMATIC A platforms preferre
• d.Solid troubleshooting skills for production support, performance issues, and data quality problem
• s.Able to explain technical tradeoffs to business stakeholders and produce clear documentatio
• n.Customer‑focused with the ability to balance urgent fixes and long‑term architectur