Job Description :
Title: Data Migration Specialist
Duration: 12 Months
Location: Raleigh, NC
Job Description:
The Data Migration Specialist will be responsible for data extraction, data consolidation, data cleansing, data transformation, creating harmonized database for loading into new Legal Case Management System.
The North Carolina Industrial Commission (NCIC) is implementing an integrated Legal Case Management System (LCMS) solution to consolidate and replace multiple existing legacy mainframe and client-server applications.
The Data Migration Specialist will work closely with business and technical team that supports legacy mainframe and client-server application and the LCMS vendor technical resources. The Data Migration Specialist will be responsible and accountable for data extraction, data consolidation, data cleansing, data transformation, creating harmonized database for loading into LCMS, extracting cleansed data from harmonized database in the format requested by LCMS vendor. The Specialist will also assist in data migration and testing of data migration, unit test, load test, mock trial conversion and production conversion. The consultant should have at least the following skills.
The consultant will play a key role in data cleansing and migration from legacy system using ETL design, data modeling, and ETL development.
Research and analyze current systems, subsystems and interfaces to understand the current process flows
Able to understand existing data objects and their relationships, recognize data duplication and redundancies in disparate applications and design new data model that consolidates all data from disparate applications into single source of truth
Gain team and stakeholder approval for all designs, and effort estimates
Document to-be-design using ERD tools.
Develop unit tests and validation tests.
Codes, tests, debugs, implements, and document programs.
Creates technical documentation for scripts and programs.
Skill
Required / Desired
Amount
of Experience
Total experience in Information Technology field
Required
7
Years
Experience with Oracle database version 12.1.0 or higher
Required
3
Years
Experience in writing complex queries, stored procedures in PL/SQL, query optimization, and scripts
Required
3
Years
Experience extracting data from Oracle databases
Required
3
Years
Experience in data validation, verification, and cleansing using PL/SQL Scripts
Required
5
Years
Experience understanding existing entity relationship diagrams (ERD) & creating new ones
Required
3
Years
Experience in high data volume data conversion environments
Required
3
Years
Background with RDBMS and coding
Required
5
Years
Experience creating shell script in a UNIX/LINUX environment
Required
3
Years
Experience with Data migration using scripts
Required
3
Years
Bachelor's degree in Computer Science or related field preferred
Desired
4
Years
Experience developing logical and physical data models
Desired
5
Years
Experience extracting data from Oracle databases
Desired
5
Years
Experience working within a development environment and with common tools such as code repositories and group collaboration applications
Desired
5
Years
Experience handling HIPPA and PII data
Desired
1
Years
if interest Please provide me below information:
· Full Name:
· Email ID:
· Contact:
· Address:
· Availability:
· Passport No :
· Last 4 digit SSNO:
· Availability for Interview:
· Visa Status:
· Visa Expiry date (MM/DD/YYYY):
· Relocation:
· Rate:
· LinkedIn ID :
Professional Reference :1
· Full Name :
· Company Name :
· Title :
· Telephone :
· Email id :
Professional Reference :2
· Full Name :
· Company Name :
· Title :
· Telephone :
· Email id :