ROUND-1: ONLINE CODING ROUND (150 minutes)
It was a online coding round hosted on hackerrank.
The paper has 5 coding questions .The questions are mainly based on graph,dynamic programming including one machine learning problem of quite good difficulty.
**Crack is you don’t need to bother about all problems,just pick up a good one according to your sound knowledge and get it done completely.I solved two problems and get to the next round.
ROUND-2: ONLINE CODING ROUND(45 minutes)
It was again a online coding and database queries round hosted on hackerrank platform.
It has total of 5 problems to be solved in 45 minutes consisting two problems of coding and three database queries.
The coding questions are easy but you need a sound knowledge about how to write database queries.
ROUND-3:TECHNICAL INTERVIEW(1 hour 45 minutes)
The final round was the technical interview.
It started with introduce yourself.
Then he asked about the areas of interest and the projects done in the last 3 years.
I mentioned one project related to web development and one related to android development.
Then he asked me to design the full schema of my web project and to check the whether all the tables and their attributes are properly normalized or not and to remove the inconsistency and redundant(useless) data ensuring data dependencies make sense.
Then he asked me to write some string algorithms in php which I mentioned in my area of interest.
Then he asked about the challenges faced in the project.
Then he asked me to design the schema of starsports.com such that any type of the queries related to scoreboard(e.g: the balls on which Ashwin takes wicket and dhoni makes stump out)should be answered and there should be no redundancy of data in the schema following all the normal forms.
Then he asked about the network protocols being used in communication between client and server.And how the session is mentioned in website in detail.
Then 3-4 coding questions were given to be solved.The questions of moderate difficulty including array,tree and string based algorithms.
At the last he asked if I had any question for him?
I asked him couple of question related to work at Practo.
Tip:Having a good projects in your resume is quite helpful in interview.Keep all your basic concepts clear regarding your projects.