J'ai postulé via la recommandation d'un employé. Le processus a pris 3 semaines. J'ai passé un entretien chez Fractal en janv. 2025
Entretien moyen
Candidature
J'ai postulé via une agence de recrutement. Le processus a pris plus d'une semaine. J'ai passé un entretien chez Fractal en oct. 2020
Entretien
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
Questions d'entretien [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?
I applied through a referral and went through the following interview process:
1. Technical Round (1 hr 15 mins) – Covered SQL (medium difficulty), Python (easy), PySpark (easy), and many many many Azure-related questions. They also asked basic Power BI concepts.
2. Apex Interview (35 mins) – Focused on scenario-based questions, Spark internals, and a basic discussion on AI/ML.
3. Hiring Committee (HC) Interview (30 mins) – HR discussion, soft skills, and situational questions.
Each interview was scheduled exactly one week apart.
Questions d'entretien [1]
Question 1
Why Fractal when I was already having offer from other MNC.
J'ai postulé en ligne. J'ai passé un entretien chez Fractal
Entretien
My overall interview process happened for 2weeks- Initially I have given 2technical rounds of interview on the consecutive days. Post that I gave online assessment test which covers SQL, python and spark and after that I have completed my HR round. Overall the interview process was smooth and HR was approachable throughout the process.
Questions d'entretien [1]
Question 1
Scenario based SQL and pyspark question Questions in cloud services
J'ai postulé en ligne. Le processus a pris 3 jours. J'ai passé un entretien chez Fractal (Bengaluru) en sept. 2021
Entretien
It was one technical round followed by a management round.
Over all it was a good discussion. They mainly focused on the technical abilities of Data Engineering, ETL and Data warehouses etc.