Oracle Advanced Engineering-ODI- PLSQL-senior

Bangalore, Karnataka
Permanent
Full-time

6 days ago

At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all.EY-Consulting - Advanced PL/SQL - Technical Consultant-SeniorThe opportunityWe're looking for PLSQL Technical Consultant(Manager) 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.Your key 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
3 to 7 years of development experience
Strong analytical and debugging skills
Good understanding of advanced PL/SQL and performance tuning
Should have positive and learning attitude, Good Communication, Strong Analytical skills

What working at EY offersAt EY, we're dedicated to helping our clients, from start-ups to Fortune 500 companies - and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

Support, coaching and feedback from some of the most engaging colleagues around
Opportunities to develop new skills and progress your career
The freedom and flexibility to handle your role in a way that's right for you

EY | Building a better working worldEY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.

Apply Now