Junior 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, views using advanced features of Oracle 11g/12.
• ETL Processing with Python, Oracle Unix Batch ETL and Real Time Stream Processing.
• Able to do QA for some tasks.
• 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 real‑time, 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 remediate them.
• Automate flat file loading to Oracle using SQL Loader and create control files for that activity.
• 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.