Tip 1 : You have to be good with SQL commands and must have hands on practice on topics like group by, sub-query, join statement.
Tip 2 : Should practice basic programming printing patterns type questions.
Tip 3 : One project is at least needed in resume so that your profile looks attractive to them and must be prepared for situation based question as well.
Tip 1 : Must have at least one project on resume that will help you differentiate from others.
Tip 2 : Must mention all the external course certificates that you have done from online learning platform along with all the skills you have, this will also help your resume be more precise than others.
There were 45 MCQ's aptitude question in an hour. Aptitude questions was bit on difficult side if you are not regular at aptitude you will face difficulty with time being not so much.
So the interviewer starts with asking to introduce myself and then he asked about my interest of subjects and I mentioned DBMS along with python is my strong area and then he start asking from that topics only.
At first he started with DBMS asking basic questions like about DDL,DML,TCL,DCL commands, group by commands and the he shifts to asking few questions on SQL joins and their types, at last from DBMS topics he asked about normalizations and their various types. After that he shifts his focuses towards OOPs concepts and asked about all the OOPs concept and finally few questions my project. Before ending the interview he also asked few scenarios based question and that was easy if you are good at story telling.
The last round was with partner and director of KPMG along with HR, again it was technical round along with few HR questions. At the beginning they again started to ask me about OOPs concept and their real life examples and mention that I have to learn Java ( as I was good at python) and I agreed and after that they shift towards HR round which was barely 2 questions like will you be able to relocate and about my strengths and weakness and last question from HR was "hope you do not have problem in travelling even during covid times" and they were pretty satisfied with all my answer and said you will soon hear from us.

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