Previous Job
Previous
Database Architect 3
Ref No.: 14-00820
Location: Austin, Texas
Texas Health and Human Services
Austin, TX
2 Months+
460 Hours


I. DESCRIPTION OF SERVICES
The Department of Information Resources (DIR) requires the services of one Database Architect, hereafter referred to as Worker(s), who meets the general qualifications of ITSAC Database Architect 3 Category, Emerging Technology Type and the specifications outlined in this document for the Texas Health and Human Services (HHSC) Enterprise Applications.

All work products resulting from the project shall be considered "works made for hire and are the property of the HHSC. HHSC may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. HHSC will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s).

The individual hired for this position will be part of the Enterprise Data Warehouse team. However, this program is interdependent with HHSC's Enterprise Data Governance initiative and there will be much coordination between the two efforts. Background on these two programs may be found on the HHSC website.

VENDORS: DO NOT SUBMIT RESUMES FOR ANY CANDIDATE WHO DOES NOT HAVE STRONG EXPERTISE IN THE USE OF INFORMATICA METADATA MANAGER AND OTHER INTERRELATED INFORMATICA PRODUCTS.

Responsibilities will include:
Design and implementation of a Metadata Repository.
Customization of standard Informatica Meta Model to accommodate a full range of metadata as defined for the collection and storage of enterprise Medicaid Metadata.
Design and development of customizable interface for consumers of information within the Metadata Repository.
Support for both Development and Production environment including release/promotion/publish process for all metadata.
Design, implementation and management of security access roles and privileges for all types of metadata consumers.
Design and development of Metadata Repository backup/recovery strategy.
Development of processes and guidelines for Metadata management change management, metadata access and sharing. This will include processes and capabilities for versioning all forms of metadata.
Overall responsibility for the day-to-day operations and oversight of the Metadata Repository.
Coordination and collaboration with other initiatives as required for Metadata Sharing including generation of required formats for metadata import and export.
Design, implementation and support of a Data Model repository for storage and display of enterprise system models including versioning and differential reporting for data models.
Participation in design and deliverable reviews as requested.




II. WORKER SKILLS AND QUALIFICATIONS

Minimum Requirements:
Years Skills/Experience
8 Experience designing and implementing (includes actual installation and configuration) of Informatica PowerCenter custom solutions.
4 Experience designing and implementing a customized Informatica Metadata Management solution
4 Experience with Erwin and ERStudio data modeling tools.
4 Experience with implementation of an Informatica instance on an Oracle 11g or 12c platform, preferable 12c.
3 Experience with Informatica 9 Platform (including Metadata Manager, Business Glossary, Data analyst, Reporting)
2 Experience with designing Data Lineage solutions.
Strong Proven ability to work successfully with technical and non-technical groups, and manage multiple responsibilities.
Strong Excellent analytical, problem-solving, team playing and communication skills.
Strong Strong technical writing skills.
Strong Experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

Preferences:
Years Skills/Experience
Some experience as an Oracle DBA desired, but not required
Experience with metadata for Master Data Management solutions
Experience with Security metadata
Experience with Data Quality metadata
Experience with both Relational and Dimensional Data Models
Jaspersoft custom reporting design experience
Version Control tool experience
Bachelor's degree in Computer Science, Electrical Engineering, Systems Engineering, or equivalent experience.