Salesforce Staff Engineer Interview Questions and Answers

Q1. The question were related to sql and power bi
Add your answer
Q2. How do you do data analysis before building the reports? What steps do you take?
Ans. 
Before building reports, I conduct data analysis by following a structured process.
• Define the objective of the analysis and the key questions to be answered

• Collect relevant data from various sources

• Clean and preprocess the data to ensure accuracy and consistency

• Perform exploratory data analysis to identify patterns and trends

• Use statistical methods and tools to analyze the data

• Visualize the data using charts, graphs, a...read more
Answered by AI
Add your answer

Q1. Leetcode medium questions were asked
Add your answer

- DP cost optimisation Problem
- Object orient design question like design a vending machine

Q1. - Design patterns questions - Questions on aws
Add your answer

Q1. - How to measure api performance - jvm related questions
Add your answer

Q1. Why hire? Your strength? How you will contribute?
Add your answer

Search and sort alogorithm, remove duplicate item in array and how many times its repeated

Q1. Rotate array with how many times the array was rotated. testing questions. team management questions.
Add your answer

Q1. System Design Round1: Design a distributed log storage and analysis system
Ans. 
Design a distributed log storage and analysis system
• Use a distributed file system like HDFS or Amazon S3 for storing logs

• Implement a log aggregation system like Apache Kafka for collecting logs from various sources

• Utilize a distributed processing framework like Apache Spark for analyzing logs in real-time

• Consider using a NoSQL database like Cassandra for storing processed log data
Answered by AI
Add your answer

Q1. System Design Round2: Design a system similar to Zookeeper
Ans. 
Design a system similar to Zookeeper for managing distributed systems
• Use a centralized service for maintaining configuration information, naming, and providing distributed synchronization

• Implement a hierarchical namespace similar to file system paths for organizing data

• Utilize a consensus algorithm like Paxos or Raft for ensuring consistency and fault tolerance
Answered by AI
Add your answer

Q1. Coding Round1: DS Problem based on creating subs on DB table
Add your answer

Q1. Coding Round2: DS Problem related to linux directory structure
Add your answer

Q1. Googliness Round: Various questions about qulity, team player, leadership etc.
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

In first round, I was not able to complete code but explained the solution. 
Tip : Try to practice coding even if you have 10 years of experience.

Q1. 
Search In Rotated Sorted Array Problem Statement
Given a rotated sorted array ARR of size 'N' and an integer 'K', determine the index at which 'K' is present in the array.
Note:
1. If 'K' is not present...read more
Ans. 
This question could be solved using Binary search which would have a time complexity of O(log n). The approach would be: 
1. Find the mid = (low + high)/2
2. If key is present at middle point, return mid.
3. If arr[low….mid] is sorted
a) If key to be searched lies in range from arr[low] to arr[mid], apply binary search for arr[low..mid].
b) Else apply for arr[mid+1..high]
4. Else (arr[mid+1..high] must be sorted)
a) If k...read more
Answered Anonymously
Add your answer
Q2. 
Minimum Jumps Problem Statement
Bob and his wife are in the famous 'Arcade' mall in the city of Berland. This mall has a unique way of moving between shops using trampolines. Each shop is laid out in a st...read more
Ans. 
Greedy approach can be used here. If observed carefully , it can be concluded that it is always optimal to shift the elements towards the median element among the persons or the center person among all the persons present. The number of jumps will always be minimum when we shift points to the median
Steps :
1. Create an array/ list to store the indexes of the persons present.
2. Find the median of the created list. All th...read more
Answered Anonymously
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

Round 2 went very good. They gave a design question in this round.

Q1. Design a file searching functionality for Windows and Mac that includes indexing of file names.
Ans. 
Tip 1 : Design your structure and functions according to the requirements and try to convey your thoughts properly to the interviewer so that you do not mess up while implementing the idea .
Tip 2 : Before you jump into the solution always clarify all the assumptions you’re making at the beginning of the interview. Ask questions to identify the scope of the system. This will clear the initial doubt, and you will get to ...read more
Answered Anonymously
Add your answer

Round duration - 45 minutes
Round difficulty - Medium

The third round was also a design round.

Q1. How would you design a system for MakeMyTrip?
Ans. 
Tip 1: Firstly, remember that the system design round is extremely open-ended and there’s no such thing as a standard answer. Even for the same question, you’ll have a totally different discussion with different interviewers.
Tip 2:Before you jump into the solution always clarify all the assumptions you’re making at the beginning of the interview. Ask questions to identify the scope of the system. This will clear the in...read more
Answered Anonymously
Add your answer

Q1. Design bookmyshow
Add your answer
Q2. Explain ur proj design
Ans. 
Designed a project to improve efficiency of data processing in a cloud-based system.
• Implemented parallel processing to handle large volumes of data

• Utilized distributed computing to reduce processing time

• Designed a scalable architecture to accommodate future growth
Answered by AI
Add your answer