Browse categories
Explore
Fiverr Pro
English
$
USD
I will do etl scripting using any db source to sql server oracle or postgres
I have expetise in sql server, oracle, Postgres,plus ETL scripting
Having 15 years of experience in database development. Work in renowned software houses. I can develop your database side objects (schema,procedures,functions,packages). Successfully delivered data mi...
About this Gig
I have expertise in data migration from any relational or non relational (file base, csv) data sources to relational database like sql server or oracle. I have migrated live data of, both Medical (USA) and leasing domains (Nissan Mexico, Toyota Leasing Thailand) domains.
In case of leasing domain i have migrated data around 8GB which is equivalent of 10 years.
I will use below steps while completing your ETL operation.
1. Analysis of source and target database schema's.
2. Mapping of fields
3. Identification of business rules.
4. Creation of staging DB.
5. Creation of migration routines using SQL scripting.
6. Data cleansing.
7. Creation of Target database, with out constraints
8. Execution of routines.
9. Enabling of constraints.
10 Verification of migrated data with source data, with the help of verification reports.
In case of leasing domain i have migrated data around 8GB which is equivalent of 10 years.
I will use below steps while completing your ETL operation.
1. Analysis of source and target database schema's.
2. Mapping of fields
3. Identification of business rules.
4. Creation of staging DB.
5. Creation of migration routines using SQL scripting.
6. Data cleansing.
7. Creation of Target database, with out constraints
8. Execution of routines.
9. Enabling of constraints.
10 Verification of migrated data with source data, with the help of verification reports.
Platform:
MS SQL
•
Oracle
•
PL/SQL
•
SQL Server
Expertise:
SQL
•
DML
•
Performance
•
Query optimization
