I will import or export large databases to postgresql

India

I speak Kannada, Tamil, English, Portuguese, Hindi, Chinese, French, German, Spanish

1 order completed

Data Analyst Excel SQL Server PostgreSQL Expert Data Cleaning

Experienced Senior Data Analyst with a strong background in data processing, cleansing, and analytics. Passionate about leveraging data to drive business decisions, optimize marketing strategies, and ...
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


Expertise:

Migrations

Speed Optimization

Query Optimization

Platform:

MongoDB

MS Access

MS SQL

MySQL

PL/SQL

PostgreSQL

My Portfolio