First round was telephonic interview. Based on my resume the interviewer started with asking about my Big data project and based about RegExp that I used in the project, asked a quick question on that. Then he asked about the technologies used in the project. Then he asked few Java question - easy ones. Since, I'd mention Spring MVC in my resume, he asked about Dependency Injection.
I passed the First round and I was called onsite.
Onsite, first round, two engineers asked me to design a game - Tetris within 45 minutes, on paper. I stumbled a little bit in the beginning. Then I started designing it, making models and explaining them what I'm doing at the same time. They asked me questions and their doubt meanwhile which helped me to revise. The time was up, I pretty much had covered most of the game features.
Second round was from the Information Systems engineers, they asked my SQL queries. The question was I have a table containing millions of records and I have to calculate sum, avg, mean, median and SD without using inbuilt methods of SQL ( I can use count though).
And that has to done by writing only SQL queries.
Further on, the design tables and more SQL queries given some business requirements. And how would I do the same using MapReduce.
Third round was algorithms and data structures. A program on String manipulation and reverse a Linked List. Then some objectives on front-end Javascript. Then a mathematical problem/puzzle on '25 Horses problem'.
Then there was a lunch with 2 engineers. We had conversations about myself, about company, about Norwalk.
After getting back, I had one more interview round that was HR round. There were 2 HR's who brainstormed me with lots of behavioural questions like why I want this company, why should they choose me, what stands me out from crowd, what qualities I have better than others and so on.