Database Architect 2 (5176425DA2)

Remote – United States

Scope/Description of Services

Provide the following services:  Perform Database Architect work as a member of the Data Governance team, overseeing one or more projects concurrently. Design, develop, and test Extraction Transformation Load (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. Define and document the technical architecture.

Perform other analysis and documentation tasks as required. Perform other duties as assigned to maintain operations.

Minimum Requirements: Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will not be considered for this opportunity. Please submit years of experience in each category with your application/cover letter.

Years ( leave no

blanks)

Years

Skills/Experience

 

 

4-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

 

 

4-7

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

 

 

4-7

Analyzing and generating technical requirements and design

 

 

4-7

Hands on experience with data modeling preferably in a data warehouse environment

 

 

4-7

Experience with Informatica product suite in the Informatica cloud

 

 

4-7

Creating source to target mapping database documentation

 

 

4-7

Assist with migrating data from legacy database to new target database

 

 

Preferred:

Years

Skills/Experience

 

 

3

More than one type of RDBMS (DB2, SQL Server, Oracle)

 

 

3

 

erwin or other equivalent data modeling tools

 

 

 

2

Experience in Amazon Web Services

 

 

 

Texas Workforce Commission experience

 

Start Date:  May 2025 End Date: 08/31/2025. May be extended up to four years.

Note:  Must have a secure, dedicated workspace with Internet service, ability to maintain a reliable consistent work schedule, and be available for weekly meetings and group collaboration via Microsoft Teams and other applications during regular business hours. Normal business hours are Monday through Friday from 8:00 AM to 5:00 PM.  Position may require team members to come into the office; there may be unscheduled requests with seventy-two (72) hour notice for any TWC business need.