Junior Oracle PL/SQL Developer

Capgemini • Bridgewater, NJ

3d • $56,186 - $87,556 • Hybrid

About The Position

The primary focus is to help organizations design, develop, and optimize their data infrastructure and systems. They help organizations enhance data processes, and leverage data effectively to drive business outcomes. For this role, the gross annual base salary range is $56186 to $87556 for a full-time position. This range covers base pay only; we will discuss any bonuses, incentives, and benefits during the hiring process. Your exact offer will depend on objective, job-related factors – like your experience, skills, and qualifications – in line with our fair pay principles. If a collective labour agreement applies to this role, we will share the relevant pay scale details with you. Note: We never ask about your current or past salary during our recruitment process.

Requirements

• Experience with GitHub Copilot or other Dev Assist tools and capabilities
• Strong Oracle performance tuning skills
• Able to understand the flow end to end from UI to DB

Nice To Haves

• Also able to do QA for some tasks

Responsibilities

• Create Oracle Procedures functions triggers packages materialized view views using advanced features of Oracle 11g 12
• ETL Processing with Python Oracle Unix Batch ETL and Real Time Stream Processing
• Loading huge data sets from multiple vendors and performing data cleansing data transformations data loading which involves data modeling and data analytics
• Work on performance tuning for existing SQL PLSQL Objects and also build optimized objects
• Create complex Unix Shell scripts to automate the batch job processing create reports on realtime daily weekly basis
• Perform logical and physical Design of database Data Modeling and Design Specifications to analyze dependencies and perform risk analysis
• Develop and maintain Technical specifications data mappings program logic and flowchart for all the change requests that are performed
• Write complex queries to identify the potential issues while interfaces fail and re mediate them
• Automate flat file loading to Oracle using SQL Loader and create control files for that activity

Benefits

• Flexible work
• Healthcare including dental, vision, mental health, and well-being programs
• Financial well-being programs such as 401(k) and Employee Share Ownership Plan
• Paid time off and paid holidays
• Paid parental leave
• Family building benefits like adoption assistance, surrogacy, and cryopreservation
• Social well-being benefits like subsidized back-up child/elder care and tutoring
• Mentoring, coaching and learning programs
• Employee Resource Groups
• Disaster Relief

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: No Education Listed