Design and implement SSIS (or similar) package
Budget: $25 – $50 AUD
Hi,
I am looking for a MS SQL expert to help with the design and implementation of either an SSIS package or something similar in order to move data from a bunch of customer databases (around 10) to one reporting database using incremental copy.
I have tried this with Azure Data Factory, but found it to be very expensive to run; I am looking for something I can host in an Azure VM (SQL Server SSIS?) that can perform the job of consolidating information from our customer databases into one reporting database.
This job requires good experience in:
- SQL Server Setup
- MS SQL ETL tools (i.e. SSIS)
- Reporting Services (SSRS)
- Azure Data Factory
An added bonus would someone who has experience in:
- PowerBI
- Telerik Reporting Services (or something similar)
Important: Please have demonstrable experience in the above before applying.
Thanks
I am looking for a MS SQL expert to help with the design and implementation of either an SSIS package or something similar in order to move data from a bunch of customer databases (around 10) to one reporting database using incremental copy.
I have tried this with Azure Data Factory, but found it to be very expensive to run; I am looking for something I can host in an Azure VM (SQL Server SSIS?) that can perform the job of consolidating information from our customer databases into one reporting database.
This job requires good experience in:
- SQL Server Setup
- MS SQL ETL tools (i.e. SSIS)
- Reporting Services (SSRS)
- Azure Data Factory
An added bonus would someone who has experience in:
- PowerBI
- Telerik Reporting Services (or something similar)
Important: Please have demonstrable experience in the above before applying.
Thanks
Related categories:
SQL
Report Writing
Azure
Microsoft SQL Server
SSIS (SQL Server Integration Services)