Fractal Data Engineer Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 69 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Fractal.
Fractal
Data Engineer
Entry Average Neutral experience No offer 1 round
Interview process
Technical screen
Interview formats
Coding Technical Other
they asked me about my projects and since i mentioned javascript, they asked me to write some javascript code. specifically, i was given two arrays and asked to find the matching elements between them. also asked some sql queries and oops questions.
Confirmed questions4 questions
- Tell me about your projects.
- Write Javascript code to find matching elements.
- Can you explain some SQL queries?
Fractal
Data Engineer
Mid Average Positive experience Accept offer 3 rounds
Interview process
Technical screen Technical screen Background check
Interview formats
Technical Behavioral
Applied via referral and went through 3 interviews each scheduled a week apart. The first was a Technical Round (1 hr 15 mins) covering SQL (medium), Python (easy), PySpark (easy), lots of Azure questions, and basic Power BI. The second was an Apex Interview (35 mins) focusing on scenarios, Spark internals, and a bit on AI/ML. The third was a Hiring Committee (HC) Interview (30 mins) with HR, soft skills, and situational questions.
Confirmed questions1 question
- Can you tell us why you chose Fractal given that you already had offers from other multinational corporations?
Fractal
Data Engineer
Senior Average Negative experience No offer 3 rounds
Interview process
Recruiter call Take home Technical screen Recruiter call Phone screen Background check Offer
Interview formats
Technical Coding Behavioral
I got a call from Fractal about two months ago. The HR told me to solve a test, which I did. She called me back and said I cleared it. Then, for a whole month, there was no contact. After a month, another HR from Fractal called and said that since I have more than 5 years of experience, I don't need to take a test and it was a mistake on their part. She's processing my application further. After clearing 3 rounds of interviews, she told me I cleared all interviews and she will get CTC approval and release the offer. I haven't heard from her since last week. So guys, after getting a call from this company, ask them if they are doing any optional hiring.
Confirmed questions1 question
- I can't recall the specific questions asked during the interview.
Fractal Data Engineer Interview Questions
Quoted word for word from Fractal interview reports.
“What is the problem with small files in Hive?”
Read reports →“Could you show how to drop duplicate rows using SQL and PySpark?”
Read reports →“Can you show me how to write partition by in pyspark?”
Read reports →“What is the number of stages created in Spark for reading a file, transforming it, and then writing it to a file?”
Read reports →“In what situations would partitioning be overlooked in favor of bucketing?”
Read report →“If you have a file with data like A, B, C, C, V, G, X, X, how would you implement a solution so that repeated data goes into file 1 and new data goes into file 2?”
Read report →“Can you explain the differences between transformations and actions in Apache Spark?”
Read report →“Can you explain Hive Bucketing and Partitioning and how they boost performance? What other optimizations are possible? Also, what are the different data types in Hive?”
Read report →“Is syntax important for problem-solving and solutioning, or is the approach more important?”
Read report →Formats, difficulty and experience
Across all 69 Fractal interview reports.