Data Warehouse Architect

Designs, implements and supports data warehousing in a Teradata database environment, with responsibilities including data base planning, development, administration and maintenance/ETL of the MDARD data warehouse.

Requirements

• 5 or more years of Teradata physical modeling and indexing techniques
• Knowledge of data warehouse end-to-end implementation processes
• Experience in data warehouse design and data modeling (both relational and dimensional)
• 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
• 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