Closed

Create a dimensional data model

This project received 11 bids from talented freelancers with an average bid price of $638 AUD.

Get free quotes for a project like this
Employer working
Project Budget
$250 - $750 AUD
Total Bids
11
Project Description

Requirement to convert a relational data model into a dimensional model based on standard Kiball design techniques.

There are 43 tables in the source model.

Source model comes from InfoSys Finacle which is a cloud based banking system.

Tables are not entirely 3nf as there is some consolidation during the source extract performed by Finacle.

The source model is best described as an Operational Data Store (ODS).

Your job is to convert the source model into dimensions and fact tables and produce an ERD and "create table" scripts.

Attached is an image of the source model ERD and a document describing the requirement.

Included are rules and guidelines for producing the model as well as complete metadata for all 43 tables.

Applicants should have extensive dimensional modelling experience in a banking environment with Finacle experience strongly preferred.

Feel free to ask questions.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online