Database Architect (ETL & Informatica Cloud)

  • Posted 6 hours ago | Updated 6 hours ago

Overview

Remote
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)
No Travel Required

Skills

Informatica
PL/SQL
Data Warehouse
Data Quality
ERwin
ETL
Informatica Cloud
Data Management
As-is Process
Data Governance
Data Modeling

Job Details

Role: Database Architect (ETL & Informatica Cloud)

Location: Austin, TX (Remote)

Duration: 1-4 Years

Experience: 10+ Years

Summary:

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 the client. Perform other analysis and documentation tasks as required to facilitate and support the client 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.

Required Skills:

  • 4-7 Years of 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 Years of 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 Years of Analyzing and generating technical requirements and design
  • 4-7 Years of Hands on experience with data modeling preferably in a data warehouse environment
  • 4-7 Years of Experience with Informatica product suite in the Informatica cloud
  • 4-7 Years of Creating source to target mapping database documentation
  • 4-7 Years of Assist with migrating data from legacy database to new target database

Preferred Skills:

  • 3 Years of More than one type of RDBMS (DB2, SQL Server, Oracle)
  • 3 Years of Erwin or other equivalent data modeling tools
  • 2 Years of Experience in Amazon Web Services
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.