Home

Hiring Data Migration Specialist-Irving, TX (can start remote and relocate in future) at Irving, Texas, USA
Email: [email protected]
Job Role: Data Migration Specialist

Location - Irving, TX (can start remote and relocate in future)

Job Description:

Oracle and PostgreSQL Database:
Creation of Views, Materialized views and wrote PL/SQL Procedures, Functions, Triggers and Packages in Oracle Database.
Development of highly complex yet optimized and performance-oriented queries to extract data from PostgreSQL to Flat Files.
Performance tuning of very complex queries which includes joins and aggregate functions.
SQL Query development which requires a good understanding of PostgreSQL JSON/JSONB processing functions and SQL Query development on JSON/JSONB data structures.

Data Analysis:
Work on Source Data Analysis and creation of Data Mappings for Extraction of bulk data from various sources.
Implement the data formulation process which included identification of attributes, exploratory data analysis, data transformation, and temporal layout.

ETL:
Develop Solutions for business include the Extraction, Transformation, and Loading of Data between systems (ETL Process).
Develop ETL Jobs using Talend which will load data from Stage Environment to Landing Environment. Staging Area in Oracle (Source Database) to corresponding tables in PostgreSQL (Target Database).
Analyse and resolve the ETL and migration issues as a part of UAT, Regression testing and Production issue resolution.
Perform a spectrum of ETL activities according to clients needs and specifications.
Manage and implement the data extraction and data importing procedure to ensure Data Migration integrity and quality.
Work in Unix/Linux environment to perform the Data Migration.

Thanks & Regards,

Vamshi Karam

MARVEL InfoTech, Inc.

Direct: 732-714-5522 

Desk: 732-714-5522  Ext-118

Email:-
[email protected]

www.marvelinfotech.com

MBE NMSDC NYNJ

--

Keywords: information technology procedural language Texas
[email protected]
View all
Fri Jan 12 02:23:00 UTC 2024

To remove this job post send "job_kill 1008805" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 11

Location: Irving, Texas