I will import or export large databases to postgresql
India
1 order completed
Data Analyst Excel SQL Server PostgreSQL Expert Data Cleaning
About this Gig
What I Offer:
Import/Export Large Databases to PostgreSQL
Smoothly handle large files without data loss or corruption.
Split Large Databases into Chunks
Prepare data for email verification by breaking large datasets into manageable files.
Merge Databases with Different Schemas
Unify multiple databases (even with different structures) into one clean, consistent format.
Advanced String and Regex Checks
Fix messy data with intelligent string operations and pattern matching.
Data Cleansing & Enrichment:
Contact Name:
Split full names into First Name and Last Name.
Job Title:
Automatically assign Seniority Level and Department using title-based logic.
Address:
Merge or split address into Street, City, State, ZIP Code, and Country.
Phone Numbers:
Validate numbers against country codes for accuracy.
Employee Size Cleansing (Apollo Standard):
Annual Revenue Normalization (Apollo Standard)
Map raw revenue numbers to standardized revenue ranges.
Website Cleansing
Remove tracking parameters, fix broken URLs, and more.
Email Quality Check
- Match email structure to contact names
- Detect ISPs (e.g., Gmail, Outlook)
- Flag generic or invalid emails
