Encerrado

Citi bike trips data analysis

Job Description:

RoadMap

OLTP DATABASE DESIGN (NORMALIZED DESIGN)

 Enterprise Database Model

 Logical Database Model

 Relational Database Model

 DDL Generation

OLTP DATABASE IMPLEMENTATION

>Create Objects (Tables, Indexes, Triggers, Function, Procedures)

> Populate Data

> Test Data, Constraints, Triggers for validations

DATA WAREHOUSE DESIGN and IMPLEMENTATION

 DE-Normalization from OLTP design (STAR SCHEMA with DIM_DATE dimension)

 Enterprise, Logical, and Relational Model

 DDL code generation and Creation of Schema

ETL CODE

 Extract from OLTP database based on timestamp (CDC-change data

capture)

 Transform Data to match DW schema (using External tables, and PL/SQL)

 Load Data to DW schema

Reports and Analytics from DW database, e.g. using Tableau

> Use any reporting tool for querying data

> Generate reports, Data analytics charts/graphs, Dashboard

Suggested Inclusion:

The project will have two different database systems of different vendor

products

(E.g. Oracle and MySQL)

>One database will be of OLTP database (Online Transaction Processing

System) and other database will be DW (Data Warehouse – DSS)

> Reporting tool / Analytics tool will be interfaced with DW database

> There will be ETL (Extract, Transform, and Load) database code to load

data from OLTP database, transform it matching DW schema design, and

then loading it to DW database.

>There will be CDC approach (Change Data Capture) for ETL database

routine to implement incremental ETL

> Will use advance database features e.g. External tables, Partitioned Tables,

function base indexes, PL/SQL(procedures, functions, packages, triggers,

data masking)

> The DW systems, will have more analytics and reporting for making

business decisions

> There will be development for EDI (Electronic Data Interface), SQL Loader

(DB utility for loading data to database from a text file)

> There will be use of data movement utilities (exports/import, SQL Loader

etc.)

> There will be use of data analytics using data visualization tool, such as

Tableau, ClickView etc.

Habilidades: MySQL, Armazenamento de Dados, Data Visualization, Data Analysis, ETL

Sobre o Cliente:
( 1 comentário ) udaipur, India

ID do Projeto: #35390880

9 freelancers estão ofertando em média $37 nesse trabalho

CourserXu

Hello there, I have read your requirements and am confident I am the right candidate for the job. Among other things, I have over ten years of experience in Oracle PLSQL, PostgreSQL, MySQL, MS SQL, and others NoSQL. F Mais

$30 USD in 7 dias
(2 Comentários)
2.9
meganachunchu

Hi, I am ready to work now I have more than 10 years experience in PHP API development and my price 5USD /hour My bid is 50USD for this task

$15 USD in 7 dias
(2 Comentários)
2.9
Bhatti1987

I have total 12 plus years of experience especially in Development, DWH, ETL, SSIS, SSRS, SSAS, SQA, Database development & maintenance. • Very strong in Open Interfaces, SQL, PL/SQL, Stored procedures/packages, writin Mais

$50 USD em 1 dia
(6 Comentários)
2.4
icuatgmlrkfphqi1

Hi I am excited ,because you give me a chance. I have carefully checked your requirements and am really interested in this project. I have already done this type of projects. I will be my pleasure to work with you. Mais

$20 USD em 1 dia
(0 Comentários)
0.0
pratik123

HI I am sql database professional who has industry extensive experience in several databases. I can give training , support, in any project and resolve your work asap. Hope to meet you soon. Thank you.

$100 USD in 15 dias
(0 Comentários)
0.0
ammarshaikh724

Hello there I am Ammar Shaikh I have 6 years experience in database administration i.e. mysql data warehousing data analysis ETL kindly ping me for more details

$50 USD em 1 dia
(0 Comentários)
0.0
saiaashish97

Hi I have gone through the requirement and i believe i am the right person to do this as i have around 5 years experience in Data Warehousing, ETL and OLTP. successfully completed multiple project with same kind of req Mais

$25 USD in 7 dias
(0 Comentários)
0.0
bhuvaneeshwari

Profound experience in data warehousing and highly flexibly in working. Have already worked in ETL tools - Informatica and got appreciation from clients

$15 USD in 7 dias
(0 Comentários)
0.0