Humberger Nav
mployee.me logo
company image

DELL

Business Analyst

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 \

Get a resume professionally written and optimized for ATS!

OTHER PROFILES OF YOUR INTEREST

Career Blogs

Our career blog is your go-to resource for insightful advice, practical tips, and the latest trends in the job market.