1st round : Hacker earth test (To design a customer loyalty program using spring boot). 1 SQL query (Difficulty level medium) 2nd round: F2F interview at office location. Questions asked: A user has complained that he is facing slowness in the system. How will you begin solving the issue? How will you optimise a SQL query? Due to a server issue, you have all the data from ur redis db. How will you recover it?