Data Migration Specialist

URGENT HIRING !!

Role : Informatica Lead

Location : New Jersey

Hybrid 3 days Onsite

Duration : 12+month

Position Summary

We are seeking an experienced, hands-on Onsite Technical Lead to lead enterprise data integration, data warehousing, and

analytics delivery. The role will serve as the primary bridge among business users, Product Owners, Project Managers, QA teams, upstream and downstream application partners, and offshore development teams.

The ideal candidate combines strong expertise in Informatica, SQL Server, and Netezza with proven technical leadership, delivery management, and stakeholder engagement skills. Experience with Databricks, Power BI, and cloud platforms is a plus. The successful candidate will be a self-starter who can translate business needs into reliable technical solutions and drive execution from requirements through production deployment.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent professional

experience.

• 8+ years of experience in data warehousing, ETL, data integration, or enterprise analytics delivery.

• 3+ years of experience leading technical teams and coordinating work with offshore delivery resources.

• Strong hands-on experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS).

• Strong experience with Microsoft SQL Server, advanced SQL development, stored procedures, query optimization, and

performance tuning.

• Experience developing or supporting enterprise data warehouse solutions on IBM Netezza.

• Solid understanding of data integration patterns, dimensional modeling, batch processing, data quality, and production support.

• Experience working within Agile/Scrum and structured SDLC delivery environments.

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

Preferred Qualifications

• Experience with Databricks, including data engineering, Delta Lake, lakehouse patterns, or ETL modernization.

• Experience with Power BI, including enterprise dashboards, semantic models, data refresh, and reporting solutions.

• Experience with cloud data services on Microsoft Azure, AWS, or Google Cloud Platform.

• Knowledge of cloud data lakes, lakehouse architecture, CI/CD, DevOps, or DataOps practices.

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

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

• Experience delivering solutions in a regulated environment with awareness of audit, compliance, data governance, privacy,

security, and data-retention requirements.