
	Home About Us Services Site Map White Papers Web Briefings Careers Contact Us

	Careers

	Oracle Applications
	Enterprise Performance Management
	Business Intelligence
	Custom Development
	Database Services
	Managed Services
	Hosting Services
	Training/Mentoring
	Oracle Licensing
	Project Management

	SOA Today
	Rolta CA Solutions
	Rolta-TUSC Asia Pacific
	Rolta-TUSC Middle East / Africa
	Rolta-TUSC UK/Europe
	Careers
		Career Opportunities
		Contact TUSC
		Referrals

Data Warehouse Architect

Click here to apply for this position.

Location

Chicago

Job Description

As a Data Warehouse Architect, you will act as the primary technical architect for our 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.

Job Requirements

• A minimum of 5 years experience architecting large scale data warehouses using Oracle

• A minimum of 7 years of relevant consulting experience preferred or 10 years of corporate IT

• Expert data modeling skills (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data Warehouses and Data Marts

• Expert RDBMS knowledge of Oracle (release 9i and 10g)

• 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

• Functional knowledge of Java and J2EE integration technologies

• Possess strong communication and client management skills.

• Ability to effectively manage multiple projects simultaneously

• Ability to travel to client site as needed

• BS in Computer Science or equivalent experience in a relevant field

Responsibilities

• 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 health 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

Disclaimer