Design,Create Data Warehousing,Modeling,Related Data Warehouse Work

About:

PLEASE PING ME BEFORE ORDERING !

1. Design, create and develop an effective data warehouse architecture that has the data source, staging area, warehouse, data marts & users

2. Extensively involve in Dimensional Modeling by designing schema, fact and dim tables

3.  Perfect in design, create and develop fact & dimension tables with measures & attributes for accurate analytics

4.  Extensively involve in data modeling of the data with conceptual, logical & physical data modeling of data for effective data warehouse

5.  Create and implement database designs, ETL procedures and data analysis deliverables

6.  Integrate data from multiple source systems into Data Warehouse, cleansing data, Transforming and Loading data from multiple formats to the destinations

7.  Develop,optimize,maintain and support ETL processes using stored procedures & data integration tools as SSIS

8.  Extensively involve in ERD design and development with various schema such as star schema/snowflake where facts table is linked to dims table differently

9. Create Data Warehouse components, including Data Marts, Operational Data Stores and OLAP Cube databases to support analysis

Reviews

: : : : :