Walk in Intwerview followed by a group disscussion and later on followed by a online test which included maths resoning and english questions-next was the OPS round followed by salary disscussion
Interview questions [1]
Question 1
General Behavioural and Some industry based questions
In their JD they have written something and during interview their requirement was completely different which was not inline with the Job description. When i checked with HR who the JD is different from the interviewer requirement they donot have the proper answer.
Two rounds of interview. First round technical with SQL problems. Second round also technical but with BI tools and SQl. Each interview was for 30 mins and the results were out pretty soon.
Interview questions [1]
Question 1
write an SQl code to find second highest average salary
Interviewed for Business analyst, they asked few sql queries, and to explain projects, few questions on optimization techniques, sql optimization, etl process, python eda process, brief about domain knowledge etc