Tip 1 : Practice puzzles, guesstimates. First try on your own without looking at the solution and then check the solution see where you are going wrong and focus on that.
Tip 2 : Structured problem solving is very important while solving guesstimates/ case studies - this is the main thing the interviewer looks for
Tip 3 : SQL and Python are not mandatory but those are good to have skills
Tip 1 : Mention projects have worked on and skills you know. If you don't have any technical skills, that's fine for fresher and focus on your problem solving skills.
Tip 2 : If you have time, do some projects on SQL/Python on data analysis again in a structured way
Test was online and can give the test anytime as per your convenience but before the deadline. Most of the questions were aptitude type and few were related to basic programming skills.
Aptitude questions related to speed, time and distance, work done, ratio and proportions, probability etc.
Number Of MCQs - 30
I was given with a guesstimate problem and 20 mins to solve the problem where I had to mention my approach and all the assumptions in a piece of paper. Then it was a face to face interview regarding the guesstimate asking the assumptions, approach and alternate ways of solving the problem and some puzzles.
Hourglass puzzle
Case Study round and one more guesstimate.
I was provided with a problem and was asked to frame questions that needs to be asked to the business stakeholder to solve the problem at hand.

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