Find Jobs
Hire Freelancers

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

$250-750 CAD

Anulat
Data postării: aproape 5 ani în urmă

$250-750 CAD

Plata la predare
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)
ID-ul proiectului: 20105100

Despre proiect

10 propuneri
Proiect la distanță
Activ: 5 ani în urmă

Vrei să câștigi bani?

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal
Îți primești plata pentru serviciile prestate
Evidențiază-ți propunerea
Te înregistrezi și licitezi gratuit pentru proiecte
10 freelanceri plasează o ofertă medie de $605 CAD pentru proiect
Avatarul utilizatorului
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 look into this and come up my questions (if any). I look forward to hearing from you. Regards, Farooq
$750 CAD în 7 zile
5,0 (20 recenzii)
5,9
5,9
Avatarul utilizatorului
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, and overall Business Intelligence related projects and tasks. I am a near-native English speaker, currently available, SQL expert, business-savvy, and results oriented. I have vast experience with the MS BI Suite: SSIS/SSAS/SSRS/TSQL. I have all the MS software required to work installed on my premises. Alternatively, I can connect remotely to work. Finally, I am located in the Central Daylight Timezone (UTC -5h). We can talk over chat if you need. Thanks!
$700 CAD în 7 zile
4,9 (10 recenzii)
5,3
5,3
Avatarul utilizatorului
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. Currently, I'm pursuing Master's in Data Science from Trinity College Dublin and would like to discuss this project with you. Thanks, Tousif
$777 CAD în 10 zile
4,9 (11 recenzii)
4,5
4,5
Avatarul utilizatorului
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 (P4) BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4) Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3) Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$500 CAD în 10 zile
5,0 (9 recenzii)
3,9
3,9
Avatarul utilizatorului
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 applications/sites for large companies such as Coca Cola, Deutsche Bank, Easy Jet, Barclays, Vogue, Menzies, NHS, My specialist skills include: PHP, Javascript , MYSQL, Bootstrap, SEO, Digital Marketing, Laravel, IONIC, WooCommerce, Moodle, WordPress, Drupal, New Website Builds, Search Marketing, Graphic Design, NGINX, Apache2. I'm highly motivated, results driven and personable individual with a keen eye for details and getting projects finished in a quick timescale, whilst still delivering a world class customer experience. Chris Fairman
$750 CAD în 2 zile
3,2 (2 recenzii)
4,3
4,3
Avatarul utilizatorului
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 experienced with oracle and ms-sql and also experienced with ssis for data migration and data cleansing. Please contact me for more information and please let me know the domain and let us discuss for the data model of mentioned order management. Cheers!
$722 CAD în 15 zile
4,9 (2 recenzii)
1,6
1,6
Avatarul utilizatorului
“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 industry. My experience includes successfully calling people in director-level positions of technology departments and developing viable leads. I have a track record of maintaining a consistent call and activity volume and consistently achieving the top 10 percent in sales, and I can do the same thing for your company.”
$250 CAD în 2 zile
0,0 (0 recenzii)
0,0
0,0
Avatarul utilizatorului
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, material ,bootstrap as frontend. I have many experiences in c#,c++,c,java programming. I'm interested in your project, please feel free to check my clients reviews, my profile and if you are interested too, we can discuss more details. Thank you very much.
$500 CAD în 7 zile
0,0 (2 recenzii)
0,0
0,0
Avatarul utilizatorului
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 and MS Power BI to visualize the data (creating dashboards). I have worked with an e-commerce giant completing several projects involving schema designing, analysis and automation process. I have completed my Master's in Data Science & Business Analytics and would like to discuss this project with you.
$600 CAD în 10 zile
0,0 (0 recenzii)
0,0
0,0

Despre client

Steagul CANADA
Toronto, Canada
0,0
0
Membru din iun. 26, 2019

Verificarea clientului

Mulțumim! Ți-am trimis prin e-mail linkul pe care trebuie să-l accesezi pentru a revendica creditul gratuit.
A apărut o eroare la trimiterea e-mailului. Încearcă din nou.
Utilizatori înregistrați Totalul proiectelor postate
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Se încarcă previzualizarea
S-a oferit permisiunea de depistare a locației.
Ți-a expirat sesiunea pentru conectare sau te-ai deconectat. Conectează-te din nou.