Upload Button Icon Add office photos
Premium Employer

i

This company page is being actively managed by Deloitte Team. If you also belong to the team, you can get access from here

Deloitte Verified Tick

Compare button icon Compare button icon Compare
3.8

based on 16.9k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Deloitte Senior Plsql Developer Interview Questions, Process, and Tips

Updated 29 Sep 2022

Deloitte Senior Plsql Developer Interview Experiences

1 interview found

I applied via LinkedIn and was interviewed in Aug 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(4 Questions)

  • Q1. Did you ever work on query tuning and optimization? What do you see in explain plan?
  • Ans. 

    Yes, I have worked on query tuning and optimization. Explain plan helps in identifying the execution plan of a query.

    • I have experience in identifying and resolving performance issues in SQL queries.

    • I use explain plan to analyze the query execution plan and identify any bottlenecks.

    • I look for factors like full table scans, index usage, and join methods to optimize the query.

    • I also use tools like SQL Trace and TKPROF to ...

  • Answered by AI
  • Q2. How partitions is useful and when to create it
  • Ans. 

    Partitions are useful for managing large tables and improving query performance.

    • Partitions allow for data to be split into smaller, more manageable chunks

    • Queries can be run on specific partitions, improving performance

    • Partitions can be based on various criteria such as date, range, or hash

    • Example: Partitioning a sales table by date can improve query performance for recent sales data

    • Example: Partitioning a customer tabl...

  • Answered by AI
  • Q3. How to debug procedure which has nested procedure in it.
  • Ans. 

    Debugging a procedure with nested procedure.

    • Use DBMS_OUTPUT.PUT_LINE to print debug information

    • Use EXCEPTION block to catch and handle errors

    • Use SQL Developer Debugger to step through the code

    • Check the input and output parameters of the nested procedure

    • Use logging framework to log debug information

  • Answered by AI
  • Q4. How to fetch hierarchical data
  • Ans. 

    Hierarchical data can be fetched using recursive queries or hierarchical queries.

    • Recursive queries use a common table expression (CTE) to repeatedly join a table to itself.

    • Hierarchical queries use the CONNECT BY clause to specify the parent-child relationship.

    • Both methods require a column that identifies the parent of each row, such as an ID or parent ID column.

    • Example: SELECT * FROM employees WHERE manager_id = 123 CO...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Understand the architecture of database and the process how it works.
Experienced employees has to answer questions very logically

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. When you want delete account accosiated with contact. The account should not get deleted.
  • Ans. 

    To delete an account associated with a contact without deleting the account itself.

    • Remove the contact's association with the account before deleting the contact.

    • Check for any other dependencies before deleting the contact.

    • Consider creating a custom field to track the association between the contact and account.

  • Answered by AI
  • Q2. Do have experience in flows, Explain the flows
  • Ans. 

    Flows are declarative automation tools in Salesforce used to automate business processes by collecting data and performing operations.

    • Flows are created using a visual designer in Salesforce.

    • They can automate complex business processes without writing code.

    • Flows can collect data from users, interact with Salesforce, and make decisions based on user input or data.

    • They can be triggered by various events like record change...

  • Answered by AI
Round 2 - Client Interview 

(2 Questions)

  • Q1. When rating is hot update description
  • Ans. 

    When a rating is hot, update the description accordingly.

    • Monitor user feedback and ratings regularly

    • Update the description based on the latest ratings and reviews

    • Consider adding specific details or addressing common concerns mentioned in the feedback

  • Answered by AI
  • Q2. Tell me about yourself
  • Ans. 

    I am a Salesforce Developer with 5 years of experience in designing and implementing custom solutions for clients.

    • 5 years of experience in Salesforce development

    • Strong expertise in designing and implementing custom solutions

    • Proficient in Apex, Visualforce, and Lightning components

    • Certified Salesforce Developer

    • Experience working with clients to understand their requirements and deliver solutions

  • Answered by AI
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Technical 

(5 Questions)

  • Q1. What is Salesforce service cloud
  • Ans. 

    Salesforce Service Cloud is a customer service platform that helps businesses manage and improve customer interactions.

    • It allows businesses to provide personalized customer support through various channels such as phone, email, chat, and social media.

    • Service Cloud includes features like case management, knowledge base, and omni-channel routing to streamline customer service processes.

    • It integrates with other Salesforce...

  • Answered by AI
  • Q2. How do you rate your self in coding
  • Q3. Salesforce Security model question
  • Q4. Have you worked on flows
  • Ans. 

    Yes, I have worked on flows in Salesforce.

    • I have experience creating flows to automate business processes in Salesforce.

    • I have used flows to streamline data entry and update records efficiently.

    • I have integrated flows with other Salesforce features like Process Builder and Apex triggers.

  • Answered by AI
  • Q5. Mostly asked what you mentioned in your resume
Round 2 - Technical 

(3 Questions)

  • Q1. Write trigger on parent child scenario
  • Ans. 

    Writing trigger on parent child scenario in Salesforce

    • Create trigger on parent object

    • Use trigger context variables to access child records

    • Perform necessary operations on child records based on parent record changes

  • Answered by AI
  • Q2. Wha are important feature of service cloud, LWC decorators, events in lwc, asynchronous apex , batch class, flows and its type , experience cloud basics .
  • Ans. 

    Service Cloud features, LWC decorators, events, asynchronous apex, batch class, flows, and experience cloud basics.

    • Service Cloud features include case management, knowledge base, omni-channel routing, and service console.

    • LWC decorators are used to add metadata to Lightning web components, such as @api, @track, and @wire.

    • Events in LWC are used for communication between components, such as standard events like onchange a...

  • Answered by AI
  • Q3. Expectations was user should know each and every topic of Salesforce

