Code360 powered by Coding Ninjas X Naukri.com. Code360 powered by Coding Ninjas X Naukri.com
Deloitte interview experience Real time questions & tips from candidates to crack your interview

Business Technology Analyst

Deloitte
upvote
share-icon
3 rounds | 3 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 1 Month
Topics: Database management system, OOPS, Pointers, Sql, Java
Tip
Tip

Tip 1 : Focus more on Object Oriented programming language preferably Java 
Tip 2 : Practice SQL queries and DBMS

Application process
Where: Campus
Eligibility: Above 6.5 CGPA
Resume Tip
Resume tip

Tip 1 : Have some good projects in resume
Tip 2 : Mention productive extracurricular activities that you have done.

Interview rounds

01
Round
Medium
Online Coding Interview
Duration129 minutes
Interview date28 Aug 2020
Coding problem0

This round consist of 3 sections - aptitude, reasoning and verbal 
It was scheduled in evening.

02
Round
Easy
Group Discussion
Duration30 minutes
Interview date29 Nov 2020
Coding problem0

So it was more like a jam session where each of us had to choose from a list of 40 chits each chit containing different topics and we were given around 2 minute to think and speak upon the topic chosen

03
Round
Medium
Video Call
Duration25 minutes
Interview date29 Aug 2020
Coding problem3

In this round,the interviewer started with asking about myself . It was basically a combination of technical as well as HR round.
Interviewer was very friendly and motivated me throughout the process.

1. Technical Questions

Write query for selecting top 10 rows of an employee table?

Then he asked which topics I am comfortable with. I answered DBMS and OS. 

So he asked me few questions from DBMS
1. What are different types of DBMS ? (Learn)
2. What is the difference between DBMS and RDBMS?  (Learn)
3. What is denormalization in DBMS?
4. What is stored procedure along with syntax?


Then he got into OOPS as the company is mainly focused on Java
1. Explain concepts of OOPs with real life examples. (Learn)
2. What is abstract class , explain with a program?
3. What is constructor destructor? 

2. Bursting Balloons

Moderate
40m average time
60% success
0/80
Asked in companies
QuikrSamsungOracle

You are given an array 'ARR' of N integers. Each integer represents the height of a balloon. So, there are N balloons lined up.

Your aim is to destroy all these balloons. Now, a balloon can only be destroyed if the player shoots its head. So, to do the needful, he/ she shoots an arrow from the left to the right side of the platform, from an arbitrary height he/she chooses. The arrow moves from left to right, at a chosen height ARR[i] until it finds a balloon. The moment when an arrow touches a balloon, the balloon gets destroyed and disappears and the arrow continues its way from left to right at a height decreased by 1. Therefore, if the arrow was moving at height ARR[i], after destroying the balloon it travels at height ARR[i]-1. The player wins this game if he destroys all the balloons in minimum arrows.

You have to return the minimum arrows required to complete the task.

Try solving now

3. Basic HR Questions

1.why should we hire you?
2. what additional you came to know about the company through pre placement talk?
3. What are your hobbies?

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

How do you write a single-line comment in C++?

Choose another skill to practice
Start a Discussion
Similar interview experiences
company logo
Business Technology Analyst
3 rounds | 1 problems
Interviewed by Deloitte
1025 views
0 comments
0 upvotes
company logo
Business Technology Analyst
3 rounds | 1 problems
Interviewed by Deloitte
979 views
0 comments
0 upvotes
company logo
Business Technology Analyst
4 rounds | 2 problems
Interviewed by Deloitte
2544 views
0 comments
0 upvotes
company logo
Business Technology Analyst
3 rounds | 4 problems
Interviewed by Deloitte
735 views
0 comments
0 upvotes