Senior Teradata Data Warehouse Architect

Teradata Data Warehouse Architect



Hitachi Consulting is seeking a person to join our Business Intelligence Performance Management group to work with clients, business analysts to design, develop, and enhance BIPM solutions. Candidate will participate and play lead architect role throughout the entire project life cycle to ensure conformance to design, overall data warehouse architectural compliance and infrastructure coordination and preparation including data warehousing blueprints/roadmaps/diagnostic tool selections.

 Description:General consulting skills including: team facilitation, business case development, analyze customer requirements, etc. Project management: lead/mentor/coach small teams of 2-6 resources (both consulting and client employees). Significant experience with Teradata (>25 Terabytes, Teradata footprints, Data appliance experience a huge, plus) Significant Data Architecture experience including design and build the data model (conceptual, logical, physical), setting/enforcing standards, provide estimates of changes to existing and future releases, data model review sessions, etc. Deep experience with standard data modeling techniques such as 3rd normal form, dimensional (star schema and snow flake), and object oriented data models Experience with ETL architecture, design and build. Assist with pre-sales from a technical architect perspective as required including white boarding, technical solution recommendations and engaging with the business user’s at the client company.

 

Minimal Qualifications:Bachelor’s degree 10+ years experience with designing Enterprise Data Warehouse Architecture, Data Architecture, Data Modeling and ETL Architecture. 10+ years experience with design (logical, physical, conceptual, both Star and Snowflake schemas, ETL & OLAP tools (Hyperion, Cognos, Business Objects, Informatica, Ab Initio or other industrial strength tool), and multiple RDBMS (Oracle, SQL Server, DB2, etc.) Knowledge and experience with UNIX, relationship database technology and end user tools Knowledge and experience with Oracle to Teradata migration tools, techniques and methodologies Must be willing to be “hands on” Technical Architect Teradata Master a hugevplus