Informatica Lead - Short Hills, NJ

Position: Informatica Lead

Location: Short Hills, NJ

Mode Of Hire: Contract

Mode Of Work: Onsite

 

Key Responsibilities

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

Required Qualifications

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

Preferred Qualifications

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