Find Jobs
Hire Freelancers

Data Merger/Consolidation

$15-25 AUD / hour

Cancelled
Posted over 9 years ago

$15-25 AUD / hour

Need an experienced professional who is experienced with ETL processes, data extraction and data merging. We have several (approx. 100) MySQL databases that required to be merged into a single database. Both the source and the target all have exactly same schemas (37 tables in the schema) and all are located on the same database server instance. Full schema documentation with sample data will be provided as part of the project kickoff. The ETL script must be provided such that a list of source and single target database can be specified in a configuration file. The ETL script can assume that all databases are located on the same server. I need a person to work on this ASAP. Please do not bid for this project unless you are able to start working on this within the next 5 days.
Project ID: 6181129

About the project

14 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $21 AUD/hour for this job
User Avatar
Hi, Let me introduce myself as an expert in Database design and analysis. I have worked on several database technologies like MS Access , SQL Server, Oracle,MySQL etc. I have more than 10 years of experience to my credit. I have worked data merging and consolidation in the past as well. I am assuming that it is plain merging and there are no data conflicts that need to be resolved as per some business rule. On this highly competitive site I fully understand how important it is to provide high quality work. My prime focus is 100% customer satisfaction. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder
$15 AUD in 3 days
5.0 (119 reviews)
5.9
5.9
User Avatar
Hi, Waiting for the schema document and sample data, i am confident to help you. Looking forward to hear back from you. Magjoom
$27 AUD in 12 days
4.9 (10 reviews)
5.4
5.4
User Avatar
Hello i can develop an application / script to merge the databases (MySQL) into a single database Available immediately and for full-time work from home Best regards vnb400
$22 AUD in 3 days
4.8 (92 reviews)
5.5
5.5
User Avatar
A proposal has not yet been provided
$20 AUD in 3 days
5.0 (3 reviews)
4.9
4.9
User Avatar
Aucune proposition n'a encore été fournie.
$25 AUD in 3 days
4.6 (38 reviews)
5.5
5.5
User Avatar
Hi, this is Irfan. I have over 6 years experience in web/database development. I have worked on huge databases and done relevant job according to your requirements. Let me know. Thanks, Irfan
$16 AUD in 12 days
5.0 (8 reviews)
4.1
4.1
User Avatar
I have the required skills and expertise to do work on your this project according to the given requirements. I have done work on several projects related to file handling and database systems. Consider me for your this project. I will be waiting for your reply...
$23 AUD in 20 days
5.0 (13 reviews)
4.1
4.1
User Avatar
Hi, I am a MySQL database programmer and have worked with large databases. From what I am reading you need an ETL tool (script) which will merge data from different sources (having the same schema) into one central (or control) database. Some of the problems I can visualize is the presence of duplicate data - in what ways can they occur and if they do which database source would you keep and which will you reject. Please provide more details of the work so that I can review the schema and the associated PKs and FKs. If you can provide test data even better. Any questions, do let me know. Thanks Deb
$20 AUD in 15 days
4.5 (4 reviews)
3.5
3.5
User Avatar
I am having good exposure of ETL and databases. I have designed and maintained a complete ETL tool using UNIX shell script and Oracle (SQL, PL/SQL). We can have discussion if you are interested.
$22 AUD in 3 days
5.0 (2 reviews)
1.1
1.1
User Avatar
hi, interested in your project,the work will be done with accuracy and within time.........done similar work in the past using sas,sql....eagerly waiting for your response. Thank you
$22 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Depends on the RelationShips, If the tables have no relationships, the it would be as simple as creating the new table and insert all the rows in the tables
$22 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am working on same project. I have great knowledge about the same. I have done more then 3-4 end to end implementation. I can start working from today.
$22 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Need to discuss in detail before providing proper estimate. Working for last 13 years in DW/BI and database. Worked on multiple system level migration and aggregation. DB Technologies- MS SQL Server, MySQL, Postgres, Oracle
$23 AUD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Dec 8, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.