Informatica Lead

Role: Informatica Lead
Experience: 14+ years
Location: onsite Branchville, New Jersey
Visa:h1b/H4aed/c2c
Rate: Best in Market
LinkedIn must Should be join before 2017, Mandatory PP Number

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.