WRITTEN TEST: 

Written Test

• MCQs on Data Interpretation Topics
• Graphs
• Paragraphs
• Logical Reasoning
• Maths

GROUP DISCUSSION: NO

SKILLS REQUIRED

• Excel
• SQL

INTERVIEW GUIDELINES

Round 1 : Technical Interview

• Questions about the candidate
• Previous projects and internships
• Questions related to the profile
• Resume based questions
• Puzzles
• Guesstimates

Questions

• What do Business analysts do? Why are you interested in this profile?
• Walk me through your resume.
• If I ask your professor to describe you, what attributes will he use for you.
• PUZZLE: If you have 9 coins in hand, and out of them 1 weigh less, in how many steps can you identify the odd coin. Describe the procedure.
• Tell me your approach to identify the number of laptops sold in Delhi per day. Give a rough figure.
• Do you know how to compute Macros?
• What are your capabilities within Excel?
• How do you price a product?
• Do you know how to update BRD and FSD?
• How can a business analyst contribute to the company's growth?

Round 2 : Managerial Interview

• Checks communications skills

Questions

• How will you improve the IT processes in a supply chain environment which you are unfamiliar with?
• How will you add value to the organization?
• Mention two products and services that dell provides.
• Tell me a time when you made profitable business process improvement.
• Write an algorithm for any type searching method.
• How to apply join , union and other sql query programming techniques.
• Difference between Vlookup and Hlookup.
• SQL: Explain join in detail with examples.
• List out the documents generated for a project's life cycle.
• What are the elements of defining functional requirements?

Round 3 : HR Interview

• Basic HR questions to get to know the candidate
• Guesstimates

Questions

• What are your strengths and weaknesses?
• Justify that you have leadership skills.
• Describe how you handled pressure and deadlines in your previous job and what was the outcome?
• What will be your approach to calculate the number of rotis consumed in India everyday?
• Tell me about any incident where a client was angry at you and how did you handle that situation?
• Do you know anything about the insurance process?
• How will you manage your emails?
• How will you handle any process improvements?
• What was the most challenging thing you did?
• Where do you see yourself in another 5 years?

MPLOYEE.ME TIPS

• Indept knowledge of Excel is important while VBA/Macros would give an edge
• Use STAR appraoch to answer behavioural questions \