EY-Consulting Advanced PL/SQL - Technical Consultant Job Summary

Were looking for PLSQL Technical Consultant to join the leadership group of our Consulting Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.

Responsibilities

- Support client needs in Oracle application development/support using Advanced PL/SQL
- Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements
- Working knowledge of a source code control system
- Interact with senior leaders, understand their business goals, contribute to the delivery of the workstreams

Skills and attributes for success
- SQL Concepts Group By / Joins/ Surrogate Keys / Constraints/ Datatypes / Indexes
- Experience in designing and developing Oracle objects such as Experience with SQL queries (Scalar subqueries, inline views, outer joins, hints, and analytic functions
- Experience of creating PL/SQL Packages, Procedures,



Functions, Triggers, Views, Collections and Exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
- Experience in SQL tuning and optimization using explain plan and SQL trace files
- Partitioning, Hints and Indexing strategy for optimal performance
- Experience in Direct Load & Conventional Load using SQL Loader
- Should have good understanding Oracle Database Architecture
- Prior consulting experience preferred

To qualify for the role, you must have
- Computer Science degree or equivalent
- 4 to 6 years of development experience
- Solid analytical and debugging skills
- Good understanding of advanced PL/SQL and performance tuning
- Should have positive and learning attitude, Good Communication, Strong Analytical skills

📌 Senior Oracle Database Developer (Noida)
🏢 EY
📍 Noida