in total 3 rounds all technical. mostly around sql, python and spark. in python and sql we need to code on some code editor and run the code. in spark it would be some optimization techniques, databricks
I applied through a recruiter. The process took 2 weeks. I interviewed at Tavant (New Delhi) in Jul 2022
Interview
HR contacted me and then after a basic profile and expectation details, I went through the Tavant interview process.
There were 3 technical and 1 managerial rounds. After clearing all the rounds, they said no budget to previously committed expected CTC.
Please make sure all this things before going through interview process or it will be waste of time.
Interview questions [1]
Question 1
Questions were mostly related to Python, SQL, AWS, ETL, Data Warehousing, Data Architecture etc.
I gave the interview after having read the other reviews here and how much I hated to believe it to be true, it turns out it is.
Interviewer started with questions which were not so relevant and then was least Interested in thrle projects i have worked for. He wanted the answer which he felt were right.
There were instances where my answers were right but he said no your answer is right but is there any other answer to it. This is not how it should be.
It was a video interview and I could hear him mock and laugh at during the interview, this should not be the case.
Someone senior from the team should take the interviews as the junior guys just think they know everything and somewhere there is an ego clash if people of same experience sit on either side of the table
Interview questions [1]
Question 1
Mostly sql related and a few from the primary skill that was mentioned in the resume
