I applied online. The process took 3 weeks. I interviewed at Fractal in Sept 2021
Interview
They first sent an aptitude test (difficult) and SQL(average) assessment. I then spoke to the recruiter, who scheduled a technical round the very next day. Of the three people who were supposed to interview me only one showed up ten minutes late and they did not turn on their camera. I was told I would hear back within the week, but I had to email the recruiter three times over the course of three weeks to get an answer.
Interview questions [1]
Question 1
Explain the projects on your resume.
Which technologies are you interested in.
A few questions on database technologies
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
