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)

Skills: Database Programming, Database Development, MySQL, Azure, Data Processing

See more: 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

About the Employer:
( 0 reviews ) Toronto, Canada

Project ID: #20105100

15 freelancers are bidding on average $557 for this job


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 More

$750 CAD in 7 days
(18 Reviews)

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 More

$700 CAD in 7 days
(9 Reviews)

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 More

$500 CAD in 7 days
(11 Reviews)

⭐⭐⭐⭐⭐ 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 More

$500 CAD in 7 days
(6 Reviews)

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. More

$777 CAD in 10 days
(9 Reviews)

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 More

$500 CAD in 10 days
(4 Reviews)

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 More

$722 CAD in 15 days
(2 Reviews)

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 More

$500 CAD in 7 days
(1 Review)

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 More

$750 CAD in 2 days
(1 Review)

“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 More

$250 CAD in 2 days
(0 Reviews)
$555 CAD in 10 days
(1 Review)

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 More

$500 CAD in 7 days
(1 Review)

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 More

$250 CAD in 3 days
(0 Reviews)

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 More

$600 CAD in 10 days
(0 Reviews)

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 More

$500 CAD in 7 days
(0 Reviews)