Informatica PowerCenter Architect - HBITS-08-15032

Greycell Labs Inc; City of Albany (NY); In loco; USD 140.000 - 190.000; Tempo pieno

Descrizione del lavoro

Greycell Labs Inc. in Albany, NY, is seeking an on-site Informatica PowerCenter Architect to support enterprise data warehouse initiatives and health cluster projects.

The role emphasizes administration, complex ETL design, and collaboration with cross-functional teams. The ideal candidate brings extensive Informatica PowerCenter and IDMC experience, strong Oracle knowledge, and a background in healthcare data, PHI, and HIPAA compliance.

Competenze

• Bachelor’s degree required in computer science, information science or related field.
• Minimum 10 years in ETL and data warehousing using Informatica tools.
• Experience with healthcare data (PHI/HIPAA) is preferred.

Mansioni

• Support ETL processes using Informatica PowerCenter and IDMC in a data warehouse.
• Administer and optimize Informatica environments including patching and migrations.
• Lead collaboration with developers on ETL design and database architecture.
• Ensure HIPAA compliance and data privacy in health data projects.

Conoscenze

Informatica PowerCenter

Informatica IDMC

ETL design and development

Data warehouse concepts

Team lead collaboration

UNIX/LINUX

Healthcare data (PHI HIPAA)

Formazione

Bachelor's degree in computer science or related field

Strumenti

Informatica PowerCenter

Informatica IDMC

Oracle

UNIX/Linux OS

Descrizione del lavoro

Job Title: ON-SITE - Informatica PowerCenter Architect - HBITS-08-15032

Location: Albany, NY 12204

Duration: Long-term (30)

Job Description

• 120 Months Experience using Informatica Powercenter 10.5.x or higher and Informatica Intelligent Data Management Cloud (IDMC) in a data warehouse environment including familiarity with advanced warehousing concepts, and design and development of complex mappings.
• 120 Months Experience with Informatica Powercenter and IDMC Administration including Installation, Patching, Metadata analysis, ETL code migration, and repository optimization.
• 120 Months Experience analyzing and converting, heterogenous Health systems data, including admission, discharge, census, financial, billing, human resource, payroll, Medicaid and Pharmacy data into complex ETL code.
• 120 months Experience in relational data management disciplines and design and development experience 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).
• 120 Months Experience working with UNIX and or LINUX Operating Systems.
• 120 Months 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.

Agency: Office of Information Technology Services (ITS)

Project: Enterprise Data Warehouse and various Health Cluster projects within OMH

Detailed Job Description: 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.

Note: Sorry we do not Sponsor Visa