Job Description :
DirectClient: Texas Workforce Commission(TWC)
Solicitation
Title: Data Warehouse Architect/ETL Developer
Location: 101 E. 15th Street, Austin, Texas 78701
Duration: Until 8/31/2019 with possible extension
Rate: $80/hr on W2 all inclusive(without any benefits) or $90/hr on C-C all inclusive
Last date for submission: May 20, 2019 (2.00 PM-CST)
No of positions:

Job Description:
TWC is developing a data warehouse solution and requires a Data Warehouse Architect 2 – 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 Project.

WORKER SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Skills/Experience
7 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.
7 Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle
6 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 Strong technical writing skills.

Preferences:
Years Skills/Experience
6 ERWin or other equivalent data modeling tools
6 More than one type of RDBMS (DB2, SQLServer, Oracle)
4 Experience in Public Sector delivery
Certified Data Management Professional (CDMP)

Client : TWC