Job Description :
*Role: *Data Warehouse Architect

*Location:* Lansing, MI

*Duration: *12 months

*Rate: *DOE

*Visa: *H1B/GC/Citizen

*Job Type: *C2C/W2/1099


*Designs, implements and supports data warehousing *in a *Teradata
database environment The position has responsibility for data base
planning, development, administration and maintenance/ETL of the
client''s data warehouse.

Relies on experience and judgment to plan and accomplish goals,
independently performs a variety of complicated tasks, a wide degree of
creativity and latitude is expected.

*Designs, implements and supports* *data warehousing Implements
business rules via stored procedures, *middleware*, or other
technologies. Defines user interfaces and functional specifications.

Responsible for verifying accuracy of data, and the maintenance and
support of the data warehouse. Knowledge of data warehouse end-to-end
implementation processes, from business requirement logical modeling,
physical database design, *ETL*, end-user tools, database, *SQL*,
performance tuning.

Demonstrated problem resolution skills with team of
persons, and strong leadership with implementation team Experience in
data warehouse design and data modeling (both relational and
dimensional) and development and maintenance of multi-dimensional data
models. Development experience in implementation of data warehousing
utilizing *RDBMS

Understanding of data warehouse *Metadata* concepts,
tools and different data warehouse methodologies. Expertise in SQL and
proficiency in database tuning techniques. Responsible for the ongoing
architecture and design of the data warehouse, data mart, and reporting
environments. Develop strategies for flexibility and scalability, and
define the future technical architecture direction for the business
intelligence reporting physical environment.

Responsible for proper selection of appropriate hardware, software,
tools and system lifecycle techniques for the different components of
the end-to-end data warehouse architecture including ETL, metadata, data
profiling software, database platform, performance monitoring, reporting
and analytic tools. Defining and documenting the technical architecture
of the data warehouse, including the physical components and their
functionality. Setting or enforcing standards and overall architecture
for data warehouse systems. Monitoring the data warehousing industry and
assisting in establishing the organization''s data warehousing strategy
and section of strategic warehousing tools and techniques. Ensuring
compatibility of the different components of the DW architecture and
ensuring alignment with broader IT strategies and goals. Ability to
educate the project teams on the standards and architecture of each
component of the data warehouse architecture. Very strong written and
oral communication skills, including some presentation skills.

*Skills/ Experience :*

(1) Teradata physical modeling and indexing

(2) Teradata ETL development
(3) UNIX / Linux shell scripting
(4) UNIX / Linux Operating System

(5) Teradata SQL
(6) Teradata Security
(7) ETL tools - Datastage
(8) BI inquiry tools including Business Objects, BI-Query