Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)
100% Travel
Skills
Data Management
Data Flow
Cloud Computing
Amazon Web Services
Documentation
Data Modeling
Data Profiling
Data Quality
Data Warehouse
Database
Extract
Transform
Load
ERwin
Oracle
Extraction
IBM DB2
Informatica
Mapping
Microsoft SQL Server
Migration
PL/SQL
RDBMS
Testing
Job Details
Role: Database Architect (Face to Face Interview)
Location: Austin, TX (Onsite Day 1, Locals Only)
- Overall, 10+ years of experience Required.
- 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.
- 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.
- Analyzing and generating technical requirements and design.
- Hands on experience with data modelling 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:
- More than one type of RDBMS (DB2, SQL Server, Oracle).
- Erwin or other equivalent data modeling tools.
- 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.