Description

You will design, develop, and maintain ETL processes to support reporting and analytics needs for the NY All Payer Database.

This role is on-site.

Responsibilities

• Source data from NYS healthcare plans and external systems using Informatica tools.
• Perform data staging, auditing, cleansing, enrichment, and transformation.
• Load processed data into the NY All Payer Database reporting structures in Oracle.
• Ensure data quality, integrity, and compliance with regulatory standards.
• Troubleshoot and resolve ETL and data-related issues.

Required Skills

• 5+ years of professional experience.
• Strong hands-on experience with Informatica PowerCenter.
• Expertise in ETL process design and maintenance.
• Proficiency with Oracle and Oracle Exadata environments.
• Strong SQL skills and database performance tuning.
• Experience with Data Warehousing concepts and ETL best practices.
• Knowledge of Data Quality and MDM principles.
• Experience working with large-scale healthcare data.

Preferred Skills

• Experience working with state healthcare systems or All Payer Databases.

Key Skills

Education

Any Gradute