Oracle PL/SQL Developer

Capgemini - New York, NY

Full-time - Mid Level

New York, NY

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The Oracle PLSQL Database Developer role at Capgemini involves leveraging extensive experience in database development, particularly with Oracle and SQL Server, to support data migration and optimization efforts. The position requires a strong understanding of data warehousing, data modeling, and performance tuning, while also emphasizing collaboration and communication within a global team.

Responsibilities

• Write complex SQL queries and PL/SQL scripts for Oracle databases.
• Transform native SQL Server queries to Oracle queries and solve migration code issues.
• Conduct data migration from one platform to another, ensuring validation and reconciliation processes are followed.
• Optimize database performance and conduct performance tuning.
• Design and implement ETL processes and concepts.

Requirements

• 10+ years of experience as a database developer, specifically with Oracle.
• Hands-on experience in writing complex SQL queries and PL/SQL.
• Experience with SQL Server and Oracle databases, particularly in query transformation.
• Strong understanding of data migration processes and validation techniques.
• Expertise in database data warehousing and data modeling concepts.
• Experience in performance tuning and optimization of databases.
• Good knowledge of ETL concepts and design.
• Strong communication skills and ability to work independently in client environments.

Nice-to-haves

• Basic understanding of Python or R.
• Experience with cloud platforms such as Snowflake or AWS.

Benefits

• Flexible work arrangements.
• Healthcare including dental, vision, and mental health 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.