Remote Network And System Administration Job In IT And Networking

Azure Data Factory (FTP to SQL)

Find more Network And System Administration remote jobs posted recently Worldwide

I have a basic Azure SQL Server and DB setup that I am trying to get some data into. I am unfamiliar with Azure DF I am Analytics and BI.

I have a FTP site that at 7am ish I get a zip file that contains a text file with data from our restaurants with data on specific guest count data. The file is a rolling 7 days. I would like this file extracted and the table to be updated with the new data. This includes any data that has changed in the last 6 days and the new data from the day before.

We are slowly moving more in Azure and a small Elastic Pool of SQL Dbs. This project is the first step in getting our non SQL information into the system and I would also like to have talks about API to SQL DBs via Azure DF as well.

Please reach out to discuss the scope of work and roadmap of future work to see if this is the right fit for both of us
About the recuiter
Member since Nov 11, 2022
Reghu Shanker
from Oio, Guinea-Bissau

Skills & Expertise Required

Extract, Transform and Load sql SQL Server Integration Services (SSIS) T-SQL Microsoft Windows Azure

Open for hiringApply before - Jul 17, 2024

Work from Anywhere

40 hrs / week

Hourly Type

Remote Job

$19.17

Cost

Offer to work on this project closes in 14 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

Interior Designer, Kitchen & Bath - Hourly
2D Animators Needed - Fixed
Need embedded systems engineer for designing schematic and PCB from a prototype. - Fixed
Microsoft Licensing Expert needed to create a whitepaper on OEM and FPP licensing - Hourly
Python Mobile Application AI - Fixed
Facebook Business Locations Guru - Fixed
we already have a token based appointment system for multi doctor and am looking for a update. - Fixed
Data Analytics - Hourly
JavaScript in .xod document - Fixed
Network Engineer familiar with WISP networks, assist with VoIP problems - Fixed
Hired for the Wrong Job - Stressful (Help!) - Hourly
Demand of JavaScript + AngularJS Developer - Hourly
Expert in Administration AWS - Hourly
Princess Tatenda - Hourly

Similar Projects

php based application

Looking to hire someone to build a custom web based application that will do the following:

-Formatted into template
-Print ready from said template
-Re-Editable fields, easly clearable

So this is what is trying to be accomp...read more

Azure Dev Ops Consultant

Help implement Azure Dev Ops for
1. Project Management - Azure Boards
2. Source Control - Azure Repos
3. Build and Deploy - Azure Pipelines CI/CD

Python SQL debugging

Im looking for someone to help me with python and SQL. If you know PySpark, that is a plus. This would be in person somewhere in the Des Moines area. A couple of hours a week.

R Developer

Im a data scientist and Im looking for an R developer (not an analyst or statistician).

You can write clear and efficient R code, you have experience with the tidyverse (primarily dplyr and purrr), and you know your way around relational d...read more

Help me create simple azure network

Im a novice with azure, but Im trying to salvage a simple network with two basic virtual machines that I can use to test some business processes on So far, the virtual machines I create show up in Chinese! Id like your help in creating this simple...read more