• US Citizen

• Green Card

• Corp-Corp

• W2-Contract

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 9th Nov 2022

Job DescriptionThe 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.

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 Department of Labor 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/Desired Skills

 SkillRequired /DesiredAmountof ExperienceOracleRequired6YearsData ModelingRequired6YearsSQLRequired6YearsOracle View CreationRequired3YearsCreate and testing join conditionsRequired5YearsETLSRequired6YearsExcellent verbal and written skills, with the ability to communicate with both technical and program area staffRequired5YearsSalesforceRequired2YearsBachelor's Degree or equivalent certificationRequired4Years