Associate Analyst – Undergraduate
– Science (BSc & BCA)
Technical / Domain Questions
IT & Technical Knowledge
·
What is the difference between structured and unstructured data?
·
Explain the concept of databases and how normalization
works.
·
What is the difference between SQL and NoSQL databases?
·
Explain the concept of cloud computing and its
advantages.
·
What is ERP (Oracle/SAP) and how does it support business processes?
·
What is the difference between front-end and back-end
technologies?
Programming & IT Foundations
·
What is the difference between compiled languages (like
C/C++) and interpreted languages (like Python)?
·
Can you explain object-oriented programming concepts
such as inheritance and polymorphism?
·
How would you debug a program that is not giving the expected output?
·
What are the advantages of using Java for enterprise
applications?
Databases & SQL
·
How would you write a query to find duplicate records
in a table?
Networking & Cybersecurity
·
What is the difference between TCP and UDP protocols?
·
Explain the concept of IP addresses and subnetting.
·
What are some common cybersecurity risks companies face
today?
·
How would you secure sensitive client data in a global
environment?
Analytical & Problem-Solving
·
Suppose you are given a dataset with missing values —
how would you handle it?
·
How do you ensure accuracy when analyzing large datasets?
Technology & Tools
·
Explain the role of pivot tables in financial or
business analysis.
HR / Behavioral Questions
Self & Background
·
Why did you choose BSc/BCA, and how does it prepare you
for this role?
Motivation & Fit
·
Why do you want to join Deloitte over other IT/consulting firms?
·
What interests you about the Associate Analyst role?
Communication & Interpersonal Skills
·
Tell me about a time you had to explain a technical concept
to someone without a technical background.
·
How do you ensure effective communication when working with global
teams across different time zones?
Behavioral & Situational
·
Describe a situation where you identified an area for process
improvement.
·
Deloitte emphasizes client centricity. How would you
demonstrate this in your work?
·
How do you ensure process adherence while meeting
deadlines?
Preparation Tips
·
Brush up on basics: SQL queries, normalization,
networking concepts, cybersecurity.
·
Programming practice: OOP concepts, debugging, differences
between languages.
·
Excel skills: Pivot tables, macros, VLOOKUP.
·
ERP awareness: Oracle/SAP basics.
·
Mock HR answers: Use STAR method (Situation, Task,
Action, Result).
·
Global mindset: Be ready to talk about working
across time zones and diverse teams.
Associate Analyst - BBA/BBM/BMS/BFS/B.Com
Technical / Domain Questions
Accounting
& Finance Basics
·
What is the difference between a
cash flow statement and a fund flow statement?
·
Pass the journal entry for
outstanding expenses.
·
Explain the concept of deferred
tax assets and liabilities.
·
What are the differences between
direct and indirect taxes?
·
How do you calculate taxable
income from financial statements?
·
What are the key components of a
financial analysis and reporting framework?
·
How would you approach a business
valuation for a client?
·
What is the role of cost
accounting in decision-making?
·
How do financial markets and
institutions impact corporate finance decisions?
Taxation
& Compliance
·
What are the current income tax
slabs in India?
·
Explain the concept of GST and
how input tax credit works.
·
What is transfer pricing and why
is it important?
·
How do you ensure compliance with
tax regulations?
Business
Mathematics & Statistics
·
How would you use statistics to
identify trends in financial data?
·
Can you explain the concept of
correlation vs. causation in business analysis?
·
Give an example of how business
mathematics supports financial decision-making.
Analytical
& Scenario-Based
·
Suppose you find a mismatch
between reported income and tax filings — how would you handle it?
·
A client challenges your
calculation of taxable income. How do you respond?
·
You are given incomplete data for
tax computation. What steps would you take?
·
Describe a situation where you
identified an area for process improvement.
·
How do you approach solving
problems when you don’t have complete information?
·
Give an example of a time you
used analytical skills to make a recommendation.
Technology
& Tools
·
How would you use VLOOKUP in
Excel to match employee IDs with tax data?
·
What are macros in Excel? Can you
give an example of how they help in repetitive tasks?
·
How do you ensure accuracy when
working with large datasets in Excel?
·
What is the role of pivot tables
in financial analysis?
·
How would you prepare a client
presentation using PowerPoint?
·
Do you have any exposure to ERP
systems like Oracle or SAP? How do they support financial reporting?
HR / Behavioral Questions
Self
& Background
·
Could you please introduce
yourself?
·
Share something about yourself
that is not mentioned in your resume.
·
Why did you choose BBA/BCom, and
how does it prepare you for this role?
Motivation
& Fit
·
Why do you want to join Deloitte
over other Big Four firms?
·
What interests you about the
Associate Analyst role?
·
Where do you see yourself in 5
years?
Communication
& Interpersonal Skills
·
Tell me about a time you had to
explain a complex financial concept to someone without a finance background.
·
How do you ensure effective
communication when working with global teams across different time zones?
·
Give an example of when your
written communication made a difference in a project.
Behavioral
& Situational
·
Tell me about a time you worked
under pressure and delivered results.
·
Describe a situation where you
worked in a team to solve a problem.
·
How do you stay updated with
changes in tax laws or accounting standards?
·
Deloitte emphasizes integrity and
collaboration. How would you demonstrate these values in your work?
·
Tell me about a time you showed
attention to detail in a project.
·
How do you ensure process
adherence while meeting deadlines?
Preparation Tips
·
Revise basics: Financial accounting, management
accounting, cost accounting, valuation.
·
Excel practice: VLOOKUP, pivot tables, macros —
Deloitte often tests these.
·
ERP awareness: Even basic knowledge of Oracle/SAP
is a plus.
·
Mock HR answers: Use STAR method (Situation, Task,
Action, Result).
·
Global mindset: Be ready to talk about working
across time zones and diverse teams.
.png)
0 Comments