Data Warehouse Architect

Job Location Atlanta, GA, USA
Position Type Full time position
Job Length
Work Experience
  · Data Architect (Must have 5-7 years experience)
Skill Requirements
 
· SQL · ORACLE
· UNIX · ETL
· Data Warehousing · Business Objects
Other Required Skills Erwin

# The candidate needs to be a solid and seasoned IT Data warehouse designer with deep understanding of large scale reporting, including business and technical approaches.

# Strong business background with exceptional communication skills.

# Data Warehouse design experience; the resource needs to be proficient in assessing, designing and performance tune a reporting solution in a Teradata environment.

# The candidate needs to be a solid and seasoned IT business analyst with deep understanding of data warehousing from a business and technical perspective.

# Strong experience with SQL and BTEQ.

# Ability to write clear requirements and bridge the gap between IT and the business.

# Excellent communication and customer skills.

# Teradata experience, or experience working with over 1 terabyte of data (1 million records).

# Strong experience with Informatica-based ETL processes.

# Strong Erwin Data Modeling Experience.

# Great Documentation / Communication Skills.

# Great at data warehousing life cycle and concepts.

# Experience in using Erwin.

# Understanding of 3NF modeling and Dimensional(Star Schema) modeling - A MUST.

# Experience with Business Objects design.

# 3+ years as a BTEQ developer and 1+ years experience as a Lead developer or ETL architect in the Teradata Environment.
Other Nice to Have Skills
Minimum Immigration Status US Citizen
Job Starting Date April 20, 2014
Wage/Salary Annual: 107 K per year to 139 K per year


Job Description
  # Works with the users to define and document data warehouse business requirements as the foundation for database design, data extraction, analysis or cleansing.

# Determines, designs and documents data mapping rules for movement of data between applications or for population of new databases.

# Supports data selection, extraction, and cleansing for corporate applications, including data warehouse and data marts.

# Creates and sustains processes, tools, and on-going support structures that enable reuse and efficiency.

# Investigates and resolves data issues across platforms and applications, including discrepancies of definition, format and function.

# Creates data models, including robust data definitions, which may be entity-relationship-attribute models, star, or dimensional models.

# May also create data flow diagrams and process models and integrates models across functional areas and platforms.

# Works with DBA's to transition logical model to physical mode.

# Creates UAT test plan.

# Oversees users during UAT.

# Develop detailed ETL specification by co-ordination with the Solutions Architects and Data Architects.

# Develop ETL mappings/Scripts according to the standards.

# Interpret the System requirements document and create Unit Test Plan and Unit test specifications.

# Unit testing of the ETL applications in the development environment.

# Documentation of Unit test results.

# Resolve any application related issues escalated from system testing.

# Resolve any application related issues escalated from User Acceptance testing.



If you already have your itjobs password, enter it below and your resume will be automatically forwarded to this job.
  Email Address:
Password:


If do not have an itjobs password, click the button below will let you fill one out and submit it to the job.



We Appreciate your Comments!

Copyright © IntraGroup, Inc. All rights reserved.
Reproduction in whole or in part in any form or medium without express written permission of IntraGroup, Inc. is prohibited.