Informatica ETL Developer

We are seeking a skilled and motivated Informatica ETL Developer to join our team. This role is responsible for designing and delivering ETL frameworks and components within a multi-terabyte Oracle Exadata environment that integrates public and private healthcare encounter and enrollment data from New York State (NYS) healthcare plans. Using Informatica, you will synthesize data to support the management, evaluation, and analysis of the NYS healthcare system. This is a hands-on technical role requiring comprehensive knowledge of the Informatica product suite, including: • PowerCenter • Test Data Manager • Master Data Management • Metadata Manager • Data Quality You will be accountable for sourcing data from NYS healthcare plans, staging, auditing, cleansing, enriching, and loading data into the NY All Payer Database (APD) reporting structures in Oracle. Primary Responsibilities • Design and develop ETL workflows and mappings using Informatica PowerCenter to load data into NY APD reporting structures. • Adhere to Informatica development standards (e.g., no hard coding, use of maplets, reusable components). • Build automation plans for manual operational activities. • Perform optimization, troubleshooting, and debugging of ETL processes. • Develop and execute unit and integration testing. • Tune and optimize ETL jobs for performance and throughput; collaborate with data modelers and DBAs for architecture optimization. • Provide development support and conduct code walkthroughs to ensure compliance with standards. • Enforce secure coding principles per State of NY policies. • Document and maintain operational procedures for ETL workflows. • Troubleshoot pre-production and production ETL job issues. • Utilize Informatica Data Quality for profiling and validation prior to transformation. • Design and implement data validation processes using Informatica Data Quality. Required Qualifications • 5+ years of experience with Informatica PowerCenter. • 5+ years of experience in Oracle & PL/SQL with strong coding and performance tuning skills. • 2+ years of experience in scripting languages (Python, Shell, etc.). • 2+ years of experience in data analysis. • Experience with data modeling techniques for data warehouse environments. • 2+ years of healthcare data experience (Medicaid, Medicare, Exchange, or commercial payer). • Strong understanding of data warehouse and database design principles. • Experience with performance tuning and optimization. • Excellent problem-solving skills, attention to detail, and ability to work independently and collaboratively. • Strong communication and collaboration skills. • Experience with Informatica Data Quality and Test Data Manager. Preferred Qualifications • Knowledge of HIPAA regulatory security requirements. • Experience with 834, 837, NCPDP transactions. • Familiarity with modern technologies such as Snowflake, Databricks, Azure, AWS. • Advanced Oracle experience.