I am looking for a long term relationship with an integration developer that can jump-start integrations for me. The developer will use the following for now:
1) Node-Red for running the integrations to Rest-API interfaces that will acquire data
2) Put the data into Staging Tables for processing in SQL Server, following a staging format I define.
3) Added Bonus, if they are fluent in SQL Server Stored Procedures, will craft the SP to post-process the data to put the data from the staging table into the final BI resting place.
4)Added Bonus, if they can craft queries for me, in a format I will define, to pull the data out for aggregation
5)Added Bonus, if they are familiar with R or Python to assist in writing Machine Learning queries against SQL Server to help find anomalies and patterns.
This first project will turn into a series of small projects. Each one paid for upon completion. As stated, to start we will extract data, via a Rest API into SQL Server Staging Table via Node-Red. And as the Bonus value, convert the staging data into the final data tables. You must have access to Node-Red (it is free), preferable running on Ubuntu but Windows is also OK). You must have access to SQL Server 2017 or higher. SQL Server must be running on Windows for current projects. The first project will be accessing Microsoft Office 365 Graph Data API and/or Azure API.
2 freelanceria on tarjonnut keskimäärin 209$ tähän työhön
Hi, I read your project details and interested in long-term relationship. I'm expert in MS Sql server Store procedures and queries. I also have experience to in ETL data transfer from different stages. Kind regards