ASP.NET Hand-Coded ETL

This project received 32 bids from talented freelancers with an average bid price of $1831 USD.

Get free quotes for a project like this
Employer working
Project Budget
$750 - $1500 USD
Total Bids
Project Description

[url removed, login to view] Hand-Coded ETL

The project consists on the implementation of a .NET solution in which users upload documents (txt, csv and xlsx) with a pre-defined structure. Uploaded data must be loaded through a mini hand coded ETL process to populate a fact table hosted in SQL Azure.

There are 15 different files with closely similar structures containing data of products being sold in different stores. Files are uploaded by the users generally on a weekly basis.

Each file has many columns but only 5 columns contains valuable data that must be loaded DIRECTLY into an SQL Azure Table, which is a fact table used for reporting.

Files must be securely stored and deleted after migration is completed.

A cross check of missing products must be created for data loaded into the DB. If a new product code is found on the uploaded file, this row of new information must be added into the product table.

A form is required to complete information about the missing product. JQuery must be used to create an autocomplete so population of the information is eased using data located in the product table from the SQL Azure Database.

This [url removed, login to view] solution needs to be developed in Visual Basic.

Users must be able to Sign-up/Login through a secure protocol.

This project has a big growth potential for future developments.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online