Interview Preparation Tips

Interview preparation tips for other job seekers - First round was very good answered every single question asked by panel . After first round
HR says feedback is good, you got selected no need of next round , Asked what is final expected salary and notice period , for which i already shared before screening process .

Then after couple of days HR calls back and said Panel no sure about you wants to check another round of interview. Even my second round was good answer almost all questions. Not got any feedback from HR despite of couple of follow up .

People who want to apply make sure that you share your expectations with HR clearly .

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. What is trigger in salesforce
  • Ans. 

    A trigger in Salesforce is a piece of code that is executed before or after specific data manipulation events, such as insert, update, or delete.

    • Triggers are used to perform custom actions on records in Salesforce.

    • Triggers can be written in Apex programming language.

    • Triggers can be executed before or after specific events like insert, update, or delete.

    • Triggers are associated with a specific object in Salesforce.

    • Exampl...

  • Answered by AI
  • Q2. Type of flows in salesforce
  • Ans. 

    There are three types of flows in Salesforce: Autolaunched Flows, Screen Flows, and Scheduled Flows.

    • Autolaunched Flows are triggered by a process or Apex trigger and do not require user interaction.

    • Screen Flows guide users through a series of screens to collect and display information.

    • Scheduled Flows are triggered by a schedule and can automate repetitive tasks.

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com

Round 1 - One-on-one 

(2 Questions)

  • Q1. Write a java program to sort an array
  • Ans. 

    Java program to sort an array of strings

    • Use Arrays.sort() method to sort the array of strings

    • Import java.util.Arrays package

    • Example: String[] arr = {"apple", "banana", "orange"}; Arrays.sort(arr);

  • Answered by AI
  • Q2. Collections in java and springboot
  • Ans. 

    Collections in Java and Spring Boot are used to store and manipulate groups of objects.

    • Collections in Java are used to store multiple objects in a single unit.

    • Spring Boot provides support for managing collections through various data structures like List, Set, Map, etc.

    • Collections in Java and Spring Boot help in organizing and manipulating data efficiently.

    • Example: List names = new ArrayList<>();

Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. About Reframework
  • Q2. About project and concepts used

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Confident
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Java questions , stream api
  • Q2. Whatever you have mention in resume

Interview Preparation Tips

Interview preparation tips for other job seekers - Java basics, memory management, multithreading.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. When have you had a conflict with someone.
  • Ans. 

    I had a conflict with a team member over project priorities.

    • Miscommunication led to conflicting priorities

    • Discussed the issue openly and found a compromise

    • Learned the importance of clear communication in team projects

  • Answered by AI
  • Q2. Tell me you greatest project
  • Ans. 

    Developed a web-based project management tool for tracking tasks and deadlines

    • Used React for front-end development

    • Implemented user authentication and authorization using JWT tokens

    • Utilized Node.js and Express for back-end development

    • Integrated MongoDB for database storage

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Technical 

(1 Question)

  • Q1. Questions based on Java , C++ , OOPs, cloud computing, one coding question, regarding previous projects, some behavioural questions.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. What is orchestrator?
  • Ans. 

    Orchestrator is a centralized platform for managing, monitoring, and controlling RPA processes.

    • Centralized platform for managing RPA processes

    • Allows scheduling and monitoring of bots

    • Provides analytics and reporting capabilities

    • Enables integration with other systems and applications

  • Answered by AI
  • Q2. What is Ocr engine?
  • Ans. 

    OCR engine stands for Optical Character Recognition engine, which is a technology used to convert different types of documents, such as scanned paper documents, PDF files, or images captured by a digital camera, into editable and searchable data.

    • OCR engine uses algorithms to recognize text within images or scanned documents.

    • It can extract text from various sources like printed documents, handwriting, or even text withi...

  • Answered by AI

Skills evaluated in this interview

Deloitte Interview FAQs

How many rounds are there in Deloitte Senior Plsql Developer interview?
Deloitte interview process usually has 2 rounds. The most common rounds in the Deloitte interview process are Resume Shortlist and Technical.
What are the top questions asked in Deloitte Senior Plsql Developer interview?

Some of the top questions asked at the Deloitte Senior Plsql Developer interview -

  1. Did you ever work on query tuning and optimization? What do you see in explain ...read more
  2. How to debug procedure which has nested procedure in ...read more
  3. How partitions is useful and when to create...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 Deloitte interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.1k Interviews
Accenture Interview Questions
3.9
 • 7.9k Interviews
Capgemini Interview Questions
3.8
 • 4.7k Interviews
IBM Interview Questions
4.1
 • 2.3k Interviews
PwC Interview Questions
3.4
 • 1.3k Interviews
Ernst & Young Interview Questions
3.5
 • 1.1k Interviews
KPMG India Interview Questions
3.5
 • 770 Interviews
ZS Interview Questions
3.4
 • 466 Interviews
BCG Interview Questions
3.8
 • 191 Interviews
View all
Consultant
32.8k salaries
unlock blur

₹6.2 L/yr - ₹23 L/yr

Senior Consultant
20.9k salaries
unlock blur

₹11 L/yr - ₹42 L/yr

Analyst
13.9k salaries
unlock blur

₹3.8 L/yr - ₹12.5 L/yr

Assistant Manager
9.9k salaries
unlock blur

₹7.6 L/yr - ₹24 L/yr

Manager
7k salaries
unlock blur

₹15.7 L/yr - ₹52 L/yr

Explore more salaries
Compare Deloitte with

Accenture

3.9
Compare

PwC

3.4
Compare

Ernst & Young

3.5
Compare

Cognizant

3.8
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview