I applied online. The process took 2 months. I interviewed at Fractal (Pune)
Interview
online test based on MCQ and Coding on SQL Python, Spark and Cloud
2 Tech Discussions based on projects and basic data tech stack
Some SQL and python related questions asked in interview
Interview questions [1]
Question 1
Explain spark architecture
Previous projects and roles and responsibilities
SQL questions on window functions
Cloud related questions
It was a three-round process, excluding the HR round. There were two technical rounds (testing Python > SQL > SPARK) and one techno-managerial round with the hiring manager. In this round, they went in-depth into your projects and the tech stack you have worked on, from basics to scenario-based questions.
Interview questions [1]
Question 1
About SQL joins and it's respective output. Spark architecture and how it works.
Case studies and Coding . Behavioral questions as well
It is good.
I prepared case studies from Case interviews Cracked youtube channel.
For COding its Python & SQL. For Behavioral, Its basic strengths & weaknesses. The tough time you had faced..etc
It contains 2 rounds of technical.
1st is average 2nd is managerial with technical.
Questions werw majorly the definitions and its use case on the theory side however practical designing questions and python was expected to be more strong
Top companies for "Compensation and Benefits" near you
