Jr. Oracle Developer

Cygnus Professionals

Date: 2 weeks ago
City: Trenton, NJ
Contract type: Full time
Cygnus Professionals
Job Description

***** This is a Hybrid position requiring work ONSITE 2 Days / Wk for at least the first 2-3 months from the start. There may be some flexibility later in the project. This is Non-Negotiable.****

Job Description:

The Jr. Oracle Developer will be responsible for Creating Load Jobs, Aggregations and Views for the Information Architecture Strategy/ Departmental Data Lake project as well as supporting the Senior Oracle developer. This project is looking at the multiple data sources in the client and bringing them in to a single repository.

Duties and Responsibilities:

Review Logical and Physical Data Models

Support Reconciliation Procedure design

Build Replica tables for Salesforce and Mainframe data

Create Aggregation Jobs

Create Reconciliation Procedures

Create Threshold Validation Procedures

Integration testing


Document ETLs

Documentation for Procedures

User Acceptance Testing

Knowledge and Experience:

Oracle – 6 years

Database design – 6 years

SDLC – 5 years

Salesforce – 2 years

Required Skills:

Oracle– 6 years

Data Modelling – 6 years

SQL – 6 years

Oracle View creation – 3 years

Create and testing Join conditions – 5 years

ETLs – 6 years

Desired Skills:

Excellent verbal and written skills, with the ability to communicate with both technical and program area staff – 5 years

Education: Bachelor’s Degree or equivalent certification

Required Skills:


Data Modeling


Oracle View Creation

Create and testing join conditions


Experience communicating with both technical and program area staff

Experience reading data from Salesforce

Bachelor’s Degree or equivalent certification

How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume