Senior Oracle PL/SQL Developer

Capgemini
Any Location, NJ
Job Description
Role Overview

The Senior Oracle PL/SQL Developer will create Oracle procedures, functions, triggers, packages, and materialized views using advanced features of Oracle 11g and 12. They will also perform ETL processing, data cleansing, data transformations, and data loading, which involves data modeling and data analytics. The role requires strong Oracle performance tuning skills and the ability to understand the flow from UI to DB.

What You Will Do

The Senior Oracle PL/SQL Developer will create complex queries to identify potential issues, automate flat file loading to Oracle using SQL Loader, and create control files for that activity. They will also work on performance tuning for existing SQL and PL/SQL objects, build optimized objects, and create Unix Shell scripts to automate batch job processing.

Why It Might Be a Fit

This role requires experience with GitHub Copilot or other Dev Assist tools and capabilities, strong Oracle performance tuning skills, and the ability to understand the flow from UI to DB. The successful candidate will be able to work on complex tasks, perform logical and physical design of databases, and develop and maintain technical specifications, data mappings, and program logic.

Requirements

  • Experience with Oracle 11g and 12
  • Advanced features of Oracle
  • ETL processing
  • Data cleansing
  • Data transformations
  • Data loading
  • Data modeling
  • Data analytics
  • Strong Oracle performance tuning skills
  • Ability to understand the flow from UI to DB
  • Experience with GitHub Copilot or other Dev Assist tools and capabilities

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