Salesforce MTS Onsite | Hyderabad
Summary
I recently interviewed for a Member of Technical Staff (MTS) role at Salesforce in Hyderabad. The interview process consisted of an Online Assessment, a DSA/SQL round, a System Design round, and a Behavioral round. I successfully received an offer for the position.
Full Experience
Round 1: Online Assessment (1 hour)
This round consisted of two Data Structures and Algorithms questions, ranging from easy to medium difficulty. I solved both of them successfully.
Round 2: Onsite - DSA/SQL (1 hour 30 minutes)
The round began with an introduction and a discussion about my current project and work. Following that, I was given a DSA question based on stocks, where I had to find the maximum profit within a given period. Next was an SQL question involving an employees table, where I needed to identify managers with two employees sharing the same name. We also discussed Java, OOPs concepts, the Collection framework, and a bit about SOLID principles.
Round 3: Onsite - Design (1 hour 15 minutes)
This round started with an introduction and an explanation of my current project's design and data flow using a whiteboard. The main task was to design the data model with an ER diagram for a Hotel Booking system on the whiteboard, explaining the required APIs. Key considerations included handling multiple room types in one hotel, allowing future bookings for the same room, and implementing dynamic pricing based on booking requests. Finally, an easy puzzle was posed: given N number of coins, split them into two groups having the same number of heads.
Round 4: Online - Behavioral (50 minutes)
This round commenced with an introduction and a discussion of my older projects and the details mentioned in my resume. Behavioral questions followed, such as asking about any recent good review comments I had given, how I handle conflicts with a manager, how I mentor my juniors or new hires, and why I was interested in Salesforce. Additionally, there were questions on development practices: how I debug APIs, my general approach, API patterns, and data flow in the frontend. We also discussed scenarios like a table population API payload not populating data and the possible reasons, as well as strategies to increase table population performance. Questions on API protocols and the differences between one-page and multi-page web pages were also part of this round.
I am happy to share that I was selected for the role.
Interview Questions (9)
You are given stock prices in a pattern like [['Dec-22', 100],['Jan-23', 100],['Feb-23', 231], ['Mar-23', 123]....]. Find the maximum profit within a given period, for example, Jan-2020 to Mar-2023.
Given an employees table, find and print the manager who has at least two employees with the same name. Hint: Use inner join on the employee table, group by manager_name and employee_name columns, and use having count > 1.
Design the data model with an ER diagram for a Hotel Booking system. Explain the required APIs. Considerations include: multiple types of rooms can be in one hotel, future bookings for the same room are possible, and dynamic pricing of rooms based on booking requests.
Given N number of coins, split them into two groups such that both groups have the same number of heads.
Describe any recent good review comments you have given to a colleague or team member.
Explain how you handle conflicts or disagreements with your manager.
Share your approach on how you mentor your juniors or new hires.
Why are you interested in joining Salesforce?
How do you debug APIs? What is your approach? Discuss API patterns and their data flow in the frontend. If you have a table populating an API payload and data is not populating, what could be the possibilities for this issue? How would you increase the table population performance? Questions on API protocols, one-page vs. multi-page web pages.