Questions was asked on below topics
1. Previous Project Explanation
2. Complex SQL query - join,group by and windows
function
3. Basics of Spark
4.Optimisation used in Spark
5. Experience in AWS services - s3, Lambda and Glue
I applied online. The process took 2 weeks. I interviewed at SymphonyAI (Bengaluru) in Dec 2023
Interview
2 round interview process one is technical and the second one is with technical lead and the last one with HR to discuss the salary component.
Interview experience was not bad but compensation discussion is not expected.
I applied through a staffing agency. The process took 1 day. I interviewed at SymphonyAI (Bengaluru) in May 2020
Interview
Supposedly 3 rounds , starting with first round with senior person. The senior person's had nothing to discuss, nitpicking on the resume, instead of being helpful they were suspecting. bad experience.
Interview questions [1]
Question 1
1st round.
1. Where was your previous office in that city.
2. where you lived in that city.
3. the dates of your previous job doesn't sound correct, can you please check.
4. why you left your previous job.
5. overall time pass questions with no substance.
6.one sql question, which i could not answer completely but interview doesn't depend on 1 answer, is it?