Database Architect

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
  

 Preferred

• 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