Candidatei-me online. Fui entrevistado pela Fractal em mar. de 2022
Entrevista
2 rounds of technical interview. In round 1, about previous experience and projects, Big Data basics, coding question on Python, PySpark and SQL. In round 2, about previous experience and projects and senario based questions on Big data
Perguntas de entrevista [1]
Pergunta 1
1) Drop duplicates rows using SQL and PySpark 2) How many stages are created in Spark for reading a file , transforming and writing to file. 3) Window functions in SQL....
Fiz uma entrevista na empresa Fractal (Bengaluru).
Entrevista
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.
Perguntas de entrevista [1]
Pergunta 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