1st round was a written test that comprises with a very difficult SQL test. They give you tables with the data on a paper and asks you questions. Either you crack the test or no, they will call you for the 1st 1:1 round. Questions from the written test. 1. How to generate data from two or more table without using sub-queries? 2. Cross Join, Left Join and Right Join? 3. How to get rank/position of John? etc.. 2nd round with the panel 1:1 on the same day: Asked about my background, my past work culture and responsibilities that I had, I cleared this round and was asked to wait for 3rd round. 3rd round 1:1 with a senior manager it seems and this will be the deciding round a) General walk-through on my profile b) Gave me a business scenario/case, where I should start questioning the interviewer to collect information/requirements c) Asked about BRD/FSD/SRS, what is not covered on BRD/FSD/SRS? e) How do you initially gather the requirements? f) What are the techniques that you use personally to gather requirements? g) How well are you with data/SQL? h) Rate yourself between 1 to 10 on sql?

what will be components of BRD for amazon what will be frs and nfrs for an amazon app Sql question , how will you create a backup table for existing table question on count.