Database Architect (Oracle / Informatica / Rhapsody / HL7)

Trigyn's direct government client has an immediate need for a Database Architect in Menands, NY.

Description

? Working with Oracle data warehouses, data marts and OLTP databases.
? Overseeing the creation/modification of Oracle database tables of the appropriate type for the situation.
? Writing/executing SQL for querying various Oracle databases as well as the Informatica Metadata Repository for validating unit and QA testing, monitoring, and for investigating integrity issues.
? Guiding the ETL team in the development and monitoring of ETL processes and test plans using Informatica Power Center and Rhapsody.
?

Guiding the ETL team in shaping, enhancing and recommending best practices to the overall ETL (Informatica/Rhapsody) architecture
? Investigating and resolving difficult design and build issues, data loading and data integrity issues.
? Performance tuning Informatica/Rhapsody workflows.
? Using Informatica/Rhapsody to develop ETL mappings and workflows including the use of mapplets, reusable transformations and worklets.

Mandatory Qualification

? Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
? Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

? 84 Months Experience writing SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings
? 84 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
? 84 Months Experience working with Health Data with HIPAA, HL7 or similar standards
? 60 months experience developing project timelines, gathering and documenting business requirements
? 48 Months experience in programming public sector government IT projects.
?

Project Management Professional Certification

For Immediate Response call , or send your resume to

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.