IMPORTANT NOTE: We hire freelancers many times a day. We are ramping up for MANY new projects and looking to get some fresh people into our talent pool. There is a lot more work for you if you do a great job. A LOT MORE.
We are very comfortable working with individuals in India, Pakistan, Eastern Europe, Asia/Pacific, Central and South America, and so forth. We have project managers on staff who speak Russian and Spanish.
***IMPORTANT: Your Bid
We have a large range for this project to accommodate bids from the US and overseas. Bid's amounts should be appropriate for where you live. We employ full time contractors in many countries and know what the proper bid for this project should be from all major outsource markets. If you do not do this your bid will NOT be selected. We are always happy to pay fairly in each freelancer's local market, but do not overpay.
Project Details
***Due Date: 3-5 days
***Job Description
Here is the scenario:
Data Group Number 1
We have databases from multiple companies.
These companies all sell the same products.
These databases are raw dumps from their systems, but they include a code number for each product that is unique across all companies.
Aside from that number how they refer to these products, including their names and characteristics may be very different.
There are different product quantities for each product, with varying prices at each product quantity level.
There are around 5000 products in the databases.
Data Group Number 2
We have a database that overlaps with the above databases but that doesn't include the unique identifier for each product.
This database has around 2500 products in it.
Data Group Number 3
We have a database that has the identifier and has some standardized data about each product.
A small number of products needed will not be in this system and will need to be created by you as records in the database, based on what you find in the other two datasets.
What we need:
We need you to construct a query that ties everything together accurately.
A.)
For starters, we should be able to query/say:
Give us the price for product Y based on characteristic 1, 2, and 3 (ie - quantity)
The system should return the price from all of the above databases side by side for comparison.
B.)
We will use the above to figure out which mix of products and quantities/characteristics we need.
C.)
Then, you will modify your query to:
1. Return a list of products matching quantity (and other characteristics) we finalize.
2. Match the list to the equivalent from Group 2
3. Match the list to the equivalent from Group 3
The end result will be something that our web programmer can call with query parameters and get data returned to. Essentially comparison data that displays in a short list for the queried product.
Additional Notes:
This is complicated data. Three days may sound like a long time to do something like this, but it isn't for this job because of the data complexity and the difficulty we expect you to have in matching everything up.
Some data will be wrong, expect some messy data. So your query should also have validation measures that look across the relevant comparison data for products (in the different database) and attempts to spot quantity errors, pricing errors, and so forth.
***
The job will be considered final when you have returned the working final query that our programmers can use, and we have verified that the results it is returning are valid.
Remember that this data will be messy and some of it will need to be cleaned up during the query process so that incorrect records are not returned. We will not pay for a result that does not do this accurately.
***Technologies
All databases are hosted in SQL Server 2008.
We use .NET and MVC3.
PLEASE SEE ATTACHED FILE FOR FULL DESCRIPTION. FREELANCER'S PROJECT DESCRIPTION BOX IS NEVER LARGE ENOUGH FOR US!!!
About us
We are an established consulting firm with extensive outsourcing experience.