Kickdrum interview questions

I was called to an recruitment drive. First, they took a 90-min hackerrank test of two questions. The first question was a coding one and the other was to write SQL query. Then, I had a technical interview followed by personality profiling round.

Interview process started off with an online coding round which had 2 problems - one for testing data structures and algo, and other for SQL expertise. This was followed by 2 face to face rounds and 2 telephonic rounds. 1st round was a technical design related round with one of their developers. It tested on Database concepts, basic system design concepts like using proper data structures, etc. 2nd round was a purely technical one on past company projects, some language (Java) related specifics like concurrecny, collections, etc. 3rd and 4th rounds were with company's Principals based in US. One of them was a purely informal one with questions ranging from biggest success, biggest failures to project delivery time estimation, etc, and other one was purely technical one with questions around DBs, Java fundamentals, one code review.