ZS Associates Business Technology Associate interview questions

I had applied online on their website and got a call for a screening interview with the HR. ---the screening process was straightforward from the resume and they just wanted to check if my resume matches the requirement that they have After a few days i got a call for a first round interview ----this interview was two part telephonic and thru webex the telephonice round was all behavioral (you can note down the questions asked in this forum to be well prepared for it the second part was on webex where they give you a case, it was not technical but they wanted basic sql knowledge as normalization and how would u better the data they have provided. it was straightforward. then i got a call for an onsite interview in San mateo ---it consisted of 3 interviews Analytical-- it is based on your resume but its more detailed and they want to know how your experience matches with the opening they have....they dive deep into your resume to see if you have that experience they are looking for, so prepare your resume well the second interview was with a principle and was behavioral( again make a note of all the questions mentioned here they ask from the same lot of questions) after that i had a lunch with an employee this was casual but you should show your interest about the company and ask a lot of questions. After that was the main case interview which lasted for 45 mins, they first give you a case and let you go through it for the first 15 mins and then a consultant comes in and asks you questions on that. tip- learn KPI's for every domain and how would you build reports which will be helpful for the managers to make decisions.