Find Jobs
Hire Freelancers

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

$250-750 CAD

Anuluar
Postuar almost 5 years ago

$250-750 CAD

Paguhet në dorëzim
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 e Projektit: 20105100

Rreth projektit

10 propozime
Projekt në distancë
Aktive 5 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
10 freelancers are bidding on average $605 CAD for this job
Avatari i Përdoruesit
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 ditë
5,0 (20 përshtypje)
5,9
5,9
Avatari i Përdoruesit
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 ditë
4,9 (10 përshtypje)
5,3
5,3
Avatari i Përdoruesit
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 ditë
4,9 (11 përshtypje)
4,5
4,5
Avatari i Përdoruesit
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 ditë
5,0 (9 përshtypje)
3,9
3,9
Avatari i Përdoruesit
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 ditë
3,2 (2 përshtypje)
4,3
4,3
Avatari i Përdoruesit
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 ditë
4,9 (2 përshtypje)
1,6
1,6
Avatari i Përdoruesit
“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 ditë
0,0 (0 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 ditë
0,0 (2 përshtypje)
0,0
0,0
Avatari i Përdoruesit
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 ditë
0,0 (0 përshtypje)
0,0
0,0

Rreth klientit

Flamuri i CANADA
Toronto, Canada
0,0
0
Anëtar që nga qer 26, 2019

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.