Database Architect

Remote: 
Full Remote
Contract: 
Work from: 

Offer summary

Qualifications:

Bachelor's degree in Computer Science or related field., 4-7 years of experience in ETL processes and data warehouse development., Hands-on expertise with Informatica and relational databases, preferably Oracle., Experience with data modeling and technical documentation..

Key responsabilities:

  • Oversee multiple projects as part of the Data Governance team.
  • Design, develop, and test ETL processes for the data warehouse.
  • Document existing schemas and define the technical architecture.
  • Assist in migrating data from legacy systems to the new database.

Numentica LLC logo
Numentica LLC SME https://www.numentica.com/
201 - 500 Employees
See all jobs

Job description

This is a remote position.

Requirements

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.



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



Required profile

Experience

Spoken language(s):
English
Check out the description to know which languages are mandatory.

Data Architect Related jobs