Database Architect
Database Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
This is a remote position.
RequirementsPerform 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 asis 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.
Years
Skills/Experience
47
Design and develop Extraction Transformation Load (ETL) processes for enterprise data warehouse using Informatica; Deep handson expertise with Informatica ETL processes development data management data profiling data flows data relationships and data quality standards and processes
47
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
47
Analyzing and generating technical requirements and design
47
Hands on experience with data modeling preferably in a data warehouse environment
47
Experience with Informatica product suite in the Informatica cloud
47
Creating source to target mapping database documentation
47
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
Software Engineer
Employment Type
Full Time
