Database Architect

Job Description

Texas Workforce Commission requires the services of Database Architect and the specifications outlined.

Required

8 Yrs of experience in Design and develop Extraction, Transformation, Load (ETL) processes for enterprise data warehouse using Informatica; Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes

8 Yrs of Hands-on experience with data warehouse development and testing (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle

8 Yrs experience in Analyzing and generating technical requirements and design

8 Yrs Hands on experience with data modeling preferably in a data warehouse environment

8 Yrs Experience with Informatica product suite in the Informatica cloud

8 Yrs experience in Creating source to target mapping database documentation

8 Yrs experience - Assist with migrating data from legacy database to new target database

5 Yrs of experience - More than one type of RDBMS (DB2, SQL Server, Oracle)

5 Yrs of experience - erwin or other equivalent data modeling tools

3 Yrs of Experience in Amazon Web Services

Texas Workforce Commission experience