Informatica Lead

Job Description

Position: Informatica Lead

Location: Short Hills, NJ

Mode Of Hire: Contract

Mode Of Work: Onsite

Key Responsibilities

\n
• Lead end-to-end project delivery, from requirements gathering and design to development, testing, deployment, and production support.
\n
• Manage offshore development teams, priorities, deliverables, timelines, risks, and dependencies.
\n
• Collaborate with business users, Product Owners, Project Managers, QA teams, and upstream/downstream application partners.
\n
• Provide technical leadership, code reviews, mentoring, and hands-on support.
\n
• Design and optimize ETL workflows, data warehouse solutions, SQL queries, and data models.
\n
• Troubleshoot data quality, performance, and production issues while ensuring quality and compliance.
\n
• Drive Agile/Scrum ceremonies, technical documentation, release readiness, and continuous improvement.
\n

Required Qualifications

\n
• 12+ years of experience in ETL, data integration, data warehousing, or analytics.
\n
• 3+ years of technical leadership and offshore team coordination.
\n
• Strong hands-on experience with Informatica PowerCenter and/or IICS.
\n
• Advanced SQL Server skills, including stored procedures and performance tuning.
\n
• Dimensional modeling, batch processing, and data quality.
\n
• Strong communication, problem-solving, stakeholder management, and Agile/SDLC experience.
\n
• Bachelor’s degree in Computer Science, IT, Engineering, or equivalent experience.
\n

Preferred Qualifications

\n
• Experience with Databricks, Delta Lake, Power BI, and cloud platforms (Azure, AWS, or GCP).
\n
• Knowledge of CI/CD, DevOps, DataOps, and modern data architectures.
\n
• Insurance industry experience, preferably Property & Casualty (P&C).
\n
• Familiarity with policy, claims, billing, underwriting, regulatory reporting, and data governance.
\n