Case study: given a problem you have develop a dbms with best practices. Once done there is section for improvements in existing design. Expect few technical questions on the same. Technical round: Normal intro followed by few questions on resume. Prepare java very well. Since I had SQL experience he asked Java questions mentioning i already good in SQL. Expect design questions. Puzzles. Only mention things on resume which you are good at. This round was very good. Lasted for an hour. Many questions on programming and design aspects. Hiring Manager: H.R told my rating are excellent so far, be very clear in front of manager. Think before you say anything. In this round you can expect questions on resume. I mentioned about ML but I hardly had started. That's something he did not like I believe. He pointed out 2-3 mistakes in resume. He asked some SQL questions and Dataware housing. I answered most of them but I was not confident talking to him as HR told he is strict. In some areas i failed to answer but still he was gave positive feedback saying profile is good. He was very friendly was talking like a friend but that might be to dig into your background. Be clear what you would say. I was told that I will be informed in a week of 2 as there other candidates for interview as well. I did try to follow up but unfortunately nobody replied. They completely ignored my mails.