1st round was like multiple choice questions with 2 coding questions which were easy and medium , their main role segregation was based on marks scored in the subject wise sections. there were 12 sections like oops sql python , visualization , linux ,etc. I think i got BIE role based on my marks being higher in visualization and data handling and sql and python . Then i had my 1st technical interview rescheduled 3 times and they finally took it after a month . The question were asked on sql and were needed to be coded and deep dive on resume project from my previous internship , and then many scenario based questions where i had to answer on ETL and data warehousing concepts. Overall it was good, Then i have utilized the "ask me any question" very well that when i asked them the question to indirectly tell about what they looking for in me and what satisfied them and what discontent they found, she answers whole heartedly , and even revealed that i did good and will have 2nd round news to be heard from thier hr. then 2nd round happened where it was more deep dive into dashboards and business acumen , like he was testing my data analysis and BIE specific things , he asked many senarios which i answered well. the same indirect question i used at end to make him reveal about his feeling on me , he straight up answered it very well, like a well wisher and told that he have certain restriction but will try to speak within bounds and told me how they usually hire outside people and what they looking in intern and how conversion may happen and on what basis , and he told only mistake that i made in whole interview , he said rest all is fine but i jumped to analysis part in case of a crisis or alegation question where i had to answer how would i react, there 1st step was to step back and question where it happened, instead i spoke like i would step back and get to analyze and spoke on my pipeline approach . when i inquired on what to prepare for next round he was like i dont know what other rounds may have, ill let you know via hr and he told that you wont be selected if there is someone better than you when he was speaking about satisfaction and disatisfactions in me. So thats it man,... this is how it happened.. its been a day didnt hear from them yet ..lets see, good luck in your prep!