First Round: It was a Telephonic Interview. Regular Questions like
1. Tell me about Yourself
2. Your work and skills
i said everything and from that the interviewer asked me a question on which i have worked
How do you determine whether you need a Sql database or a NoSql database?
How do you determine which NoSql Database is suited for you?
What are the limitations of some popular Databases like MongoDb, Cassandra etc,.
120k requests are hitting the server concurrently and you have a 2gb ram ubuntu system 128gb SSD, will your server handle the requests?
What are the possible errors you can encounter in the above case?
I have answered them all in detail.
Next came the Data Structure and Algorithm related question.
Some students are taking test and every question is a multiple choice question, in real-time i would like to know the stats like, how many students attempted a question correctly, student ranks etc,.
I came with a graph kind of concept.
He was impressed with my fundamentals and computer concepts.
Round 2: I was waiting for the round-2 on skype and the interviewer got some other work so it was postponed and HR called me and said it and it was postponed to next day.
I was asked to do the Database model for the same structure and write code for the implementation.
I did it but interviewer asked me to improvise my answer , i thought for a while and came up with using web sockets, he just accepted the answer.
Next he asked me on some java questions like when to use hashmap, linkedhashmap, hashset, hashtable etc.,
Difference between Compilation error and Run time error
He asked some theoretical question which i didn't remember - i said i am bad at theory
Round-3 :
Given a file file of format:
ColHeader_1, ColHeader_2, ColHeader__3
col1val1, col2val1, col3val1
col1val2, col2val2, col3val2
col1val3, col2val3, col3val3
col1val4, col2val4, col3val4
output should should be a json like:
[{
ColHeader_1: col1val1,
ColHeader_2: col2val1,
ColHeader__3: col3val1
},{
ColHeader_1: col1val2,
ColHeader_2: col2val2,
ColHeader__3: col3val2
},{
ColHeader_1: col1val3,
ColHeader_2: col2val3,
ColHeader__3: col3val3
},{
ColHeader_1: col1val4,
ColHeader_2: col2val4,
ColHeader__3: col3val4
}]
for the same question values has to be validated.
i gave a code which does validation but interviewer asked me to use FactoryUtils
I said i don't have an idea about them, but he accepted the solution and later came some theoretical questions.
they took 3 days to sent me the offer letter.