Job Description
Data Scientist/ETL Developer
Location: Austin Texas
Client: Texas Workforce Commission (TWC)
Solicitation Number: 4206023DS1
No of Roles:#6
Only LOCAL to Texas Candidates
The position Will be 100% Remote in Texas
Experience: Minimum 10+ Years Must
Location: Austin Texas
Client: Texas Workforce Commission (TWC)
Solicitation Number: 4206023DS1
No of Roles:#6
Only LOCAL to Texas Candidates
The position Will be 100% Remote in Texas
Experience: Minimum 10+ Years Must
Note : Candidate Must Have State Experience
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.
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.
Minimum Requirements:
Design and develop Extraction, Transformation, and 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.
Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc.
Hands-on experience with data modeling.
Experience with the 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.
ERWin or other equivalent data modeling tools
More than one type of RDBMS (Informix, SQLServer, Oracle)
Experience in Public Sector delivery
Experience with TWC environment and technology platforms
Experience with TWC business processes and data sources
Certified Data Management Professional (CDMP) : Preferred
Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc.
Hands-on experience with data modeling.
Experience with the 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.
ERWin or other equivalent data modeling tools
More than one type of RDBMS (Informix, SQLServer, Oracle)
Experience in Public Sector delivery
Experience with TWC environment and technology platforms
Experience with TWC business processes and data sources
Certified Data Management Professional (CDMP) : Preferred