Add office photos
i
Deloitte
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Deloitte Associate Business Analyst - Technology Interview Questions and Answers
Deloitte Associate Business Analyst - Technology Interview Experiences
1 interview found
Associate Business Analyst - Technology Interview Questions & Answers
Abhishek Goyal
posted on 31 Aug 2016
Interview Questionnaire
2 Questions
- Q1. Tell Me About urself?
- Q2. And questions on the things which you mentioned in the Resume
Interview Preparation Tips
Experience: It was Average. Not too easy not much difficult.
Tips: For Mathematical Aptitude prepare from M.Tyra
Duration: 35 minutes
Total Questions: 48
Round: Group Discussion
Experience: They gave us a case study which is related to the disaster management and one of the client came to Deloitte to plan it properly.
We have to give the problem statement and relevant solution.
Round: HR Interview
Experience: It was good. And also it was very easy to crack.
Round: Versant
Experience: This is basically telephonic round. which is basically depends on your english fluency.
Skills: Quantitative Aptitude, Proficiency In English, Basic C/C++, Java Programming
College Name: Sinhgad Institute Of Management
Interview questions from similar companies
Selected
I applied via Referral and was interviewed in Sep 2024. There were 3 interview rounds.
(4 Questions)
- Q1. Past Experience and work I performed in the Data Analytic team
- Ans.
I have 3 years of experience working in the Data Analytic team where I analyzed large datasets to provide insights and recommendations.
Performed data cleaning and preprocessing tasks to ensure data accuracy
Utilized statistical analysis and machine learning techniques to extract valuable information
Created data visualizations and reports to communicate findings to stakeholders
- Q2. Power BI- DAX functions, Refresh Rates, Cardinality, Uses of several graphs, KPIs, Reporting
- Q3. SQL- Uses of several functions, intermediate logics asked, Eg- Finding 2nd highest salary, function of RankX, Window functions
- Q4. Data Cleansing and ways to analyse data
- Ans.
Data cleansing involves identifying and correcting errors in data to improve its quality. Ways to analyze data include using statistical methods, data visualization, and machine learning algorithms.
Identify and remove duplicate records
Standardize data formats and values
Fill in missing values using imputation techniques
Use data profiling to understand data quality issues
Apply data validation rules to ensure accuracy
Util...
(1 Question)
- Q1. Raw data was provided and a proper PBI report was asked to be designed.
(2 Questions)
- Q1. Expected Salary and why you find yourself fitting for the role?
- Q2. Working in a Big4 can be overwhelming at times, how would you deal with it as you have already worked for one.
- Ans.
I would deal with the overwhelming nature of working in a Big4 by prioritizing tasks, seeking support from colleagues, and practicing self-care.
Prioritize tasks based on deadlines and importance to avoid feeling overwhelmed
Seek support from colleagues or mentors to discuss challenges and brainstorm solutions
Practice self-care activities such as exercise, meditation, or hobbies to manage stress and maintain work-life ba
Skills evaluated in this interview
I applied via Campus Placement
(2 Questions)
- Q1. Why do u want to join pwc?
- Ans.
I want to join PwC because of their reputation for excellence in technology consulting and the opportunity to work with a diverse range of clients.
PwC is known for its expertise in technology consulting
I am impressed by PwC's track record of delivering innovative solutions to clients
I am excited about the opportunity to work with a variety of clients across different industries
- Q2. Why consulting?
- Ans.
Consulting allows me to work on diverse projects, solve complex problems, and collaborate with different teams.
Opportunity to work on diverse projects and industries
Ability to solve complex problems and provide innovative solutions
Collaboration with different teams and stakeholders
Continuous learning and professional growth
Exposure to cutting-edge technologies and trends
(2 Questions)
- Q1. What is net present value?
- Ans.
Net present value (NPV) is a financial metric used to evaluate the profitability of an investment by calculating the difference between the present value of cash inflows and outflows.
NPV helps in determining the value of an investment in today's dollars.
It considers the time value of money, where cash flows in the future are worth less than cash flows received today.
A positive NPV indicates that the investment is expec...
- Q2. Tell about porters five forces
- Ans.
Porter's Five Forces is a framework for analyzing the competitive forces in an industry.
Porter's Five Forces include: threat of new entrants, bargaining power of buyers, bargaining power of suppliers, threat of substitute products, and competitive rivalry within the industry.
It helps in understanding the attractiveness and profitability of an industry.
For example, in the airline industry, the threat of new entrants is ...
Interview Preparation Tips
Jatin Yadav
Verabal , Logical Aptitude
English (Vocabulary , Pronunciation)
(1 Question)
- Q1. Sql Questions , Puzzles , Project Discussion
(1 Question)
- Q1. Behavioral Question
Rohan Wadhwa
I applied via campus placement at Dehradun Institute of Technology, Dehradun and was interviewed in Sep 2023. There were 2 interview rounds.
Around 30 questions of verbal,language,aptitude
Topic was OTT VS Cinema
Basic aptitude and coding
(1 Question)
- Q1. What is denormalization and explanation of projects
- Ans.
Denormalization is the process of adding redundant data to a database to improve read performance.
Denormalization involves duplicating data from normalized tables into a single denormalized table.
It can improve query performance by reducing the need for joins and aggregations.
Denormalization is often used in data warehousing and reporting applications.
Examples of denormalization include creating summary tables or addin
(1 Question)
- Q1. Introduction, why ey
I applied via Referral and was interviewed in Oct 2024. There was 1 interview round.
(2 Questions)
- Q1. He gave a guesstimate for 2nd hand car market in India
- Q2. Asked vague case for reducing Cloud cost in a company
Had a lot of basic level questions, nothing particularly worthwhile. Really east and no real need to prepare anything.
The coding round had a leetocode easy level question which you could code in either python or java followed by MCQs regarding SQL as well as SQL query writing.
Interview Preparation Tips
I applied via LinkedIn
(2 Questions)
- Q1. Resume Based questions
- Q2. ITGCS, IT Audit, ITGC and ITAC Testing
Selected
I applied via campus placement at National Institute of Technology (NIT), Durgapur and was interviewed in Sep 2024. There were 2 interview rounds.
45 Question Was There , We Have to Finish All The Question In 60 mINUTES
(1 Question)
- Q1. In Technical Round Technical Related Question Asked , Liek Related to Branch
Interview Preparation Tips
Tell us how to improve this page.
Deloitte Interviews By Designations
- Deloitte Consultant Interview Questions
- Deloitte Analyst Interview Questions
- Deloitte Senior Consultant Interview Questions
- Deloitte Associate Analyst Interview Questions
- Deloitte Assistant Manager Interview Questions
- Deloitte Tax Consultant Interview Questions
- Deloitte Business Analyst Interview Questions
- Deloitte Business Technology Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Technology Analyst Interview Questions
- Technology Consultant Interview Questions
- Information Technology Recruiter Interview Questions
- Information Technology Support Engineer Interview Questions
- Technology Specialist Interview Questions
- Business Technology Analyst Interview Questions
- Associate Information Technology Consultant Interview Questions
- Associate Technology Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
|
Consultant
33.1k
salaries
|  ₹6.2 L/yr - ₹23 L/yr |
|
Senior Consultant
20.8k
salaries
| ₹11 L/yr - ₹42 L/yr |
|
Analyst
14.1k
salaries
| ₹3.8 L/yr - ₹12.6 L/yr |
|
Assistant Manager
10k
salaries
| ₹7.8 L/yr - ₹24 L/yr |
|
Manager
7k
salaries
| ₹15.7 L/yr - ₹52 L/yr |
Accenture
PwC
Ernst & Young
Cognizant
- Home >
- Interviews >
- Deloitte Interview Questions >
- Deloitte Associate Business Analyst - Technology Interview Questions
