Cheers Interactive Software Engineer Interview Questions and Answers for Experienced

Cofing round on hackerearth

Case study with algo and db design

This aptitude + technical MCQ test was of 120 minutes in duration. Had MCQs on quantitative ability, logical ability, Language, and technical MCQs consisted of questions on DBMS, OS, Networks, DSA. There were two coding questions as well. One on Bit Manipulating, and the other on DFS.

Q1. A question on BFS very similar to Leetcode 924. Was given one hour to discuss and come to an optimized solution with the interviewer.
Add your answer

Q1. Search an element in a sorted and rotated array
Ans. 
Search an element in a sorted and rotated array
• Find the pivot point where the array is rotated

• Divide the array into two sub-arrays based on pivot point

• Perform binary search on the appropriate sub-array
Answered by AI
Add your answer
Q2. SQL query on left join
Add your answer
Q3. Questions on CPP memory management
Add your answer
Q4. Questions related to projects done
Add your answer

Q1. Propose a system for a popular media stream service
Ans. 
Proposed system for a popular media stream service
• Implement a recommendation engine to suggest content based on user preferences and viewing history

• Integrate with social media platforms to allow users to share and discuss content

• Provide multiple subscription options with varying levels of access and features

• Ensure high-quality streaming with minimal buffering through the use of content delivery networks

• Implement robust...read more
Answered by AI
Add your answer
Q2. Questions related to Fullstack Tech Stacks
Add your answer

Guesstimate on number of Reddit users in India. No starting input was given. Gave solution by using bottom to top approach. Tried to focus on quantifying teenagers with internet access and a particular interest about internet. Gave a figure around ~1 million in a year.

Q1. Where do you see yourself at McKinsey?
Add your answer

Q1. Asked about SAAS, JS questions
Add your answer

Given a case study need to solve in 2 days

Q1. Explain the case study. Palindrome function in any prog language
Ans. 
A palindrome function checks if a given string reads the same forwards and backwards.
• A palindrome function typically involves reversing the input string and comparing it to the original string.

• Examples: 'racecar' is a palindrome, 'hello' is not a palindrome.

• Common languages for implementing a palindrome function include Python, Java, and C++.
Answered by AI
Add your answer

Q1. General Guidelines
Add your answer

4 problems 2 easy 2 meds

Q1. Problem solving
Add your answer
Q2. Why you choose bcg
Add your answer
Q3. Case study what is it
Add your answer

This round includes an assignment which needs to be completed based on Java, Springboot, REST and any Frontend. They evaluated the case study based on how I write the APIs, how normalised my database is, and how user friendly the UI is.

Q1. How will you add pagination in Spring Boot JPA query?

Ans. 

Use Spring Data JPA's Pageable interface to add pagination in queries.

• Use Pageable interface in repository method signature

• Pass PageRequest object with page number, size, and sorting criteria

• Example: public List findAllUsers(Pageable pageable);

Add your answer