Heliosmedium Bazaar Interview Questions and Answers

Round: Resume Shortlist
Experience: I had a standard resume for this company as per our institute placement cell norms.
They were least interested in my resume. They cared more about your analytical skills rather than on your on campus activities.

Round: Test
Experience: The first round was the written test which had a few questions from data interpretation and some questions that were quite peculiar to the consulting sector as such. Only 24 students got shortlisted for the next round out of close to 350 applicants.
Tips: The cut off for the written test was very high. So ensuring accuracy and attempting all the questions is important.

Round: Case Study Interview
Experience: The next round was the case study round. The case that I was presented with was to calculate the number of hoardings in a metropolitan city with the help of given data. I failed to qualify beyond this round.
Tips: One should prepare for “Guesstimate” type case interviews (where the interviewee is tried to estimate the final answer based on logical deduction and analysis of the given facts) for this company as they give very high emphasis to the performance in the case study interview round.

College Name: IIT ROORKEE
Motivation: Indus Insight is a start-up which uses quantitative analytics to give solution to real life problems encountered in business. The company was founded by an IITB alumnus. It is growing at a fast pace and the best source of information about them was the pre placement talk organised by them.

Round: Resume Shortlist
Experience: I had a standard resume for this company as per our institute placement cell norms.
For a consultant profile, they do look for a consistent academic performance, scholarships, Olympiads etc. So I did make sure to include all my academic achievements in my resume.

Round: Test
Experience: This was the first round and was conducted in October itself, well before the final placement process that begins only in December. The test had 20 questions. All the questions described a particular situation and 4 options describing solutions/implications of the situation were provided. The candidate was supposed to choose one of the 4 alternatives, which according to him, was the best possible answer. From what I recall, there wasn’t much calculation involved. Use of calculator was permitted.
Tips: Attempt all the questions. Be accurate.

Round: Guesstimate Interview
Experience: Around 23 students got shortlisted for the next round of selection process which was held in December.
This round was based on “guesstimate” problems. I was asked to calculate the total annual revenue of McDonalds in India. No other data was given. Use of calculator was not permitted. This interview lasted for about 10-15 minutes.
Some other candidate was asked to estimate the length of roads in Delhi. Another one was asked to calculate the number of road side ads/banners in Delhi.
Tips: Prepare for guesstimate problems and qualitative case analysis.

College Name: IIT ROORKEE
Motivation: Indus Insights is a new company. It had a team of only 6 people when it came for recruiting. Not much information was available on the internet. I did attend its pre-placement talk and that acted as the main source of information about the company and the profile offered.

Interview preparation tips for other job seekers - Think Everything (every possible scenario) and be truthful

Topics to prepare for Thoucentric Consultant interview:

• Power query
• Dax
• Data modelling
• Row Level security
• Visuals
• Reports
• Workspaces
• Work scenarios
• Sql joins
• Indexes
• Views
• Ranking functions
• Identity function
• And some queries on the same

Interview preparation tips for other job seekers - Prepare well, be confident and answer in a way that others can easily understand and keep it short and sweet. Make sure you are giving your best and don't show any attitude which is not good.

Interview preparation tips for other job seekers - Firstly the HR round for the intro, followed by the TL with personality based questions and lastly the presentation based round

Interview preparation tips for other job seekers - Waste Company your zone managers will make work like a dog 360 days you will not have holiday you get holiday after project is over you have start work early in morning 7 and work till midnight 2or 3 this job is waste of time better do another jobs

Interview preparation tips for other job seekers - Please go through the websites and prepare questions for the interviewers