Informatica Lead

Job Description

Informatica Lead Developer

\n

Branchville, NJ/Short Hills, NJ

\n

Onsite (5 Days a week)

\n

Type of Hire - Contract

\n

\n

\n

Key Responsibilities

\n

\n
• 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.

\n

• Informatica coding and implementation: design and build mappings, mapplets, reusable transformations, workflows, sessions, parameter files, and deployment artifacts; implement error handling, logging, and restartability.

\n

• 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.

\n

• Translate business requirements into data solutions: work with business analysts to profile source data, define transformation logic, and validate outputs against business rules.

\n

• Architectural collaboration: partner with Application and Enterprise Architects to review low‑level designs and ensure alignment with high‑level data flow and governance standards.

\n

• Production support and incident management: lead troubleshooting, root‑cause analysis, and remediation for production incidents; implement preventive fixes and runbooks.

\n

• Mentorship and technical guidance: coach developers on Informatica best practices, coding standards, unit testing, and performance tuning.

\n

• Documentation and knowledge transfer: maintain detailed technical documentation for mappings, data models, interfaces, and downstream integrations.

\n

• Prioritization and planning: assist product owners and project managers in prioritizing enhancements, new development, and maintenance; estimate effort and contribute to release planning.

\n

• Evaluate new technologies: assess ELT/modern data platforms (Databricks preferred), automation, and orchestration tools for fit and adoption.

\n

• Risk escalation and stakeholder communication: surface technical risks, propose mitigation strategies, and communicate status to technical and business stakeholders.

\n

\n

Required Qualifications

\n

\n
• 10+ years of experience leading and/or hands‑on developing Data Warehouse, data integration, or data engineering projects.

\n

• Proven leadership: history of owning deliverables and guiding teams to complete complex, time‑boxed projects.

\n

• Strong Informatica expertise: extensive experience building and maintaining mappings, workflows, parameterization, reusable components, and deployment packages.

\n

• Advanced SQL skills: ability to write, profile, and optimize complex SQL; experience with query tuning, indexing strategies, and analyzing execution plans.

\n

• Data modeling knowledge: dimensional and normalized modeling, star/snowflake schemas, and metadata management.

\n

• Experience with ELT and modern stacks: Databricks or INFROMATICA platforms preferred.

\n

• Solid troubleshooting skills for production support, performance issues, and data quality problems.

\n

• Excellent communication skills: able to explain technical tradeoffs to business stakeholders and produce clear documentation.

\n

\n

Leadership & Behavioral Attributes

\n

\n
• Mentor and coach who builds team capability and encourages knowledge sharing.

\n

• Customer‑focused with the ability to balance urgent fixes and long‑term architecture.

\n

• Analytical problem solver who uses data to drive decisions.

\n

• Organized and detail oriented with a bias for documentation and repeatable processes.

\n

• Collaborative across architects, QA, business analysts, and operations.

\n

\n

Logistics

\n

\n
• Consultant is supposed to work from onsite for 5 days a week.

\n

• Location: Onsite at Branchville, New Jersey/Short Hills, NJ — full onsite presence required.

\n

\n