PISOFTEK Senior BI Analyst Interview Questions and Answers

Round: Puzzle Interview
Experience: A puzzle was asked first.
I was then given a case study : You own a telecom company. You have various customers. They have joined you 3 years ago,6 months ago and some recently. How do you define who is a good customer?

Round: Other Interview
Experience: It was only for 15 minutes. I was asked a question related to boy girl paradox. Then the job was offered.
Tips: Be cool and try to be less nervous. Do not try to speak about the things that you have no idea about

General Tips: Go to the interview with a cool mind. Take a trusted person with you if you are shortlisted on day 1.
College Name: IIT KANPUR

Round: Resume Shortlist
Tips: Resume building is the most important of all steps. Keep it concise and to the point.

Round: Test
Experience: Puzzles
Tips: Practice as many puzzles as possible

Round: Stress Interview
Tips: Keep your cool, divert interview towards your strong zones

Round: Technical Interview
Experience: Guesstimates (basic level) and puzzles. Also know your resume and courses well

General Tips: They want to check your thinking, try every problem given in interview. They would have simple solutions.
Skills: Critical Thinking
College Name: IIT DELHI
Motivation: Application of statistics

Round: Resume Shortlist
Experience: There were 3 Job profiles open of opera solutions (Solution Analyst, Analytics Specialist, and Software Engineer). Students are asked to sign just for one profile. There was a test for analytics and software profile and direct interview for solution profile (Consultant profile).
Tips: Spend enough time before choosing the profiles. Spoke to senior who had a similar job and figure out your best suitable profile and prepare accordingly.

Round: Test
Experience: Opera solution conducts workshop for shortlisted candidates. In the workshop, they mostly tell about technical part behind big data management such as Mainframe and Hadoop. After the workshop, the test was conducted. The test had two sections, the first section contains objective questions around 20-25 (I did not remember the exact number). Objective questions were of aptitude type (moderate level of difficulty). The second section contains 5-6 subjective questions, mainly focus on probability again the moderate level of difficulty. 30 students were shortlisted for next round (interview round).
Tips: Start preparing as early you can. Practice problem daily does not wait for last few day. The main point of practice is to develop a habit of increasing accuracy and speed which is the crucial points of aptitude test.
For probability practice, there are online website and blogs you can take help from them. I have listed down some which are used. You should have some prior practice before setting for test otherwise, it would be difficult to do well in the test as some questions are tricky and difficult to solve in the first time.
For aptitude practice, you can refer TIME material, I think that is sufficient.

-----/
-----.shtml
-----
-----.html

Duration: 60 min minutes
Total Questions: 20+5

Round: Guesstimate Interview
Experience: The interviewer first goes through my resume and ask some basic question, not in depth. Then he asked me some puzzle (similar type of question asked in the subjective paper but with a high level of difficulty) and one guesstimate.
My interview last for 10-15 mins, the interviewer is very helpful and always try to calm and comfort me.
The interviewer gave me feedback and point out some area on which I can quickly look it for further interview.

Tips: I have assigned a buddy, IIT graduate having the same specialization. (Opera solutions follow buddy program similar of other consultant company). I personally found out buddy program very useful, you should contact your buddy or at least talk to him ones. The information you get from a buddy is very helpful of preparing for an interview. You get some aspect on which domain you need to work.

Round: Technical Interview
Experience: Next round was the telephonic interview with a senior analyst. The interviewer asked me some question from my resume especially on the technical project which involves some mathematics tool.
Then he asked some probability problems which are very tough.

Tips: The interviewer was interested in your approach only, how you’re tackling the problem. How much wide can you think? The interviewer is also ready to help you and try to figure out your strength. So be calm and speak with confidence.

Round: Stress Interview
Experience: The interviewer asked me some question from my resume in depth.
He asked one guesstimate and one probability question.

Round: Behavioural Interview
Experience: The interviewer started with questions like why this company, which other companies did I appeared for.
He asked me some quick calculation problems.

General Tips: Resume: Spend sufficient time on the resume as I was the initial step of shortlisting.
You be able to speak at any point in your resume in detail, hence you must be sure of what you are writing in it.

Puzzle: Practice Daily

Guesstimate: Practice with your sincere friends
Skills: Ability To Make Quick Calculations, Puzzle Solving Capability, Knowledge Of Your Resume Points, Guesstimation Cases, Probability And Statistics
College Name: IIT Bombay