Oracle Architect

Capgemini•Bridgewater, NJ

1d•$99,712 - $168,716•Hybrid

About The Position

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

Requirements

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

Demonstrated experience in communicating technical designs and capabilities to non-technical team members, product owners, and partners
Strong leading capabilities along with the coding skills - understand the business requirements and be able to translate and work with other tech team members including QA team
Code reviews and identify the edge cases and give solutions to them
Work on performance tuning for existing SQL, PL/SQL Objects and also build optimized objects.

Responsibilities

Demonstrated experience in communicating technical designs and capabilities to non-technical team members, product owners, and partners
Create Oracle Procedures, functions, triggers, packages, materialized view, views using advanced features of Oracle 11g, 12
Strong leading capabilities along with the coding skills - understand the business requirements and be able to translate and work with other tech team members including QA team
Code reviews and identify the edge cases and give solutions to them
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, PL/SQL 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
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

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
Vacation: 12-25 days, depending on grade
Company paid holidays
Personal Days
Sick Leave
Medical, dental, and vision coverage
Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
Life and disability insurance
Employee assistance programs