Job Title: ON-SITE -Database Architect - HBITS-05-13359

Location: Albany, New York 12204

Duration: 30 Months

Job Description:

• 84 Months Experience writing complex SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings
• 48 months Experience developing Rhapsody routes, including Rhapsody 7, acquiring and managing millions of records of data including XML and HL7 message formats
• 84 Months Experience using Informatica 8.x or higher, including 10.2, in a data warehouse environment including warehousing concepts, design and development of complex mappings
• 84 Months Experience with Informatica Data Quality 8.x or higher, including 10.2, processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge
• 84 Months Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing
• 72 Months Experience working with Health Data with HIPAA, HL7 or similar standards

______________________________________________________________________________________

Agency: Office of Mental Health

Project Name: Health Information Exchange (HIE)

Detailed Description: Database Architect

Max: SEVEN 32.800.2838

Kevin:- SEVEN 32.800.2373