Create a dimensional data model
$250-750 AUD
Pagado a la entrega
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.
Nº del proyecto: #12655210
Sobre el proyecto
11 freelancers están ofertando un promedio de $638 por este trabajo
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Más
Hello, I have been working with a MNC bases company since last ~ 6 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped m Más
Contact me. I can assist you. You can also check my portfolio: https://www.freelancer.com/u/micheal4299.html I also have experience in working on similar projects. I can get it done before deadline. Let me know i Más
Having more than 15 years of IT experience , working as a Datawarehouse Architect and extensive knowledge in Microsoft BI Stack. Have created and worked in more than 5 enterprise datawarehouse end-to-end.
i have 7+year of experience in datawarehouse design and development, My key skills: Data modeling, database development, datawarehouse(star, snowflake schema) design and development
Hello, Hope you are doing well! I can help you with dimensional data modeling. I worked on similar projects recently. ------------------------------------------------------------------------------- Recent Proje Más