The Azure Data Factory
You need an expert in Azure Data Factory or Synapse Analytics. I can’t spread my infrastructure, so I need more development of the optimal scheme and implementation in a consultation mode, or a series of consultations. I am new to Azure.
The Task:
1. in Azure Blob Storage the .csv files come in real-time mode, let's say every hour. The files have different names, and I am only interested in those that have in the "AVS" and "XYZ".
The 2nd These files should be combined in the AWS and XYZ tables, do data cleaning (delete duplicates, nans, etc.) and recorded in the SQL Database (adding to the table every time new files appear). In principle, it can be a button and not SQL, but any other, but until SQL.
3 . Data Cleaning can be either using Azure Function and the finished Python code or the Data Wrangling function in Azure Data Factory.
Thank you for your proposals!
Client's review of cooperation with Mykola P.
The Azure Data FactoryThe project was implemented in time and quality. Thank you very much for the step-by-step detailed explanations regarding the installation and setting of the program. I will be happy for further cooperation!
Freelancer's review of cooperation with Anna Ponomareva
The Azure Data FactoryEverything is well.
I recommend cooperation.
Current freelance projects in the category Desktop Apps
Need an Airtable architect to build a relational schema and a new clean Airtable base.Need help rethinking and building a clean relational schema for an internal operational system on Airtable. The current database is already in use by the team, but it has grown organically: the structure is partially flat, some tables/views are actively used, while others are… Databases & SQL, Desktop Apps ∙ 5 days 4 hours back ∙ 10 proposals |
Creation of software for generating cutting files for wooden puzzlesWe are looking for a developer to create software that automates the process of building cutting files for wooden jigsaw puzzles. Current Process Currently, each file is created manually by a designer in Adobe Illustrator. The file contains: the outer contour of the puzzle in… Desktop Apps ∙ 5 days 9 hours back ∙ 14 proposals |
Small edit on the website
16 USD
Need to update the offer agreement in the footer to a new one, the company has changed its regulations Task will take 20 minutes Web Programming, Desktop Apps ∙ 6 days 10 hours back ∙ 113 proposals |
Account reconciliation tool with the bank, cards, and accountantTechnical Assignment: Tool for Reconciling Accounts with Bank, Cards, and AccountantGeneral Goal A local tool (script/small application in Python) is needed, which is manually run once every 1-2 months on my computer and performs reconciliation between: Invoices I issued to… Python, Desktop Apps ∙ 8 days 17 hours back ∙ 44 proposals |