Tip 1 : Practice a lot of questions on MySQL in platforms like Hackerrank as it would help a lot in the technical round.
Tip 2 : Practice plenty of guesstimates, puzzles, and business case studies.
Tip 3 : Follow a comprehensive approach to solve a case study and focus on the right approach rather than focusing on the correct answer.
Tip 1 : A good project will help a lot in cracking the behavioral interview
Tip 2 : Put only genuine things on the resume as cross-questions will be asked them definitely.
This round consisted of an MCQ round + Problem-Solving round + a video interview round, all were elimination rounds.
The MCQ round contained problems to test problem-solving skills, data interpretation, and aptitude.
If we clear the MCQ round then the problem-solving round is unlocked immediately. This round contained questions that tested the candidate's problem-solving abilities and how he reaches the optimal solutions to that problem.
If we clear this round then the video interview round is unlocked.
Video interview contained situation based questions which we were given 10 seconds to read and then answer them on camera for more than a minute.
Quantitative questions on topics like probability, speed and time, work, profits and loss etc.
This round consisted of a business case study.
A case study was given to the candidate to study and analyze it and then formulate the approach on how to reach answers to those questions. The time for all this was 1 hour.
After that, an interviewer discussed the approach and solutions to the questions that we formulated. Why and how did we choose the particular path to that approach, everything was discussed. MySQL questions were also asked
SQL query to generate a report of customer churn based on the data in the case study.
The interview was in the evening. The interviewer was a senior manager in the company.
He asked me to walk through my resume. He discussed the projects and internships that I had mentioned in the resume. He also asked technical questions on my internship project as well.
After that, he asked me a guessstimate on finding the number of roads in a city to which I gave a satisfactory approach.
Then he asked me two puzzles to which I gave the correct answer. He also asked me questions on joins.
In the end, I asked him about my career journey if I was selected in the company to which he replied meticulously.
Tip 1 : Give a correct MECE approach.

Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
What is recursion?