Oracle Architect

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)

• 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 Git Hub 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

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

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.

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…