DirectClient: Texas Workforce Commission(TWC)
Solicitation#4206023DS1
Title: ETL Informatica Developer
Location: 101 E. 15th Street, Austin, Texas 78701
Duration: Until 8/31/2023 with possible extension
Last date for submission: May 1, 2023 (9.00 AM-CST)
No. of positions: 6
Important Note: The position is eligible for telecommuting from anywhere in the state of Texas. Candidate must be residing in Texas or willing to relocate to Texas by their start date.
DESCRIPTION OF SERVICES
The Data Scientist/ETL Developer will be responsible for:
• 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
• Responsible for writing code to populate the data structures.
WORKER SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Skills/Experience
1-3 Design and develop Extraction, Transformation, Load (ETL) processes for 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.
1-3 Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc.
1-3 Hands on experience with data modeling.
1-3 Experience with Informatica product suite in the Informatica cloud.
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/Experience
1-3 ERWin or other equivalent data modeling tools
1-3 More than one type of RDBMS (Informix, SQLServer, Oracle)
1-3 Experience in Public Sector delivery
1 Experience with TWC environment and technology platforms
1 Experience with TWC business processes and data sources
Certified Data Management Professional (CDMP)