I applied online. I interviewed at Fractal (Bengaluru) in Nov 2021
Interview
first one HR called and asked to take a test , took and cleared it then no response , few days later got email to take same test , replied i have already taken , then asked to take another test , cleared it too then again HR disappeared
another HR appears , who does not understand basic tech terms does not understand ETL, DW says you have ETL exp but no data engineering exp again disappear and ask to take test after I said I have cleared it disappeared again then after 2 days HR calls and same questions are repeated , the HR asks "Have u applied for other companies" I said "yes " call is abruptly ended and no communication there after , what a waste of time and so much unprofessional HR does not even know how to talk, what is candidate status , what rounds/tests have taken , HR are clueless and totally unprofessional , no response on follow up as well
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