Jr. Oracle Developer

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



Training



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:

Oracle



Data Modeling



SQL



Oracle View Creation



Create and testing join conditions



ETLS



Experience communicating with both technical and program area staff



Experience reading data from Salesforce



Bachelor’s Degree or equivalent certification