Citi bike trips data analysis
Budget $10-30 USD
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.
9 freelancers are bidding on average $37 for this job
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
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 More
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. More
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.
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
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 More
Profound experience in data warehousing and highly flexibly in working. Have already worked in ETL tools - Informatica and got appreciation from clients
