Description

Manage and optimize ETL processes and Informatica administration for a large-scale data warehouse.

This role is on-site.

Responsibilities

• Analyze and translate patient health, financial, and pharmacy business requirements into complex ETL code.
• Lead developers in designing Informatica PowerCenter ETL and database architecture using Kimball star schema and dimensional modeling.
• Perform Informatica administration, including installation, patching, and deployment of ETL code across all platforms.
• Implement Fine Grain Access Control Audit (FGACA) and Oracle Virtual Private Database (VPD) to protect HIPAA Protected Health Information (PHI).
• Develop and maintain UNIX scripts to validate files and monitor Informatica workflows.

Required Skills

• 14+ years of experience in database structural analysis, client operations, and system evaluation.
• 72 months of experience with Informatica PowerCenter 10.5.x or higher and Informatica Intelligent Data Management Cloud (IDMC).
• 72 months of Informatica PowerCenter Administration, including metadata analysis, repository optimization, and ETL code migration.
• 72 months of experience converting heterogeneous health systems data (Medicaid, Pharmacy, billing, and payroll) into ETL code.
• 60 months of experience with Oracle technologies, specifically designing and implementing Oracle VPD and FGACA in an Enterprise Data Warehouse.
• 60 months of experience working with UNIX or Linux operating systems.
• 60 months of experience as a team lead designing ETL and database architecture.
• Bachelor's degree in Computer Science, Business Intelligence, Information Science, or a related field.

Key Skills

Education

Bachelor's degree