Job Title: ON-SITE -ETL Database Architect- HBITS-05-13380

Location: Albany, NY,12204

Duration: Long-term

Job Description:

• 84 months of experience designing and implementing Enterprise Data warehouse architecture solutions using the Kimball methodology of dimensional modeling.
• 84 months of experience designing and implementing Oracle Virtual Private Database (VPD) and Oracle Fine grained Auditing in an Enterprise Data Warehouse environment.
• 84 months of experience in collaborating with ETL (Extract, Transform, Load) developers as a team lead in designing Informatica ETL process and data warehouse database architecture.
• 84 months of experience working with non-technical and business clients to gather, analyze, and document business requirements for technical applications.
• 84 months of experience analyzing, interpreting and outputting patient mental health data from numerous heterogenous systems including pharmacy, Medicaid, incident, patient movement, and human resource systems.
• 84 months of experience in relational data management disciplines and design and development experience using Oracle technologies.
• Bachelor s Degree

__________________________________________________________________________

Agency: Information Technology Services (ITS)

Project: Enterprise Data Warehouse and various Health Cluster projects within the agency.

Detailed Job Description: Data warehouse database and ETL(Extract, Transform, Load) process redesign and implementation.

Max: SEVEN 32.800.2838

Kevin:- SEVEN 32.800.2373