Description

You will design, administer, and implement ETL processes and data warehouse architecture for patient health data.

This role is on-site.

Responsibilities

• Translate business requirements into ETL code for admission, discharge, financial, billing, and pharmacy data.
• Design data warehouse architecture using Kimball methodologies, Star schema, and Dimensional Data Modeling.
• Lead developers in designing Informatica PowerCenter ETL and database architecture.
• Implement Fine Grain Access Control Audit (FGACA) to protect Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
• Perform Informatica Administration including installation, patching, and deployment across all platforms.

Required Skills

• 6+ years of experience with Informatica PowerCenter 10.5.x or higher and Informatica Intelligent Data Management Cloud (IDMC).
• 6+ years of Informatica PowerCenter Administration, including installation, patching, and repository optimization.
• 6+ years of experience converting heterogeneous health systems data into complex ETL code.
• 5+ years of experience with Oracle technologies, specifically Oracle Virtual Private Database (VPD) and Oracle FGACA.
• 5+ years of experience working with UNIX and/or LINUX operating systems.
• 5+ years of experience as a team lead designing PowerCenter ETL and database architecture.
• Expertise in Data Modeling, ETL, and advanced data warehousing concepts.

Preferred Skills

• Bachelor’s degree in Computer Science, Business Intelligence, Information Science, or a related field.

Key Skills

Education

Any Graduate