Title: Data Warehouse Architect

Location: Columbus, OH

Length: Long Term

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

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.

5 or more years of experience with Kimball and Inmon methodologies

5 or more years of experience with the AllFusion Erwin modeling tool,
including Model Mart Repository advanced features (e.g. checkin/out,
complete compare)

3 or more years of experience in data profiling, data mining and data
cleansing.3 or more years of experience in the use of organizational tools
& methods (MS Excel, MS Word, MS outlook, VISIO, Clarity)

Experience developing complex sql  against normalized as well as
dimensional data structures

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

Experience on an IBM/DB2 platform

Experience in measuring and tuning the performance of Oracle Data Warehouse


3 or more years of experience working with designers/developers who use the
Cognos Business Intelligence tools.

Ability to effectively communicate with business and IT staff

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

Knowledge of the PowerSuite Claims, Policy, and Billing application

Typical Daily Activities:

Work with PowerSuite SME to understand the PowerSuite application business
functionality and write complex queries to understand how the data is
stored in the PowerSuite Transactional System.

Work with Cognos Framework Model SME, PowerSuite SME and other Data
Architects to identify dimension and facts tables to be built.

After designing dimension and fact tables, hold design review sessions to
obtain approval and sign off.

Deploy new tables directly to the test environment using the Erwin tool

Produce diagrams and table/column definitions reports from Erwin and upload
to the project Sharepoint site.

Map the data from the Operational Data Store to the dimension/fact tables
and create an ETL mapping document, using a predefined template, for the
ETL developers.

Work with Business Analysts and potentially business customers to verify
requirements Work with IT ETL and Report Developers to communicate database
designs, answer questions and refine/update ETL mapping documents as needed.

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

Work with Business Analysts and potentially business customers to verify

Thanks & Regards,

Ramesh Kumar

*Global **Associates Inc/ **VCarve Inc*

*||* 7106 Corporate Way* ||* Dayton, OH 45459 *||*

*||*Phone:  937-877-5870 * ||* Fax: 937-312-1205 *||*

ram...@gassociates.com* or*  ram...@vcarve.com *||*

[image: View my profile on LinkedIn]<http://www.linkedin.com/in/rameshkumarpc>

*Note: Under Bill s.1618 Title III passed by the 105th U.S. Congress this
mail cannot be considered Spam as long as we include contact information
and a remove link for removal from our mailing list. To be removed from our
mailing list reply with "remove" and include your "original email address /
addresses" in the subject heading. Include complete address/addresses
and/or domain to be removed. We will immediately update it accordingly. We
apologize for the inconvenience if any caused.*

You received this message because you are subscribed to the Google Groups 
To unsubscribe from this group and stop receiving emails from it, send an email 
to reqsresumes+unsubscr...@googlegroups.com.
To post to this group, send email to reqsresumes@googlegroups.com.
Visit this group at http://groups.google.com/group/reqsresumes.
For more options, visit https://groups.google.com/d/optout.

Reply via email to