Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Database Architect

GENESYS Consulting Services, Inc.

Database Architect

Menands, NY
Full Time
Paid
  • Responsibilities

    This is a 30 month opportunity on the Hourly-Based IT Services (HBITS) Contract at the State of New York. (Possibility of extension).

    Required Experience:

    • 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