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 PL/SQL Developer role at Capgemini involves leveraging extensive experience in database development, specifically with Oracle and SQL Server, to support data migration and optimization efforts. The position requires a strong understanding of data warehousing, performance tuning, and ETL concepts, while also emphasizing collaboration and communication skills in client environments.

Responsibilities

• Write complex SQL queries and PL/SQL code.
• Transform native SQL Server queries to Oracle queries.
• Solve migration code issues in Oracle PL/SQL.
• Perform data migration from one platform to another.
• Validate and reconcile data during migrations.
• Optimize database performance and tuning.
• Design and implement ETL processes.

Requirements

• 10+ years of database developer experience in Oracle.
• Hands-on experience in writing complex SQL queries and PL/SQL.
• Experience with SQL Server and Oracle databases.
• Expert understanding of database data warehousing and data modeling concepts.
• Hands-on experience in performance tuning and optimization.
• Good knowledge of ETL concepts and design.
• Strong communication skills and ability to work independently.

Nice-to-haves

• Basic understanding of Python/R.
• Experience with cloud platforms like Snowflake and AWS.

Benefits

• 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