Informatica PowerCenter Architect - HBITS-08-15032

Greycell Labs Inc; City of Albany (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Greycell Labs Inc. is seeking an ON-SITE Informatica PowerCenter Architect to support Enterprise Data Warehouse efforts in Albany, NY. The role focuses on designing complex ETL mappings, administering PowerCenter/IDMC, and guiding team-based data architecture initiatives.

The candidate should have extensive experience with Oracle databases, UNIX/Linux, and HIPAA-related health data environments. This is a long-term, on-site position with no visa sponsorship.

Qualifications

• Bachelor's degree in computer science, business intelligence, information science or related field.
• 10+ years in ETL/Data warehousing with Informatica PowerCenter and IDMC is expected.

Responsibilities

• Support Enterprise Data Warehouse projects and OMH data warehouse efforts.
• Lead ETL design and PowerCenter implementation across complex mappings.
• Perform administration tasks: installation, patching, metadata analysis, and repository optimization.
• Collaborate with developers as a team lead on database architecture for warehousing.

Skills

ETL design

Data warehousing

Metadata analysis

PowerCenter administration

IDMC administration

Team leadership

Education

Bachelor's degree in computer science

Information science or related field

Tools

Informatica PowerCenter

Informatica IDMC

Oracle

UNIX/Linux

Job description

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.

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