There were 2 rounds in my interview. The process started with Aptitude Test round and ended with One-on-one as the second and final round. I applied via Naukri.com and was interviewed in Mar 2022.
Interview questions [1]
Question 1
What do you mean by trade life cycle What are the types of derivatives? What is trade discrepancy?
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