Capgemini

Oracle Architect

Capgemini$99K — $168K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5-7 years of experience in Oracle database development and ETL processing
  • Strong coding skills in PL/SQL and Python for data processing and analysis
  • Proven ability to communicate complex technical designs to non-technical stakeholders
  • Experience in performance tuning of Oracle databases and SQL queries
  • Familiarity with Unix scripting for automation and job processing
  • Understanding of data modeling and database design principles
  • Knowledge of version control systems, particularly GitHub Copilot or similar tools

Responsibilities

  • Communicate technical designs to non-technical team members effectively
  • Develop Oracle database procedures, functions, and triggers using advanced features
  • Lead technical discussions and collaborate with QA and tech teams to meet business requirements
  • Conduct code reviews to identify edge cases and provide solutions
  • Perform ETL processes using Python, Oracle, and Unix for large data sets
  • Optimize SQL and PL/SQL objects for performance improvements
  • Automate batch job processing through complex Unix Shell scripts

Benefits

  • Flexible work arrangements
  • Comprehensive healthcare including mental health programs
  • Financial well-being programs like 401(k) and employee share ownership
  • Generous paid time off and holidays
  • Paid parental leave and family building benefits
  • Support for childcare and eldercare through subsidized services
  • Access to mentoring and continuous learning programs
  • Participation in employee resource groups and community initiatives
  • Disaster relief programs
Full Job Description
Job Location - Jersey City NJ (Day One Onsite - Hybrid)

Key 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


Life At Capgemini

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
  • 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


Salary Transparency

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 effe

Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $99712 to $168716 /yearly.
This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.
Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company's sole discretion, consistent with the law.

ctively to drive business outcomes.

The base compensation range for this role in the posted location is:$99712 to $168716

Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.

The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.

These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.

It is not typical for candidates to be hired at or near the top of the posted compensation range.

In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.

Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:
  • Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave
  • Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)
  • Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)
  • Life and disability insurance
  • Employee assistance programs
  • Other benefits as provided by local policy and eligibility

Important Notice: Compensation (including bonuses, commissions, or other forms of incentive pay) is not considered earned, vested, or payable until it becomes due under the terms of applicable plans or agreements and is subject to Capgemini's discretion, consistent with applicable laws. The Company reserves the right to amend or withdraw compensation programs at any time, within the limits of applicable legislation.

About Capgemini

Capgemini is a global leader in consulting, digital transformation, technology and engineering services. The company is headquartered in Paris, France and operates in over 50 countries. Capgemini provides a range of services including strategy and transformation, application services, technology services, and engineering services. The company serves clients in a variety of industries including automotive, consumer products, financial services, healthcare, and retail.
Learn more about Capgemini
Industry
Founded
1967
NASDAQ

Similar Jobs

  • Capgemini
    Oracle Architect
    $99K — $168K *
    Capgemini
    Bridgewater, NJ 08807 (Somerset County)
  • Virtusa Corporation
    Architect
    $120K — $145K *
    Virtusa Corporation
    New York, NY 10025 (New York County)
  • Database Architect
    $110K — $130K *
    i-Link Solutions, Inc.
    Albany, NY 12203 (Albany County)
  • First Citizens Bank
    Database Engineer Consultant
    $120K — $145K *
    First Citizens Bank
    Florida, NY 10921 (Orange County)
  • IQVIA
    SQL Server Architect
    $75K — $188K *
    IQVIA
    Greenwich, CT 06830 (Western Ct County)
  • AWS Database Architect
    $120K — $150K *
    Cardinal Integrated Technologies, Inc.
    Paramus, NJ 07652 (Bergen County)

More Jobs at Capgemini

More Information Technology Jobs

Find similar Oracle Architect jobs: