Online delivery data operater
Budget: $15 – $25 USD
I have a collection of mixed text and numerical records stored across several online databases. Every field from those sources must be captured accurately and inserted into my SQL-based system.
The job involves:
• Extracting the full record set directly from the online platforms.
• Mapping each text and number field to the correct columns in my existing tables.
• Importing the data through SQL scripts or bulk-load tools, keeping key/value integrity intact.
• Spot-checking for duplicates or obvious errors and flagging anything that looks inconsistent.
Deliverables will be:
1. A fully populated SQL database (MySQL or PostgreSQL are both acceptable) matching the structure I provide.
2. A brief validation report confirming record counts, any skipped entries, and issues resolved.
Accuracy is more important than speed, but I would like the initial load completed within one week once access is granted. Familiarity with SQL commands, bulk inserts, and basic data-cleaning techniques is expected.
The job involves:
• Extracting the full record set directly from the online platforms.
• Mapping each text and number field to the correct columns in my existing tables.
• Importing the data through SQL scripts or bulk-load tools, keeping key/value integrity intact.
• Spot-checking for duplicates or obvious errors and flagging anything that looks inconsistent.
Deliverables will be:
1. A fully populated SQL database (MySQL or PostgreSQL are both acceptable) matching the structure I provide.
2. A brief validation report confirming record counts, any skipped entries, and issues resolved.
Accuracy is more important than speed, but I would like the initial load completed within one week once access is granted. Familiarity with SQL commands, bulk inserts, and basic data-cleaning techniques is expected.
Related categories:
Data Processing
Data Entry
SQL
MySQL
Database Administration
PostgreSQL
Database Programming
Data Management