Collegedunia Business Analyst Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 17 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Collegedunia.
Collegedunia
Business Analyst
Entry Easy Positive experience No offer 2 rounds
Interview process
Recruiter call Onsite
Interview formats
Technical Behavioral
HR reached out to me via Naukri, and we scheduled the interview for two days later. It was a face-to-face interview in Gurgaon, as they were hiring in large numbers then.
Confirmed questions3 questions
- What is the difference between Vlookup and Index Match?
- Can you explain how to use a CASE statement in SQL?
- Tell me about the projects you worked on in your previous role.
Collegedunia
Business Analyst
Entry Average Neutral experience No offer 2 rounds
Interview process
Recruiter call Technical screen Onsite
Interview formats
Technical Behavioral
I interviewed at Prashant Vihar office. It began with a very easy aptitude test that had 5 simple questions and lasted for 1 hour, which was plenty of time. Following that, there was an interview where they asked about my campus placement experiences, my personal goals, and some questions based on my CV.
Confirmed questions5 questions
- Can you tell me about your internships?
- Imagine you're in a hallway with three light switches (all off) and a room with three incandescent bulbs. Each switch controls one bulb, but you can't see the bulbs from the hallway. How can you determine which switch controls which bulb if you can only enter the bulb room once?
- How can you arrange 10 coins to form 5 straight lines with 4 coins on each line?
Collegedunia
Business Analyst
Mid Average Positive experience Accept offer 3 rounds
Interview process
Recruiter call Technical screen Onsite Background check Offer
Interview formats
Behavioral Technical
The hiring process was incredibly smooth and well-communicated. The interviews were structured, and the assessment was good. Results came back the day after the final interview, which helped reduce stress.
Confirmed questions3 questions
- Can you share details about your past work experience?
- Please describe your educational background.
- What are your aspirations for the future?
Collegedunia Business Analyst Interview Questions
Quoted word for word from Collegedunia interview reports.
“A camel owner needs to transport 3000 bananas to a market 1000 km away across a desert. The camel can carry 1000 bananas at a time and eats one banana per km. What's the maximum number of bananas that can reach the market?”
Read reports →“What is the difference between Vlookup and Index Match?”
Read reports →“How can you arrange 10 coins to form 5 straight lines with 4 coins on each line?”
Read reports →“A bartender tells a customer that the product of his three children's ages is 72. The customer needs more info. The bartender then says the sum of their ages is the building number outside. The customer still can't figure it out. Finally, the bartender mentions his youngest child loves strawberry ice cream, and the customer knows the ages. What are the children's ages?”
Read reports →“Imagine you're in a hallway with three light switches (all off) and a room with three incandescent bulbs. Each switch controls one bulb, but you can't see the bulbs from the hallway. How can you determine which switch controls which bulb if you can only enter the bulb room once?”
Read report →“Can you do a guestimate for me?”
Read report →“Can you explain how to use a CASE statement in SQL?”
Read report →“Tell me about the rope puzzle.”
Read report →“What is your current Cost To Company (CTC)?”
Read report →Formats, difficulty and experience
Across all 17 Collegedunia interview reports.