Oracle PL/SQL Developer

Capgemini • New York, NY

3d • Hybrid

About The Position

We are seeking a skilled Oracle PL/SQL Developer to design, build, and optimize high‑performance data processing and integration solutions. The ideal candidate will have strong expertise in PL/SQL development, SQL performance tuning, and large‑scale data processing, and will work closely with cross‑functional stakeholders to support modernization and data-driven initiatives.

Requirements

• Strong hands-on experience in Oracle PL/SQL development and advanced SQL scripting
• Demonstrated ability to write optimized, scalable, and maintainable PL/SQL code
• Proven expertise in SQL performance tuning and query optimization
• Experience implementing exception handling, logging, and fault-tolerant mechanisms
• Solid understanding of data transformation, ETL processing, and batch workflows
• Experience working with large data volumes and high‑throughput systems
• Good understanding of data modeling concepts (OLTP, Data Warehouse, Data Marts)
• Strong analytical, troubleshooting, and problem‑solving skills

Nice To Haves

• Experience with ETL tools such as Informatica or modern data platforms like Snowflake
• Exposure to Python, Java, or API‑based system integrations
• Familiarity with cloud platforms such as AWS or Azure
• Experience with job orchestration tools (e.g., Control‑M, Airflow)
• Understanding of DevOps practices, including CI/CD, Git, Jenkins, and Docker
• Experience working in Agile delivery environments (Scrum/Kanban)

Responsibilities

• Develop, maintain, and enhance Oracle PL/SQL packages, procedures, and functions for enterprise data processing
• Implement robust data transformation, aggregation, and validation logic
• Design and implement error handling, logging, and exception management frameworks
• Optimize complex SQL queries and PL/SQL code for performance, scalability, and reliability
• Build and support batch data processing pipelines and data integration workflows with internal and external systems
• Analyze and support redesign or modernization of existing systems and data flows
• Work with large datasets in performance‑critical environments
• Collaborate with business and technical stakeholders to gather requirements and deliver effective solutions
• Support testing, troubleshooting, issue resolution, and production stability
• Ensure compliance with data quality, security, and governance standards

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed