Dibatalkan

Data Factory Developer / Data warehouse snowflake or star scheme design developer

31 table to create

Design order management data warehouse schema.(snowflake/ star schema) on azure sql

Will provide 31 tables sql file.

Look at the all table structure and pull out respective facts and dimension of that table on azure sql.

(We need proper indexing, partition on dimension and facts table.)

Also design all stored procedure views to populates that facts and dimension will call stored procedure in data factory.

Also create as tracking process of data push from staging table to schema facts and dimension table, last sync date time. (Audit table)

Stored procedure will be dynamic way which can handle parameters. Full push or incremental push from 31 tables.

Also design a process to push the schema on azure sql (Facts and dimension) to Azure analysis server. (Automation process)

Kemahiran: Pengaturcaraan Pangkalan Data, Pembangunan Pangkalan Data, MySQL, Azure, Pemprosesan Data

Lihat lagi: web design developer work need com, design developer webservice turnkey contract, typo3 template design developer, companies design developer soluation, professional web design developer world warcraft, website design developer, small website design developer needed, messenger design developer, iphone design developer spreadsheet excel, graphic design developer needed, freelance web developer services computers & telecoms website design uk, freelance web developer services computers telecoms website design uk, web design developer, wordpress developer needed for fully responsive design, android design developer icon, flexi hours job web design developer, freelance handbag design developer pattern cutter, front end web development and design developer for hire, logo design developer

Tentang Majikan:
( 0 ulasan ) Toronto, Canada

ID Projek: #20105100

15 pekerja bebas membida secara purata $557 untuk pekerjaan ini

desconit

Hi, I have over 10 years of industry experience in databases and datahouse modeling. I have worked on IBM Cognos, SQL Server, Oracle. SSIS and SSRS. I appreciate if you provide schema of 31 tables so that i can loo Lagi

$750 CAD dalam 7 hari
(18 Ulasan)
5.9
SergioAlfaroV

Hello! I am a Computer Engineer, with a Master of Business Administration and a MCSA SQL Server 2014, with 12 years of experience using SQL, queries, reports and dashboards design and construction, data warehousing, an Lagi

$700 CAD dalam 7 hari
(9 Ulasan)
5.3
akioUnity

Hello. I am a full stack developer with 8 years experience building web and mobile application. My code is clean. I am hard working, motivated, friendly, and honest person. I can create as tracking process of data push Lagi

$500 CAD dalam 7 hari
(11 Ulasan)
5.2
WebExpert555

⭐⭐⭐⭐⭐ Hi, I am Ruyun. ⭐⭐⭐⭐⭐ After reading the description carefully, I've convinced this project is very suitable for me. Through over 8 years, I've been developing so many kinds of big and small projects with CSS, Bo Lagi

$500 CAD dalam 7 hari
(6 Ulasan)
4.5
tausy

Hi, I'm a data engineer with over 5 years of experience building BI/DWH solutions. I have deep knowledge and understanding of SQL, PL/SQL, Dimensional Modelling and worked on Informatica PowerCenter and SSIS before. Lagi

$777 CAD dalam 10 hari
(9 Ulasan)
4.4
jayantavkumar

I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P Lagi

$500 CAD dalam 10 hari
(4 Ulasan)
3.6
OWDGroup

Hi, I'm a database architect and programmer having more than 15 years of experience with different types of domains like telecom, banking, payroll, crm, insurance, ecommerce etc with high data volumes and I'm experien Lagi

$722 CAD dalam 15 hari
(2 Ulasan)
1.7
romansokolv708

Dear client! Thank you for your job posting. I have read your description carefully and I am very interested in your project. I have lots of experience like that before. DBMS, MySQL and data warehouse is my main skill Lagi

$500 CAD dalam 7 hari
(1 Ulasan)
1.7
theukwebexpert

Hello there! My name is Chris, I'm a UK based and native English speaking web developer and app expert with 10 years experience building and maintaining complex web apps and websites. I've built and maintained applica Lagi

$750 CAD dalam 2 hari
(1 Ulasan)
0.8
Arjun9645

“People find me to be an upbeat, self-motivated team player with excellent communication skills. For the past several years I have worked in lead qualification, telemarketing, and customer service in the technology ind Lagi

$250 CAD dalam 2 hari
(0 Ulasan)
0.0
$555 CAD dalam 10 hari
(1 Ulasan)
0.0
vivi1990

Good day! I'm a licensed full stack programming developer and designer. I have many experiences in laravel, wordpress, CI, python as backend. And I had several experiences in angular.js, react.js, node.js, Vue.js, m Lagi

$500 CAD dalam 7 hari
(1 Ulasan)
0.0
Molotova

Dear sir. How are you? I have gone through the requirement and would like to raise my interest in the same. I am an expert at : PHP, Mysql, Database administration. I believe I have most of the skills that you are seek Lagi

$250 CAD dalam 3 hari
(0 Ulasan)
0.0
agarwalharsh71

Hello, I'm a Sr. Business Intelligence Analyst with over 5 years of experience building BI & Warehouse solutions using Azure Sql Server, Analysis Services, Multi-dimensional Modelling, Azure Data Factory, Blobs, SSIS Lagi

$600 CAD dalam 10 hari
(0 Ulasan)
0.0
blackwhite123

Hello, I am pleasure with your job for Data Factory Developer / Data warehouse snowflake or star scheme design developer. Thank you for the job posting. It’s a pleasure to meet you. I’d really like to work with you on Lagi

$500 CAD dalam 7 hari
(0 Ulasan)
0.0