[ INFO ]category: Behavioral · Onsite difficulty: average freq: first seen: 2023-10-15
[AVERAGE][ONSITE]OnsiteSWE II (Mid-Level)Accepted
$catproblem.md
Round 1: OA 1(hr)
Two DSA easy-medium questions.
Round 2: Onsite - DSA/SQL 1.30(hr)
Started with introduction and discussion on current project and work.
Then 1 DSA question based on stocks: You are given a stock in below pattern and you have you find the maximum profit within the given period. e.g. Jan- to Mar-.
[["Dec-22", 100],["Jan-23", 100],["Feb-23", 231], ["Mar-23", 123]........
SQL question: You have employees table and print the manager having 2 employees with same name. Hint: Use inner join on employee table and group by on manager_name and employee_name column and having count > 1.
Question on Java, OOPs etc. Collection framework, little bit on SOLID principles
Round 3: Onsite - Design 1.15(hr)
Started with introduction and explain the current project design and data flow* using whiteboard.
Design the data model with ER diagram for the Hotel booking system on white board and explain the APIs required:
Multiple types of room can be in one hotel
Future bookings for same room is possible
Dynamic pricing of rooms based on the booking requests
Puzzle: Easy: Given N number of coins and split them in 2 group having same no of heads.
Round 4: Online - Behavioral 50minutes
Started with introduction and discussion on old projects and things mentioned in resume.
Behavioral questions
Any recent good review comments you have given
How you handle conflict with manager
How you mentor your juniors or new hire
Why Salesforce
Question on development: How you debug the APIs, what is your approach. API patterns and it's data flow in front end. You have one table population the API payload and due to some reason data is not populating, what could be the possibilities for this issue. How will you increase the table population performance. Questions on API protocols, one-page multi-page web pages.