[Hiring] Senior Data Analyst @Randstad

Role Description

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.

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.

Requirements

• 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.

Team Structure

• 1 Project Manager
• 4 Developers

Interview Process

• Number of rounds: 3
• Video interviews
• Technical interviews