I applied online. The process took 2 weeks. I interviewed at Fractal (New Delhi) in July 2021
Interview
Overall there are four rounds.
1. Online test
2. Technical round
3. Case study round
4. HR round
All the interviewer are good. They help in interview rounds, talk friends ... Make me feel comfortable. Just almost all interviewer are late by 5-10 min but that's fine if got overall good result.
First round, online round is based on SQL and Aptitude
Then technical round , questions are based on SQL, Python ( Interviewer asked me that if I am comfortable) and Excel
On SQL , questions are on Join, Set operation, Windows function . Excel , questions are on function , VLOOKUP advantage and Disadvantage .
Then Case study round, she give me a scenario and want me to think and tell her how to make profit for Business from that case study.
Lastly HR round, It was quite okay okay round . General questions no difficulty at all
Interview questions [1]
Question 1
What is disadvantages of Vlook up and how to overcome that
I applied through university. The process took 1 week. I interviewed at Fractal (Calcutta) in Feb 2024
Interview
There is a 15 min call after shortlist. Interviewer is in a hurry so won't have too much time. There is also 2 more round with HR and Management but I did not get selected for those rounds.
Interview questions [1]
Question 1
Machine Learning Fundamentals, Linear Algebra.Project details
The interview process had 1SQL test, 2 technical interviews and an HR round. The SQL test was divided into two parts: MCQ and Queries section in which you have to write queries and run. You can brush up SQL and python for the technical rounds. Study subqueries and window functions.
I applied online. The process took 4 weeks. I interviewed at Fractal
Interview
HR sent me 2 long assessments as first contact. I asked basic follow-up questions about salary, location, and technology. The HR rep responded that my questions would not be answered until I completed the assignments. Horrible first impression