Candidate Information:
- Status: Selected for the Imagineer Role
- Experience: Fresher
- Target Position: Imagineer
- Location: VIT Chennai (On-Campus Hiring)
- Interview Date: 2026
Overview of Interview Process:
Fractal Analytics visited our campus for the Imagineer role. Students first received an email from VIT inviting eligible candidates to apply.
The primary eligibility criterion was a CGPA of 8.0 or above. Eligible students from all VIT campuses (Vellore, Chennai, AP, and Bhopal) were invited to attend the Pre-Placement Talk (PPT).
After the PPT, candidates appeared for an online assessment. Based on the assessment performance, a shortlist was announced for the interview rounds. I was fortunate to be shortlisted and eventually selected.
The complete recruitment process consisted of:
- Pre-Placement Talk (PPT)
- Online Assessment
- Technical Interview Round 1
- Technical Interview Round 2
- HR Interview
Initial Screening (Online Assessment)
Duration: Approximately 90 minutes.
Mode: Online (Proctored)
Assessment Pattern: The assessment consisted of multiple sections.
Aptitude
The first section contained aptitude questions covering quantitative aptitude, logical reasoning, and analytical thinking.
One interesting part of the assessment was that I was asked to explain one aptitude question through a live video recording, where I had to explain my approach and reasoning instead of simply selecting an answer.
Technical Section
The technical section included questions from:
- Python
- Java
- SQL
- General programming concepts
The final SQL questions required writing complete SQL queries instead of selecting multiple-choice answers.
After completing the assessment, the shortlisted candidates received interview invitations the following day. I was happy to be among those selected.
Technical Interview Round 1
Duration: Approximately 45 minutes
Mode: Online (HackerRank Interview Platform)
The interview started with the common introductory questions.
The interviewer asked:
- Tell me about yourself.
- Explain one project from your resume.
- Questions about APIs used in my project.
- Difference between Relational Database and Non-Relational Database.
- Questions related to technologies mentioned on my resume.
After discussing my projects, the interviewer moved to SQL.
The interviewer created a sample table during the interview and asked me to write SQL queries on the shared HackerRank editor.
SQL Question 1
Find the maximum amount spent.
SELECT MAX(amount_spent) AS most_spent_amount FROM customers;
SQL Question 2
Find the customer who spent the highest total amount during August 2025.
SELECT customer_id, SUM(amount_spent) AS total_spent FROM customers WHERE MONTH(date) = 8 AND YEAR(date) = 2025
GROUP BY customer_id
ORDER BY total_spent DESC
LIMIT 1;
SQL Question 3
Find customers whose total spending in August 2025 exceeded 10000.
SELECT customer_id,SUM(amount_spent) AS total_spent FROM customers WHERE MONTH(date) = 8 AND YEAR(date) = 2025
GROUP BY customer_id
HAVING total_spent > 10000;
After writing each query, the interviewer did not stop there. He asked me to explain every line of the query.
Some follow-up questions included:
- Why did you use GROUP BY?
- Why is ORDER BY required?
- Why did you use HAVING instead of WHERE?
- Explain the execution flow of the query.
Since I understood SQL concepts well, I was able to explain every statement confidently.
The interviewer also asked:
- One Python coding question
- Basic database questions
- Project-related questions
Finally, I was asked two guesstimate questions.
Guesstimate Questions
- How would you fit cricket balls inside an airplane?
- Estimate how many Domino's pizzas are ordered in Chennai in one day.
The purpose was not to arrive at the exact answer but to evaluate structured thinking, assumptions, and problem-solving ability.
After this interview, I received an email stating that I had been shortlisted for the next round.
Technical Interview Round 2
Duration:Around 20-25 minutes
Mode: Online
This round was completely focused on my projects.
The interviewer asked me to explain one of my major projects in detail.
Topics covered included:
- Project architecture
- Technology stack
- Backend implementation
- Database design
- Deployment process
- APIs
- Challenges faced
- Future improvements
The interviewer went through almost every major module of my project and asked why I implemented certain features in a particular way.
Since I had built and deployed the project myself, I was able to explain every component confidently.
My Suggestion
Do not simply copy projects from GitHub or YouTube.
Build your projects yourself, understand every line of code, deploy them, and know why each component exists. Interviewers can easily differentiate between candidates who genuinely built their projects and those who only memorized them.
I successfully cleared this round as well.
HR Interview
Duration: Around 20 minutes
The HR interview mainly focused on communication skills, teamwork, and behavioral questions.
Some questions included:
- Tell me about yourself.
- Explain one project in simple terms.
- Why Fractal Analytics?
- Tell me about your hackathon experience.
- What extracurricular activities have you participated in?
- Describe a challenging situation and how you handled it.
- How do you work in a team?
Unlike the technical rounds, the HR discussion emphasized real-world experiences, communication, and problem-solving rather than technical depth.
The interview was friendly and conversational.
Post-Interview Reflections:
Company Culture Insights:
Throughout the interview process, all interviewers were friendly and encouraging. They focused on understanding my thought process rather than expecting memorized answers.
Work Environment:
The overall recruitment process was well organized, and every interview was conducted professionally.
Evaluator Feedback:
The interviewers appreciated clear explanations and logical thinking, especially while discussing SQL queries and projects.
Suggestions for Future Candidates:
- Prepare SQL thoroughly, especially GROUP BY, HAVING, ORDER BY, aggregate functions, and joins.
- Build projects on your own and understand every implementation detail.
- Revise Python fundamentals.
- Be prepared for project discussions because interviewers may ask questions from any part of your resume.
- Practice guesstimate questions and explain your assumptions clearly.
- During HR interviews, focus on communication and real-life examples.
Additional Information:
- Candidates who successfully cleared all three interview rounds were informed that they had been selected for the Imagineer role.
- The next step involved completing the Pre-Onboarding Training Program (approximately 12 weeks). Successful completion of this training is required before receiving the final offer letter and joining date from the company.
Closing Note:
Overall, my interview experience with Fractal Analytics was excellent. The process tested technical knowledge, project understanding, SQL skills, analytical thinking, communication, and problem-solving ability.
If you are preparing for the Fractal Analytics Imagineer role, my advice is simple:
- Master SQL.
- Understand your projects thoroughly.
- Practice explaining your solutions clearly.
- Stay calm during guesstimate and behavioral questions.
These areas played a significant role in helping me secure the opportunity.
I hope this interview experience helps future candidates preparing for Fractal Analytics. Best of luck!