We are seeking a skilled Informatica Developer with strong experience in Oracle databases, advanced SQL scripting, and a proven background in the healthcare insurance domain. The ideal candidate will design and maintain ETL workflows, optimize data pipelines, and ensure data accuracy and integrity within mission-critical healthcare systems. Responsibilities: • Design, develop, and optimize ETL processes using Informatica PowerCenter to extract, transform, and load data from diverse sources • Write, test, and optimize complex SQL queries for data analysis and transformation • Work closely with data architects and analysts to ensure data quality, compliance, and governance standards are met • Maintain and enhance existing data warehouse and data mart environments • Integrate data across systems including claims, enrollment, provider, and member data • Support data migration, cleansing, and validation tasks as part of healthcare product rollouts or enhancements • Collaborate with business and technical teams to gather requirements, troubleshoot issues, and deliver scalable solutions • Monitor and improve ETL job performance and data pipeline efficiency Skills & Qualifications: • 12+ years of experience in Informatica PowerCenter development • Strong proficiency in Oracle PL/SQL, stored procedures, and query optimization • Expertise in SQL and large-scale relational databases (10g/11g/12c+) • Experience with healthcare data — including claims, eligibility, provider, or member data • Understanding of HIPAA regulations, EDI transactions (e.g., 837, 834), or Medicare/Medicaid systems is a strong plus • Familiarity with Agile/Scrum methodologies • Excellent communication and documentation skills