i
Deloitte
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
I applied via LinkedIn and was interviewed in Aug 2022. There were 2 interview rounds.
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 ...
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...
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
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...
posted on 9 Oct 2024
I applied via Recruitment Consulltant and was interviewed in Sep 2024. There were 2 interview rounds.
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.
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...
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
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
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
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...
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.
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
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...
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...
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.
I applied via Naukri.com
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);
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
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
I applied via LinkedIn and was interviewed in Mar 2024. There was 1 interview round.
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
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
posted on 8 Mar 2024
I applied via Campus Placement
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
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...
Consultant
32.8k
salaries
| ₹6.2 L/yr - ₹23 L/yr |
Senior Consultant
20.9k
salaries
| ₹11 L/yr - ₹42 L/yr |
Analyst
13.9k
salaries
| ₹3.8 L/yr - ₹12.5 L/yr |
Assistant Manager
9.9k
salaries
| ₹7.6 L/yr - ₹24 L/yr |
Manager
7k
salaries
| ₹15.7 L/yr - ₹52 L/yr |
Accenture
PwC
Ernst & Young
Cognizant