Senior Oracle PL/SQL Developer

About the role

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world. Job Location: Jersey City, NJ (Day One Onsite – Hybrid).

Responsibilities

• Create Oracle procedures, functions, triggers, packages, materialized views, and views using advanced features of Oracle 11g/12.
• Perform ETL processing with Python, Oracle Unix batch ETL, and real‑time stream processing.
• Perform QA for assigned tasks.
• Load huge data sets from multiple vendors; conduct data cleansing, transformation, and loading involving data modeling and analytics.
• Tune performance of existing SQL/PLSQL objects and build optimized objects.
• Create complex Unix shell scripts to automate batch job processing and generate real‑time daily, weekly, and monthly reports.
• Perform logical and physical database design; develop data modeling and design specifications to analyze dependencies and conduct risk analysis.
• Develop and maintain technical specifications, data mappings, program logic, and flowcharts for all change requests.
• Write complex queries to identify interface failures and remediate issues.
• Automate flat‑file loading to Oracle using SQL*Loader and