Tip 1 : Practice guesstimates and puzzles.
Tip 2 : Do atleast 2 projects using various data sets.
Tip 1 : Do not put fake things on resume.
Tip 2 : A short and crisp description is good to have.
It had multiple reasoning, aptitude questions, pseudo codes and there was one guesstimate and an essay.
Guesstimate on how many people uses mobile phones in India
Tip 1 : Try to narrow down the problem first before writing.
Tip 2 : Use proper description of every step.
It was a technical round
Medium level SQL queries were asked on joins, pivot.
Tip 1 : Do practice SQL queries.
Tip 2 : I had used MSSQL which had various in built functions which helped.
Programming Questions were asked
How to change the data type and push the data into a database?
Step 1 : Using pandas to get the data type using pandas .info()
Step 2 : Used as_type()
Step 3 : Put the data as a data frame.
Step 4 : Using sql alchemy to push the data into the sql database.

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