It was a nice process and experience though I could not join for some reasons but would love to join them if I get another chance and interviewers were too good
Interview questions [1]
Question 1
Questions based on latest technologies like Python,SQL,Spark
I applied online. The process took 2 weeks. I interviewed at Fragma Data Systems
Interview
Great interview experience. Started out with a 30 or so minute interview with HR. Recruiter asking me standard questions regarding experience. Once I passed that interview, I had a phone interview with the leading manager of the team. After that, I had two interviews; a video interview with a senior manager and a phone interview with a team member
I applied through a recruiter. The process took 1 week. I interviewed at Fragma Data Systems (Bengaluru) in Apr 2021
Interview
It was the best interview experience I ever had.
First Round: Handson on Spark, Python and SQL including multiple choice questions.
I could not answer a question so I thought I will be rejected for sure. I received a call from HR after 2 days telling me we will start your interviews next week.
Round 2: It was a mixed bag including scenario-based, basic questions, twisted questions, handson questions. I answered most of them. HR called me after an hour telling me you are through to the next round.
Round 3: It was conducted on the very next day. I was given questions to write codes. It went well. HR called me immediately after the round telling me you have been selected, we would like to extend an offer. But she called to say post-lunch that you will have one more technical round with the CTO.
Round 4: I was nervous for the CTO round which was conducted a day after that. I answered all the questions except one. The interviewer was extremely polite. He asked me to stop the screen, go through online resources and come up with a solution. I couldn't write the entire code but I was able to tell the approach.
Honestly, speaking I didn't expect I cleared the round. But HR called immediately telling me you are through to the last discussion with the client.
Round 5: After clearing 4 rounds, I was a bit more confident with the last round. The client asked me basic questions on Spark and Python. Then we discussed my last project. He explained to me the end-to-end flow of the project. It was a great project.
2 days post the last round I got a call from the HR telling me that they will extend me an offer and her senior will call me. They gave me the exact expected salary without deductions.
Unfortunately, due to unavoidable circumstances and sheer bad luck I had to decline the offer.
But in the future, if I ever get an opportunity again I will be extremely happy to work with Fragma again.
Interview questions [1]
Question 1
Round 1: Handson on Spark, Python and SQL including multiple-choice questions.
Round 2: It was a mixed bag including scenario-based, basic conceptual questions, twisted questions, handson questions.
Round 3: Coding questions on Spark.
Round 4: Scenario-based questions and coding questions like extracting JSON using Spark.
Round 5: Basic and scenario based questions on Spark. Discussion on my projects.