It consisted of 4 rounds.
1. Online test
The online test consisted of 22 MCQs and one coding question, most of which were asked on
DBMS, specifically complex SQL queries. It also consisted of questions from OS and Quantitative
Analysis.
The coding question was hosted on HackerEarth. The question was as follows :
There are M red candies, N blue candies and not more than K number of candies of same
color can be put together; calculate the number of ways candies can be arranged for given values of
M,N, and K.
2. Round 1 – Around 10 mins
Round 1 consisted of basic questions to test logic and knowledge about the projects done by
the students. Also, questions were asked on your resume. Very deep technical knowledge was not
expected in this round. One student was asked about the internal working of vectors in C++, though.
3. Round 2 (Technical round) -- Went on for around 30 mins.
Conducted by the technical people of the company. Questions asked to me were as
follows :
1. Explain your project (The one you are most comfortable with)
2. Asked to write 3 SQL queries on particular scenarios. (Use of Joins and Sub-queries
expected)
3. Asked some questions regarding logic: for eg. A page consists of some words. So, how
will you calculate the number of occurrences of each word? Then asked, if I want to keep a word and its
occurances at the first position, and rest should be sorted, how it can be done.
4. Asked about the sorting in the above problem, and how to do it.
5. Asked to explain Merge sort.
6. The time complexity of Merge sort
7. Questions about different Data Structures, their properties, and complexities of all of the
operations.
4. Round 4 (HR round)
Typical HR questions like what do you like, would you go on with Higher education or Job
, and why. What changes did you observe being away from your home, etc.