DirectClient: Texas Workforce Commission (TWC)Solicitation#3686622DBA23Title: Data ArchitectLocation: 101 E. 15th Street, Austin, Texas 78701Duration: Until 11/30/2023 with possible extensionLast date for submission: May 26, 2022 (9.00 AM-CST)No. of positions: 2
Note: Remote allowed until COVID-19 situation settles. This position is eligible for telecommuting from anywhere in the state of Texas
DESCRIPTION OF SERVICES:TWC is developing a data warehouse solution and requires a Data Warehouse Architect – senior ETL developer with proven data warehouse experience to:• Design, develop, and test ETL processes for the data warehouse.• Develop and document ETL processes to extract data from existing systems into the data warehouse. • Document the “as-is” schemas currently in use at TWC.• Perform other analysis and documentation tasks as required to facilitate and support TWC’s Enterprise Data Warehouse.
WORKER SKILLS AND QUALIFICATIONSMinimum Requirements:Years Skills/Experience7 - 8 Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc., preferably Oracle.7 - 8 Experience with Oracle PL/SQL.6 - 8 Hands on experience with data modeling preferably in a data warehouse environment.3 Experience with Informatica product suite in the Informatica cloud.Strong Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.Strong Communication, analytical and interpersonal skills at all levels.Strong Technical writing skills. Preferred:Years Skills/Experience6 More than one type of RDBMS (DB2, SQL Server, Oracle).4 Experience in Public Sector delivery.4 Experience writing dynamic SQL.