KPIT Infosystems Inc. is a global, USD 300 MN, business consulting & IT solutions partner focused on the hi-tech and manufacturing industry. Our customers and consultants are present across US, UK, Germany, France, Brazil, Mexico, India, Japan, and Korea. With 8000+ consultants and expertise in Enterprise IT Solutions, Supply Chain Consulting, Enterprise Web Applications, Middleware, Integration, we help global corporations meet their evolving business priorities. Please visit us at www.kpitcummins.com for more info.
Currently we are looking for "Senior Data Warehouse Architect" for our Fortune 100 Client to be a part of their Enterprise Data Warehouse team.
Job Location: Houston, TX
Duration: 1 yr Contract
As a Data Warehouse Architect, you will act as the primary technical architect for data warehousing projects to solve some of the toughest challenges in business intelligence today. The successful candidate should possess deep technical expertise in database design, ETL, reporting and analytics and will have previous consulting experience utilizing a structured delivery methodology.
Required skills :
A minimum of 10 years’ experience architecting large scale data warehouses
A minimum of 7 years of relevant consulting experience preferred or 15 years of corporate IT
Expert data modeling skills (i.e. conceptual, logical and physical model design - with both traditional 3 rd normal form as well as dimensional modeling (star, snowflake), experience with Operation DataStores, Enterprise Data Warehouses and Data Marts
Expert with pro's and con's of multiple warehouse architectures
Expert in Data Sourcing from multiple sources.
Expert RDBMS knowledge of Oracle (release 9i and 10g) including very large databases
Expert in load design strategies and optimization techniques
Implementation experience with ETL concepts and tools such as: Oracle Warehouse Builder, Informatica, DataStage, and ab Initio
Implementation experience with one or more of the following BI/Enterprise Reporting tools: Oracle Discoverer, Business Objects, Cognos, Brio, and Microstrategy
Possess strong communication and client management skills.
Ability to effectively manage multiple projects simultaneously
Translate client user requirements into technical architecture vision and implementation plan
Design and develop the architecture for all data warehousing components (e.g. tool integration strategy; source system data ETL strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)
Design of the data warehouse data storage strategy/technique (ODS, EDW, DM, ROLAP, MOLAP, etc.)
Design of data warehouse sub-system (e.g. QA/QC, ETL and Query metrics)
Oversight of tool evaluation and selection
Hardware recommendations, sizing and configuration
RDBMS installation, configuration and tuning
Oversight and/or coordination of system testing phase
Problem and issue resolution
Mentoring and developing junior staff
Participation in proposal development and client presentations