PL/SQL Developer

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you'd like, where you'll be supported and inspired bya collaborative community of colleagues around the world, and where you'll be able to reimagine what's possible. Join us and help the world's leading organizationsunlock the value of technology and build a more sustainable, more inclusive world.

Job Description

Responsibilities:

• 8+ years of full-time experience in Oracle PL/SQL development, preferably in Data Warehouse projects Solid background in Oracle Database Concepts, Advanced SQL, Database design, Database modelling and Performance tuning
• Expertise in working with very large database with high concurrency or batch processing
• Expertise in writing efficient SQL and PL/SQL code (Packages, Procedures, Functions, Triggers etc.,)
• Extensive knowledge of Dynamic SQL and queries.
• Experience with Oracle Analytical functions, Materialized Views, Cursors, Ref-cursors, and Collections.
• Experience in Table Partitioning, Indexing, Index Compression.
• Experience in Complex report developments using SQL / PLSQL (Pivoting / Unpivoting, Aggregation etc.,)
• Excellent debugging skills (should be able to dive-in in any of the existing code and debug for any issues reported)
• Experience in System integrations, client interactions in preparing functional designs.
• Experience in all phases of SDLC including requirement analysis, development, testing, deployment and production support in large-scale applications. Experience in Bitbucket, Jenkins and other DevOps tools will be preferred
• Experience in Finance domain is desirable (Experience in Capital Markets and Treasury Portfolio Management will be a plus)
• Should have analytical thinking and good problem-solving skills to understand and to translate complex business requirements into system requirement specifications and to build the system
• Excellent documentation and presentation skills, great verbal and written communication skills Analytical thinker, quick learner and proficient problem-solver who envisions business and technical perspectives to develop workable solutions

Skills (competencies)

SQL

Database Platform - MySQL

SQL Server (Relational Database)

Analytical Thinking

Inclusive Communication

Verbal Communication

Written Communication

(SDLC) Methodology

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fuelled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of 22.5 billion.