Tip 1 : Be good in at least one programming language out of Python or Java because company's tech stack is mostly in these two languages. You don't need to prepare tough DSA questions, just some simple array or string based questions will be asked.
Tip 2 : Prepare DBMS and SQL very well. They do ask SQL queries in the online test as well as in the interview as well.
Tip 3 : Prepare for in person interview because the company tries very hard to take offline interviews at their office. Also please don't bluff during your interview or in your resume for that matter because you might get caught and it leaves a very bad impression. If you don't know the answer to a question, just say I don't know the answer, sorry.
Tip 1 : Mention your projects in detail along with their demos and hosted links.
Tip 2 : If you have done internships previously, please mention the tech stack and bold the keywords for example technology used or impact that your work made etc.
There were 2 programming questions and 1 SQL question. First question was a straight forward sorting based question. The second one was a little bit tricky based on hashing, but I managed to clear it. The SQL question was also very straight forward based basic order by and group by clauses.



a) Duplicate elements may be present.
b) If no such element is present return -1.
Input: Given a sequence of five numbers 2, 4, 5, 6, 8.
Output: 6
Explanation:
In the given sequence of numbers, number 8 is the largest element, followed by number 6 which is the second-largest element. Hence we return number 6 which is the second-largest element in the sequence.
I first sorted the array.
Then simply returned n-2th element in the array.
This problem can also be solved in O(n) time by keeping track of largest and second largest number respectively and updating these numbers whenever there is a number larger than the largest number so far.
The round basically went on based on the introduction i gave. I mentioned Android development and Java in my intro so the interviewer began to ask questions based on Java. He then asked about some DBMS Concepts. The interview happened at around 4 pm and was not difficult to crack at all.
Asked some basic Java questions like exception handling, JVM, JDK etc.
Normalisation, ACID properties, SQL temp tables, Keys, joins etc.
The interviewer came in 10 minutes late and only asked me give my introduction. She was impressed by my introduction and said that she had no further questions to ask me since in the previous round they had already asked me all technical questions.

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