Hybrid Oracle PL/SQL Developer — ETL & Automation

Capgemini; Bridgewater (MA); Hybrid; USD 56,000 - 88,000; Full time

Benefits offered by this job

Flexible work

Healthcare

401(k)

Paid time off

Job summary

Capgemini in Jersey City, NJ (Day One Onsite - Hybrid) is seeking a database and ETL specialist adept at Oracle technologies. You will develop procedures, functions, and packages, and lead ETL processing using Python and Unix batch jobs.

You will optimize performance, load data from multiple vendors, and automate batch processes while ensuring data quality and timely reporting for business insights. Knowledge of SQL Loader, SQL, and PL/SQL, plus experience with GitHub Copilot for development

Qualifications

• Experience with Oracle performance tuning and data integration.
• Experience loading data via SQL Loader and ETL processes.
• Ability to create Unix shell scripts for batch jobs.
• Strong understanding of data modeling and data quality.

Responsibilities

• Develop Oracle procedures, functions, and packages.
• Perform ETL processing and data cleansing for large datasets.
• Tune SQL/PLSQL performance for existing objects.
• Automate batch jobs with Unix shell scripts and create real-time reports.
• Design logical/physical data models and specs.

Skills

Oracle

PL/SQL

SQL

ETL

Unix Shell

Python

Tools

GitHub Copilot

SQL Loader

Job description

Capgemini in Jersey City, NJ (Day One Onsite - Hybrid) is seeking a database and ETL specialist adept at Oracle technologies. You will develop procedures, functions, and packages, and lead ETL processing using Python and Unix batch jobs.

You will optimize performance, load data from multiple vendors, and automate batch processes while ensuring data quality and timely reporting for business insights. Knowledge of SQL Loader, SQL, and PL/SQL, plus experience with GitHub Copilot for development