Data Warehouse Developer with Oracle Warehouse Builder or Oracle Data Integrator experience, Oracle Utilities, Mainframe, data conversion, and PL/SQL experience

IN001308

Data Warehouse Developer with Oracle Warehouse Builder or Oracle Data Integrator experience, Oracle Utilities, Mainframe, data conversion, and PL/SQL experience

Location: 

Raleigh, NC

Duration:

1 year

Positions:

2

The NC Department of Health and Human Services seeks a contract resource (approx. 12 month) to assist with analysis, definition, documentation, and execution of data migrations for NC Families Accessing Services through Technology (NC FAST). The selected candidate will have significant responsibilities as part of NC FAST development and work closely with Senior Technical Consultants on data conversion design and development issues, and may act in the role of senior technical developer. Duties include but are not limited to: 

•       Leading requirement gathering sessions

•

Conducting planning sessions with client for data migration

•

Developing requirements

•

Recommend data cleansing strategies

•

Designing new programs and using existing tools necessary to extract data from source systems

•

Transform data into target structures and load data into a relational database

•

Develop conversion output analysis strategies

•

Writing specifications

•

Writing test plans

•

Conducting testing as required to accomplish the conversion of legacy system data to NC FAST as well as reporting statuses to the NC FAST Project Manager

•

Adhering to DHHS policies and procedures.

These activities will involve:

•

Analyzing and modifying existing programs

•

Debugging programs, and assisting with evaluating data conversion results

•

Identifying performance issues

•

Developing alternate solutions to resolve issues by conducting system assessment and performance monitoring in order to identify and correct avoidable conversion problems

 

Required:

* A high degree of business and technical knowledge, which may include but is not limited to, programming and designing large scale web based distributed systems using Oracle Utilities, or SQL/PLSQL

* Experience with ETL tools such as Oracle Warehouse Builder or Oracle Data Integrator

* Experience reviewing, coordinating and overseeing all technical evaluations, technical project timelines and estimates.

Preferred:

* Legacy data conversion into a Curam data model.

Posted via email from innoSoul's posterous