About the Role
Job Description
US Work Authorization Requirement:
Candidates must be legally authorized to work in the United States without employer sponsorship. This includes, but is not limited to, U.S. Citizens, Permanent Residents, and other individuals with valid U.S. work authorization.
Job Description:
We are seeking a highly skilled and motivated Senior Data Analyst / Informatica ETL Developer to join our team. This is a hands-on technical role responsible for designing, developing, and delivering robust ETL frameworks and components within a multi-terabyte Oracle Exadata environment.
The role involves integrating public and private healthcare encounter and enrollment data from New York State (NYS) healthcare plans. Using Informatica tools, you will transform and synthesize data to support the management, evaluation, and analysis of the NYS healthcare system.
Key Responsibilities:
Design, develop, and maintain ETL processes using Informatica tools
Source data from NYS healthcare plans and external systems
Perform data staging, auditing, cleansing, enrichment, and transformation
Load processed data into the NY All Payer Database (APD) reporting structures in Oracle
Ensure data quality, integrity, and compliance with regulatory standards
Optimize performance within a large-scale Oracle Exadata environment
Collaborate with stakeholders, analysts, and technical teams to support reporting and analytics needs
Troubleshoot and resolve ETL and data-related issues
Required Technical Skills:
Strong hands-on experience with the Informatica product suite, including:
PowerCenter
Test Data Manager
Master Data Management (MDM)
Metadata Manager
Data Quality
Additional Skills:
Strong experience with Oracle / Oracle Exadata
Experience working with large-scale healthcare data (encounter & enrollment data preferred)
Strong SQL and performance tuning skills
Knowledge of data warehousing concepts and ETL best practices
Experience with healthcare domain data (Medicaid/Medicare/NYS preferred)
Preferred Qualifications:
Experience working with state healthcare systems or All Payer Databases
Strong analytical and problem-solving skills
Ability to work independently in a fast-paced environment
Apply Online
Your Name *
Your Phone Number *
Your Email Address *
Job id
What is your current U.S. visa or immigration status? *
SelectU.S. Citizen (USC)Lawful Permanent Resident (Green Card holder)H1BF1-OPT/Stem-OPT/CPT EADH4-EADL-2SGC-EADOther Valid Visa
Where are you currently located at? *
W2 or C2C *
SelectW2C2C
How many years of total experience do you have? *
How many years of relevant experience do you have? *
Do you require H1B sponsorship? *
YesNo
Do you require sponsorship? *
NoYes – H-1B transferYes – Green Card sponsorshipYes – Both H-1B transfer and Green Card sponsorship
Upload Resume *
Δ
US Work Authorization Requirement:
Candidates must be legally authorized to work in the United States without employer sponsorship. This includes, but is not limited to, U.S. Citizens, Permanent Residents, and other individuals with valid U.S. work authorization.
Job Description:
We are seeking a highly skilled and motivated Senior Data Analyst / Informatica ETL Developer to join our team. This is a hands-on technical role responsible for designing, developing, and delivering robust ETL frameworks and components within a multi-terabyte Oracle Exadata environment.
The role involves integrating public and private healthcare encounter and enrollment data from New York State (NYS) healthcare plans. Using Informatica tools, you will transform and synthesize data to support the management, evaluation, and analysis of the NYS healthcare system.
Key Responsibilities:
Design, develop, and maintain ETL processes using Informatica tools
Source data from NYS healthcare plans and external systems
Perform data staging, auditing, cleansing, enrichment, and transformation
Load processed data into the NY All Payer Database (APD) reporting structures in Oracle
Ensure data quality, integrity, and compliance with regulatory standards
Optimize performance within a large-scale Oracle Exadata environment
Collaborate with stakeholders, analysts, and technical teams to support reporting and analytics needs
Troubleshoot and resolve ETL and data-related issues
Required Technical Skills:
Strong hands-on experience with the Informatica product suite, including:
PowerCenter
Test Data Manager
Master Data Management (MDM)
Metadata Manager
Data Quality
Additional Skills:
Strong experience with Oracle / Oracle Exadata
Experience working with large-scale healthcare data (encounter & enrollment data preferred)
Strong SQL and performance tuning skills
Knowledge of data warehousing concepts and ETL best practices
Experience with healthcare domain data (Medicaid/Medicare/NYS preferred)
Preferred Qualifications:
Experience working with state healthcare systems or All Payer Databases
Strong analytical and problem-solving skills
Ability to work independently in a fast-paced environment
[contact-form-7 id="ac31dcc" title="Job Apply Form"]
Tech Stack
SQLInformaticaETL