This is a remote position.
Perform Database Architect work as a member of the Data Governance team overseeing one or more projects
concurrently. Test Extraction Transformation Load (ETL) processes for the data warehouse. Document ETL
processes to extract data from existing systems into the data warehouse. Document the asis schemas currently
in use at TWC. Perform complex data modeling tasks in a data warehouse environment. Create mapping documents
from source to target databases. Create database standards and best practices deliverables. 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.
Requirements
Minimum 8 years of experience required for the following Skills :
Deep handson expertise with Informatica ETL processes development data
management data profiling data flows data relationships and data quality
standards and processes
Handson 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
Analyzing and generating technical requirements and design
Hands on experience with data modeling preferably in a data warehouse
environment
Experience with Informatica product suite in the Informatica cloud
Creating source to target mapping database documentation
Assist with migrating data from legacy database to new target database
Preferred :
5 years in more than one type of RDBMS (DB2 SQL Server Oracle)
5 years in erwin or other equivalent data modeling tools
3 years in Experience in Amazon Web Services
Texas Workforce Commission experience
Software Engineer