Senior Oracle Architect — Data, ETL & Performance Expert

Capgemini; Bridgewater (MA); Hybrid; USD 100,000 - 169,000; Full time

Benefits offered by this job

Healthcare including dental and vision

401(k) matching

Paid time off

Parental leave

Job summary

Capgemini is actively seeking a data-focused developer for Jersey City, NJ, with hybrid on-site work requirements. The role emphasizes Oracle database work, ETL processing, and strong collaboration across engineering, QA, and product teams.

Candidates should be skilled in SQL, PL/SQL, Python, Unix, data modeling, and performance tuning, with experience in large-scale data loading and scripting. Capgemini offers robust benefits and a PATH to advancement.

Qualifications

• 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

Responsibilities

• Explain technical designs to non-technical stakeholders.
• Develop Oracle procedures, functions, triggers, and packages.
• Lead and translate business requirements with tech teams.
• Perform ETL processing and data cleansing.
• Tune SQL/PLSQL and optimize data objects.
• Automate batch jobs with Unix scripts and SQL Loader.

Skills

Oracle

SQL/PLSQL

ETL

Python

Unix

Data modeling

Performance tuning

GitHub Copilot

Tools

Oracle 11g/12

Unix Shell

SQL Loader

Job description

Capgemini is actively seeking a data-focused developer for Jersey City, NJ, with hybrid on-site work requirements. The role emphasizes Oracle database work, ETL processing, and strong collaboration across engineering, QA, and product teams.

Candidates should be skilled in SQL, PL/SQL, Python, Unix, data modeling, and performance tuning, with experience in large-scale data loading and scripting. Capgemini offers robust benefits and a PATH to advancement.