Oracle Developer

Company: Crescens Inc.
Location: Trenton
Posted on: January 25, 2023

Job Description:

Job Title: Oracle Developer
Location: Trenton, NJ (Hybrid)
Duration: 12+ months

"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.

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 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
        
        

Keywords: Crescens Inc., Trenton , Oracle Developer, IT / Software / Systems , Trenton, New Jersey