I applied through hreference and got call to be interviewed by the hiring manager, he then asked if i took their aptitude test, i was sent none so he asked me few basic things and seemed to like me because he even asked when can i join if selected. Then after 3 days and one reminded email i got link to take the test. Test needs practice as time is the critical issue there. I don't know what the passing criteria would be but later I come to know they were expecting 100% on the test.

First round： phone screen with some basic sql questions and also some sql coding questions , and some other questions about past experience Second round is with the analytics team through zoom, including coding and business case