Monday, 16 September 2013

DATA WAREHOUSE DATA ARCHITECT - Columbus, OH

DATA WAREHOUSE DATA ARCHITECT consultants (2)

Location: Columbus, OH

Duration: 1 year Plus

 

Interviews planned for September 23-25, 2013

(Please Note: If your candidate is not available to interview at this time, please don’t apply)

 

Projected Start Date:  October 1, 2013.

 

 

Background

Our customer is implementing a new Claims, Policy and Billing system.  This new implementation is shifting our Data warehouse and Reporting infrastructure from DB2/Hyperion to Oracle/Cognos.  The nature of our data is also changing, as data elements are changing purpose and semantics as part of the transition.

 

Customers’s new system will have a transaction data store (TDS), operational data store (ODS) and a newly designed Oracle Enterprise Data Warehouse (EDW).  With the move to an EDW, BWC will also be shifting from a relational based data warehouse towards dimensional/star-schema models.  This position will be required to aid Customer's in this shift.  Additionally, this position will be responsible for taking requirements and designing, creating, tuning and supporting Oracle Data Warehouse databases.

 

The contractors selected will be working for our Customer as Data Warehouse Data Architects in support of the Data Warehouse project. This will include:

 

  

 

Skill Sets

 

Required

 

·         10 or more years of experience in design, development, modification and testing of databases designed to support Data Warehousing and BI business teams

·         10 or more years of experience with design, development and support of normalized data structures (commonly referred to as Inmon)

·         7 or more years of experience developing Data Warehouse databases using Oracle RDBMS platform and tools.

·         5 or more years of experience with design, development, tuning and support of dimensional/star-schema based data structures including fact tables (commonly referred to as Kimball).

·         5 or more years of experience with database modeling tools (Erwin, Power Designer etc.) 

·         3 or more years of experience with Cognos Business Intelligence tools, specifically Framework Manager Modeler (FMM)

·         3 or more years of experience in the use of organizational tools & methods (MS Excel, MS Word, MS outlook, VISIO, Clarity)

 

Desired

 

·         Experience with Cognos business intelligence tools related to report creation

·         Software development experience with Oracle RDBMS 11g

·         Installation and Administration experience with Oracle RDBMS 11g

·         Software development experience with IBM DB2

·         Experience developing queries against normalized as well as dimensional data structures

·         Experience using oracle SQL*Plus, Toad, Oracle PL/SQL Developer

·         Experience with Red Hat Enterprise Linux

·         Experience developing and modifying scripts in a Linux or Unix environment

·         Experience in measuring and tuning the performance of Oracle Data Warehouse databases

·         Ability to effectively communicate with business and IT staff

·         Ability to quickly adapt to changes, enhancements, and new technologies

Nice To Have

·         Knowledge of Ohio BWC business model and processes

·         Knowledge of property and casualty insurance systems

 

 

Typical Daily Activities:

 

·         Work with Business Analysts and potentially business customers to verify requirements for data warehouse and resulting reports

·         Work with IT ETL and Report Developers to communicate database designs

·         Creating design documentation for relational and dimensional data structures

·         Design and implement data warehouse tables and data marts for consumption by report and ETL developers

·         Perform modeling tasks associated with dimensional and relational models

·         Analysis and Performance tuning of queries developed to access dimensional and relational models

·         Using Cognos and Oracle software and tools to perform required tasks

 

 

Schedule

·         Normal business hours (between 8:00 AM and 5:00 PM) Monday through Friday.

 

 

 


Bala

Accounts Manager

SSAI Technologies LLC | Board: 908 450 9465| Fax: 908 842 0244 | www.ssaitech.com | Email: bala@ssaitech.com |  bala.ssaitech@gmail.com |http://ssaitechnologies.blogspot.in/

 

No comments:

Post a Comment