Find Jobs
Hire Freelancers

Build data warehouse to facilitate hourly transactions

₹600-1500 INR

In Progress
Posted about 6 years ago

₹600-1500 INR

Paid on delivery
I am looking for a SQL, SSIS and SSRS expert who can create tables, stored procedures in Microsoft SQL Server and build SSIS packages to load the transaction files into the database. The files will be placed in a shared path. SSIS packages should be automated to load the data into database on hourly basis. Finally, end reports should be created using SSRS and emailed to my id to view and compare the hourly transactions.
Project ID: 16479444

About the project

17 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
A proposal has not yet been provided
₹1,500 INR in 4 days
5.0 (1 review)
2.4
2.4
17 freelancers are bidding on average ₹12,955 INR for this job
User Avatar
Hi, I have excellent knowledge in BI projects and i have worked extensively in SSIS, SSRS etc. I worked in INfosys for 15+ years and as part of this executed projects for Microsoft as Customer and this includes projects in MS BI stack Will be able to leverage this knowledge to execute projects. Once i get more details on the kind of transformation to be done will be able to provide a concrete pricing and schedule Thanks Regards Vaidy
₹16,666 INR in 10 days
5.0 (11 reviews)
4.8
4.8
User Avatar
Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 8 years and 4 months experience in SQL and 5 years and 5 months experience in SSRS, SSIS. Please let me know more details and when we will start. Sky pe: jikenjd What is up >> 9 > 8 > 9 > 8 > 8 > 9 > 0 > 0 > 4 > 9
₹7,500 INR in 0 day
5.0 (22 reviews)
4.1
4.1
User Avatar
A proposal has not yet been provided
₹22,222 INR in 15 days
4.4 (9 reviews)
3.6
3.6
User Avatar
A proposal has not yet been provided
₹35,000 INR in 15 days
5.0 (2 reviews)
2.7
2.7
User Avatar
More than 8 years experience in ETL (Extract, Transform, and Load), SSIS and SSRS. A lot of off-line projects developed using tools listed above.
₹36,000 INR in 4 days
5.0 (1 review)
1.6
1.6
User Avatar
I developed a data warehouse about a year ago(used: java and SQL Server). But it will take time of about two weeks. and you have estimated a very low budget. It needs a lot of brain work to implement it. If you are agree on price specified by me. Then you are welcome to discuss details with me.
₹27,777 INR in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 8 Years of Experience in SQL, SSIS, SSRS and SSAS Technology. handled multiple project in DataWarehouse Design and Development , Data Migration, automation through SSIS, SSRS & Power BI Report Development, OLAP Cube Development and DW Design. As per project Requirement, It doesn't seems to be exact DW Design and Loading. It seems to load file into Db and create SSRS Report on that with email subscription.
₹5,000 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am having 7 year of experience in SSIS,SSRS and SQL.i have implement many project like your JD. i am also a Microsoft certified professional. so please give me this project.
₹1,300 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹14,444 INR in 11 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹16,666 INR in 8 days
0.0 (0 reviews)
0.0
0.0
User Avatar
working in same in CVENT SSIS and SSRS datamart created in cvent. Working on large datasets in cvent
₹14,944 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have been creating SSRS reports for over 12 years, most of which are very complex and have complex SQL stored procedures. 8 years experience using SSIS. I also have 20 years experience as a SQL Server DBA. I would create a SQL batch job that would run every hour. Step 1 would concatenate any new data files into 1 file to be processed and archive the files. Step 2 would execute the SSIS package that loads the data file into SQL tables. Step 3 would execute the SSRS report and mail it to you. Other SSRS reports could also be written to run on request.
₹1,300 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am trained in MSBI and reporting. I will complete the task in assigned time
₹1,300 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 7+ years of experience. Areas of Expertise: • Strong command over SQL Server query. • Proficient in Microsoft BI tools (SSIS, SSRS, SSAS), SQL Server 2008 R2/2012/2014 • OLTP and OLAP concepts along with Data Warehousing.
₹1,300 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹650 INR in 4 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Mar 3, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.