Database Architect

Job Summary

• Support OMH Data warehouse Informatica PowerCenter and Informatica Intelligent Data Management Cloud
• (IDMC) for ETL (Extract, Transform, Load) processes, Informatica administration, and redesign and implementation of current and future OMH projects.

Job Description

• Analyze and translate patient health data business requirements into ETL code. This includes admission, discharge and day-to-day census records, financial, billing, human resource, payroll, Medicaid and Pharmacy data.
• Participate in Datawarehouse design and architecture planning, Using Kimball methodologies of Star schema design and Dimensional Data Modeling techniques.
• Collaborate with developers as a team lead in designing Informatica PowerCenter ETL and database architecture using advanced data warehousing concepts.
• Extract and interpret Informatica Metadata repository data.
• Implement Fine Grain Access Control Audit (FGACA) to protect Health Care data such as Medicaid, Pharmacy, and HIPAA Protected Health Information (PHI).
• Analyze and code complex UNIX scripts to validate and ftp files and monitor Informatica workflows.
• Perform Informatica Administration including installation, patching and deployment of Informatica ETL code across all platforms.

Job Qualifications

• 6 years of experience using Informatica PowerCenter 10.5.x or higher and Informatica Intelligent Data Management Cloud in a data warehouse environment, including familiarity with advanced warehousing concepts, and design and development of complex mappings.
• 6 years of experience with Informatica PowerCenter Administration including installation, patching, metadata analysis, ETL code migration, and repository optimization.
• 6 years of experience analyzing and converting heterogeneous health systems data—including admission, discharge, census, financial, billing, human resources, payroll, Medicaid, and pharmacy data—into complex ETL code.
• 5 years of experience in relational data management disciplines and design and development using Oracle technologies, including designing and implementing Oracle Virtual Private Database (VPD) and Oracle Fine-Grained Auditing (FGACA) in an enterprise data warehouse environment to protect health care data such as Medicaid, pharmacy, and HIPAA-protected health information (PHI).
• 5 years of experience working with UNIX and/or LINUX operating systems.
• 5 years of experience collaborating with developers as a team lead in designing PowerCenter ETL and database architecture using advanced data warehousing concepts.
• Bachelor’s degree in computer science, business intelligence, information science or related field.