Informatica Lead Developer

Position Summary

Seeking an experienced, hands-on Technical Lead to drive enterprise data integration, data warehousing, and analytics initiatives. The candidate will lead offshore development teams, collaborate with business stakeholders, Product Owners, Project Managers, QA, and application teams, and ensure end-to-end delivery of high-quality data solutions.

Top 3 Must-Have Skills

1. 8+ years of overall experience with Informatica and strong SQL development

2. Experience with at least one cloud platform: Azure, AWS, or Google Cloud

3. Hands-on experience with IBM Netezza

Preferred: Databricks and Power BI experience.

Key Responsibilities

• Lead end-to-end delivery of ETL, data integration, data warehouse, and analytics projects.

• Manage offshore development teams, priorities, timelines, deliverables, and technical blockers.

• Collaborate with business users, Product Owners, PMs, QA, and upstream/downstream application teams.

• Lead requirements gathering, technical design, development, testing, deployment, and production support.

• Review Informatica workflows, SQL queries, data models, and technical designs.

• Troubleshoot data quality, performance, ETL, and production issues.

• Ensure coding standards, documentation, data quality, and delivery excellence.

• Drive Agile ceremonies, status updates, risk management, and stakeholder communication.

Required Qualifications

• 8+ years of experience in Data Warehousing, ETL, Data Integration, or Analytics.

• Strong hands-on experience with Informatica PowerCenter and/or IICS.

• Advanced SQL, SQL Server, stored procedures, query optimization, and performance tuning.

• Experience with IBM Netezza enterprise data warehouse solutions.

• 3+ years of technical leadership and offshore team coordination.

• Strong understanding of ETL, data modeling, batch processing, data quality, and SDLC.

• Experience working in Agile/Scrum environments.

• Excellent communication, leadership, problem-solving, and stakeholder management skills.

Preferred Skills

• Databricks, Delta Lake, Lakehouse, and ETL modernization.

• Power BI dashboards, semantic models, and reporting.

• Azure, AWS, or Google Cloud Platform cloud data services.

• Cloud data lakes, CI/CD, DevOps, and DataOps.

• Insurance industry experience, preferably Property & Casualty (P&C).

• Exposure to policy, claims, billing, underwriting, finance, and regulatory reporting data.

• Knowledge of data governance, compliance, security, privacy, and audit requirements.