Fractal Consultant Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 101 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Fractal.
Fractal
Consultant
Entry Difficult Positive experience Accept offer 4 rounds
Interview process
Recruiter call Phone screen Technical screen Onsite
Interview formats
Technical Coding Behavioral
It was smooth. I had an interview for the Power BI Developer role. All the scenario based questions like Dax related to calculate, rank function, SQL questions : CTEs, optimizing the queries Python : Writing clean code and able to solve the complex problem
Confirmed questions4 questions
- What drives your passion for joining our company?
- Could you discuss your experience with DAX functions like CALCULATE and RANK in a scenario-based context?
- Can you explain your approach to SQL queries, including the use of CTEs and query optimization techniques?
Fractal
Consultant
Entry Average Negative experience No offer 3 rounds
Interview process
Technical screen Onsite Background check
Interview formats
Technical Case Behavioral
This was a really unique interview! There were 3 rounds: a technical interview, a case study, and an HR round. After finishing everything and sending in my documents, I found out the role was put on hold the day after I finished. Who knows the real reason, but it was a disappointing experience.
Confirmed questions2 questions
- Could you tell me about the visualization project you're currently involved with?
- Can you answer some basic SQL questions and then solve a problem using SQL?
Fractal
Consultant
Mid Average Positive experience Accept offer 3 rounds
Interview process
Take home Technical screen Onsite Background check Offer
Interview formats
Technical Case Behavioral
The interview process at Fractal was quite smooth. After a written test covering Python and SQL (or R & SQL), I went through three interview rounds. The first round focused on my work history, projects, and technical abilities. The second round honed in on business understanding and problem-solving, with potential case studies or guesstimates. The final round was an HR interview to check for cultural fit. My experience was amazing, and Pallavi Kumari was really helpful in guiding me through the application and answering all my questions patiently, which allowed me to concentrate better on the interviews.
Confirmed questions6 questions
- What is your understanding of supervised and unsupervised learning and Text analytics?
- Can you discuss your previous work experience, projects, and technical skills?
- Here's a scenario, how would you solve it?
Fractal Consultant Interview Questions
Quoted word for word from Fractal interview reports.
“What is the valid range for the log of the odds ratio in logistic regression?”
Read reports →“Using the logistic regression equation, how would you compute the probability of an event occurring or not occurring?”
Read reports →“From a database, how would you retrieve the most recent and the first transaction for each customer?”
Read reports →“Can you write pseudocode for a betting algorithm that predicts the outcome of a cricket match?”
Read reports →“Can you explain what a Correlated query is and what a Nested query is?”
Read report →“What are the different factors to consider when sales rates decline compared to the previous month?”
Read report →“When aiming to prevent customer churn, how would you leverage probability from Logistic Regression versus K-means clustering?”
Read report →“Given a brick and mortar store experiencing declining television sales, propose a data analytics strategy to reverse this trend.”
Read report →“Given a scenario where the goal is to target customers for marketing, how would you decide between using K-means and Logistic Regression?”
Read report →Formats, difficulty and experience
Across all 101 Fractal interview reports.