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
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.
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