SSIS ETL expert with experience in managing large datasets
- or -
Post a project like this$$$
- Posted:
- Proposals: 6
- Remote
- #2104628
- Expired
Description
Experience Level: Expert
Create a tabular and cube model for one big table (100 millions of records) and 4 small tables, you must be expert in: SQL Server 2017, SSIS /SSAS by using VS 2017 and Power BI Desktop. Scenario: DataSource: Oracle/On-premise Destination: SQL Server Enterprise / Azure VM Restrictions: - Fast ETL process for a large data sets by using partitioning table, clustered columnstore indexes and other kind of technics. - Destination has 2 databases, the one first is staging DB and the second one is Data Mart DB both are in the same server. - You must optimize the model in order to visualizing whole data in Power BI Desktop. - Calculate 3 measures based on biz. rules.
Analitica S.
0% (0)Projects Completed
-
Freelancers worked with
-
Projects awarded
0%
Last project
26 Apr 2024
Chile
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies