I applied through other source. The process took 3 days. I interviewed at EWar (Bengaluru) in Sep 2021
Interview
There were 2 rounds in total
1) You will get some queries for which you will have to write sql code using Joins, union, Aggregate function
2) This was easier than the first one and was telephonic and will focus on your previous experience and theoretical question related to your skills
Interview questions [1]
Question 1
1) Differenece between subqueries and temporary table
2) All date Function( how to get yesterday's date)
3)What is Json data type?