Job ID: NC-593330 (96190522)
Oracle Developer with PL/SQL, ERD, shell script, Data migration, HIPPA and PII data experience
Location: Dobbs Building, 430 N Salisbury St, Raleigh, NC 27603 (NCDIT)
Duration: 12 months
Interview: In Person
Positions: 1 (1/2)
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
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.