I applied through a staffing agency. The process took 1+ week. I interviewed at Fractal in Oct 2020
Interview
In my case there were 5 rounds:
1. Written test (SQL test)
2. Technical interview
3. Technical/managerial interview
4. Cultural fit round(HR round)
5. Business round
First round:
Basic and advance SQL questions
Second round:
Asked questions on the project architecture and explain the corner cases.
Third Round:
Asked me on project architecture, testing, performance tuning
Fourth round:
Asked some experience based questions for cultural fit
Fifth round:
Asked about project. Why fractal . Client engagement etc
At last, thanks to Rachna patel,vidhi Mehta for making the process smooth which completed whole process within week
Interview questions [1]
Question 1
1. What is index
2. Types of index
3. Operation effecting performance of index
4. Where vs inner join
5. Fuzzy logic
6. Azure databricks functions
7. Why spark?
8. Why do memory issue arise?
9. What is partition and bucketing?
10. In which scenario partition is neglected and bucketing is suitable?
11. What is small file issue in hive?
12. In which cases dynamic partitioning is suitable?