AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
BT
Group
Work with us 
Compare
Filter interviews by
BT Group Business Intelligence Developer Interview Questions and Answers
BT Group Business Intelligence Developer Interview Experiences
1 interview found
Anonymous
Selected
I appeared for an interview before Aug 2023.
(4 Questions)
- Q1. Diff between Union and Union All
- Ans.
Union combines and removes duplicates, Union All combines without removing duplicates.
Union combines result sets and removes duplicates
Union All combines result sets without removing duplicates
Union is slower than Union All as it involves removing duplicates
Union All is faster than Union as it does not remove duplicates
- Q2. Sets and their uses in Tableau
- Ans.
Sets in Tableau are custom fields that define a subset of data based on certain conditions.
Sets can be used to group related data together for analysis
Sets can be created based on dimensions or measures
Sets can be used in calculations, filters, and visualizations
Examples: creating a set of top customers, creating a set of high-value products
- Q3. Query to find 2nd highest salary
- Ans.
Query to find 2nd highest salary in a database table
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to retrieve the second row
- Q4. Some more basic questions
Given some pointers, how will I manage the stakeholders and plan.
Interview Preparation Tips
Don't forget, it's not just you who need a job; it's the company as well that need you
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I appeared for an interview in Oct 2020.
(2 Questions)
Round duration - 90 minutes (60 minutes for coding and 30 minutes for MCQs)
Round difficulty - Medium
The test was conducted in the evening from 7:00 pm to 8:30 pm. Because of the covid situation, the test was online and was given by all the students from their home.
Login window of 15 minutes was given and all students were supposed to login within initial 15 minutes (between 7:00 and 7:15 pm). The test was conducted on AMCAT and webcam was on during the whole test duration.
There were two sections in the test: 1.) Coding round with 2 coding questions - 60 minutes (2.) MCQ round with 30 MCQs - 30 minutes
120 students appeared for this round and 20 were shortlisted for further process.
- Q1.
Character Frequency Problem Statement
You are given a string 'S' of length 'N'. Your task is to find the frequency of each character from 'a' to 'z' in the string.
Example:
Input:
S : abcdg
Output:
1...
- Ans.
Given a string, find the frequency of each character from 'a' to 'z' in the string.
Create an array of size 26 to store the frequency of each character from 'a' to 'z'.
Iterate through the string and increment the count of the corresponding character in the array.
Print the array of frequencies as the output for each test case.
- Q2.
Longest Common Prefix After Rotation
You are given two strings 'A' and 'B'. While string 'A' is constant, you may apply any number of left shift operations to string 'B'.
Explanation:
Your task is to calcu...
- Ans.
Calculate the minimum number of left shift operations needed to achieve the longest common prefix between two strings.
Apply left shift operations to string B to find the longest common prefix with string A
Count the number of left shifts needed to achieve the longest common prefix
Return the minimum number of left shift operations for each test case
(1 Question)
Round duration - 50-60 minutes
Round difficulty - Medium
This round started at 11 am and went till 3 pm.
Out of 120 students that appeared in online coding test, 20 were shortlisted for the first round of interviews.
In this round, everyone was asked some moderate level coding questions. We were supposed to write the code in our IDE, present the screen and show the interviewer the output of our code.
The interview started with the introduction being followed by 2 coding problems.
- Q1.
Longest Subarray with Zero Sum
Ninja enjoys working with numbers, and as a birthday challenge, his friend provides him with an array consisting of both positive and negative integers. Ninja is curious to ...
- Ans.
Find the length of the longest subarray with zero sum in an array of integers.
Iterate through the array and keep track of the running sum using a hashmap.
If the running sum is seen before, the subarray between the current index and the previous index with the same sum is a subarray with zero sum.
Update the length of the longest subarray with zero sum as you iterate through the array.
Example: For arr1 = [1, -1, 3, 2, -2...
Round duration - 20 minutes
Round difficulty - Medium
7 students were shortlisted for the HR round. This round started at 7:30 pm and went till 8:30 pm.
Like all the other rounds, this round too was virtual (on google meet). In the beginning, the interviewer introduced himself and then asked questions based on my resume.
All the 7 candidates were selected in the HR round.
Interview Preparation Tips
Tip 1 : Questions are asked on DSA, so practice questions and it is not the number of questions you practice, but how well you practice the questions. Prepare a notebook and write down the approach you follow. Make proper notes and maintain that notebook. Will help for quick revision.
Tip 2 : Conceptual questions are asked from topics other than DSA. So watching videos on youtube will not help. Read the book thoroughly to make yourself ready for interviews.
Tip 3 : ALWAYS read about the real-life examples of the concepts you read. This is often asked in interviews and you will definitely regret failing to answer this question.
Tip 1 : Having projects in resume will help you to give the direction to your interview, which increases the chances of selection.
Tip 2 : Add some achievements other than academics, it shows that you are a team player and increases the probability of getting shortlisted. BUT do not write anything that is not true or else, it will backfire.
Skills evaluated in this interview
Interview Questionnaire
3 Questions
- Q1. The questions primarily started with discussion on my internships and minor project
- Q2. Many questions were asked about OOPs concepts like virtual function, multiple inheritance, function overloading etc you are supposed to define and implement all of them on paper
- Q3. I was asked about my favorite subject, opted computer networks. So, was asked about computer networks basics like ISO OSI, virtual LANs, QoS, AdHoc networks, WiiMax and Wifi
Interview Preparation Tips
Experience: Technical continues for about 35 minutes, the questions primarily started with discussion on my internships and minor project.
Many questions were asked about OOPs concepts like virtual function, multiple inheritance, function overloading etc you are supposed to define and implement all of them on paper.
I was asked about my favorite subject, opted computer networks. So, was asked about computer networks basics like ISO OSI, virtual LANs, QoS, AdHoc networks, WiiMax and Wifi.
Round: HR Interview
Experience: I was primarily asked about my family background, likes, hobbies etc
College Name: NA
Interview Questionnaire
7 Questions
- Q1. Array sorting – Bubble sort and its complexity?
- Ans.
Bubble sort is a simple sorting algorithm that repeatedly steps through the list, compares adjacent elements and swaps them if they are in the wrong order.
Bubble sort has a worst-case and average complexity of O(n^2), where n is the number of items being sorted.
It is not efficient for large lists and is generally used for educational purposes.
Example: Sorting an array of strings in alphabetical order using bubble sort.
- Q2. Various storage classes in C? Difference between auto, static?
- Ans.
Auto and static are two storage classes in C. Auto variables are local to a function while static variables retain their value between function calls.
Auto variables are created when a function is called and destroyed when the function ends
Static variables are initialized only once and retain their value between function calls
Auto variables have garbage value if not initialized while static variables are initialized to ...
- Q3. Questions on Pointers, memory management, scope of variables, etc were asked
- Q4. What are your strengths and weaknesses?
- Ans.
My strengths include problem-solving, attention to detail, and adaptability. My weaknesses include public speaking and impatience.
Strengths: problem-solving, attention to detail, adaptability
Weaknesses: public speaking, impatience
- Q5. Where do you see yourself 5 years from now?
- Ans.
In 5 years, I see myself as a senior software developer leading a team of developers to create innovative solutions.
Leading a team of developers to create innovative solutions
Continuing to learn and stay up-to-date with the latest technologies
Contributing to the growth and success of the company
Mentoring and coaching junior developers
Taking on more responsibilities and challenges
- Q6. What are your interests?
- Ans.
I am interested in exploring new technologies and learning new programming languages.
Exploring new technologies
Learning new programming languages
Attending tech conferences and meetups
Contributing to open source projects
- Q7. Are you ready to relocate?
- Ans.
Yes, I am open to relocation for the right opportunity.
I am willing to relocate for the right job opportunity
I am open to exploring new cities and cultures
I am willing to consider relocation assistance
I am excited about the prospect of working in a new environment
Interview Preparation Tips
Experience: The written test had 75 questions and we were allotted 80 minutes for the same.There were four sections: Verbal, Analytical, Attention to Detail and Technical (C and Data Structures).First, there was the verbal section. Basically, questions on articles, synonyms and antonyms were asked. Two passages were also given and related questions were asked. The analytical section included questions from quant (set theory, data sufficiency, cubes,etc.) and Logical Reasoning.
The third section was the easiest and did not require any special preparation. From a group of patterns, we had to determine if they were alike or different.
The fourth was the technical section and had 5 questions each from C and DS. This was the toughest section.Time management is absolutely important. There were sectional cutoffs and so we had to clear each section.
Round: Technical Interview
Experience: It was the PI round. First, we had the technical interview. Various questions on C and Data Structures were asked.Next, we had the HR interview. Here, the usual questions were asked. Some of them were:
Round: HR Interview
Experience: Also, questions from what I had written in my CV were asked.On the whole, the interview went quite well. And finally, I was selected.
Skills: Algorithm, C, C++
College Name: NIT PATNA
Skills evaluated in this interview
Interview Questionnaire
8 Questions
- Q1. Basic coding question from C, Data Structures and DBMS
- Q2. Questions from java and C++ (as it was mentioned in the resume)
- Q3. The main point of concentration was projects and training
- Q4. Some people were also asked questions related to data communication and basic electronics
- Q5. Questions like ‘Tell me about yourself’. (Try to create a good impression)
- Q6. Questions on your personality. Show confidence while answering. The HR might try to oppose what you say and see how you react
- Q7. Standard puzzles?
- Q8. Questions like, ‘Why do you want to join Verizon?’, ‘Why should we hire you?’
Interview Preparation Tips
Experience: Consisted of Quantitative aptitude, Logical reasoning, Data Interpretation and English.(Time management is important)
Skills: C, C++, Data structure, Algorithm
College Name: na
I appeared for an interview before Mar 2021.
Round duration - 15 minutes
Round difficulty - Easy
This was a group discussion round where we were divided into groups of 10 and we had 15 minutes for GD.
(6 Questions)
Round duration - 60 minutes
Round difficulty - Medium
This is all about how good you are with the fundamentals. Out of 10 I would give it a 6.5 on difficulty.
- Q1.
Reverse the String Problem Statement
You are given a string
STRwhich contains alphabets, numbers, and special characters. Your task is to reverse the string.Example:
Input:
STR = "abcde"
Output:
"e...
- Ans.
Reverse a given string containing alphabets, numbers, and special characters.
Iterate through the string from the end to the beginning and append each character to a new string.
Use built-in functions like reverse() or StringBuilder in languages like Python or Java for efficient reversal.
Handle special characters and numbers while reversing the string.
Ensure to consider the constraints on the length of the string and the...
- Q2. What is a deadlock?
- Ans.
A deadlock is a situation in which two or more processes are unable to proceed because each is waiting for the other to release a resource.
Occurs in multitasking environments where processes compete for limited resources
Can be resolved using techniques like deadlock prevention, deadlock avoidance, and deadlock detection
Example: Process A holds Resource X and waits for Resource Y, while Process B holds Resource Y and wa...
- Q3. What is a thread?
- Ans.
A thread is a lightweight sub-process that allows concurrent execution within a single process.
Threads share the same memory space within a process.
Threads are used to achieve parallelism and improve performance.
Examples of threads include the main thread in a program and worker threads in a multi-threaded application.
- Q4. What is the difference between Multiprocessing and Multiprogramming?
- Ans.
Multiprocessing involves multiple processors executing multiple tasks simultaneously, while multiprogramming involves multiple programs sharing a single processor by switching between them.
Multiprocessing utilizes multiple processors to execute multiple tasks concurrently.
Multiprogramming involves multiple programs sharing a single processor by switching between them.
Multiprocessing is more efficient in terms of perfor...
- Q5. Can you explain the process life cycle in an operating system?
- Ans.
Process life cycle in an operating system involves creation, execution, termination, and resource management.
Creation: When a process is created, it is assigned a unique process ID and allocated necessary resources.
Execution: The process is then scheduled by the operating system to run on the CPU.
Termination: Once the process completes its task or is terminated by the user, it is removed from memory.
Resource Management...
- Q6. What are the differences between Windows XP and Windows 7?
- Ans.
Windows XP and Windows 7 are both operating systems developed by Microsoft, but they have several key differences.
User interface: Windows 7 has a more modern and user-friendly interface compared to Windows XP.
Performance: Windows 7 is generally faster and more stable than Windows XP.
Security: Windows 7 has more advanced security features and updates compared to Windows XP.
Hardware support: Windows 7 supports newer hard...
(6 Questions)
Round duration - 60 minutes
Round difficulty - Easy
Technical round with questions on DBMS and Networking mainly.
- Q1. What is the difference between RDBMS and DBMS?
- Ans.
RDBMS is a type of DBMS that stores data in a structured format with relationships between tables.
RDBMS enforces referential integrity and allows for normalization of data.
DBMS is a general term for any system that manages databases, while RDBMS specifically refers to relational databases.
Examples of RDBMS include MySQL, Oracle, and SQL Server.
Examples of DBMS include MongoDB and Redis.
- Q2. What is an Object-Oriented Database Management System (OODBMS)?
- Ans.
An Object-Oriented Database Management System (OODBMS) is a type of database management system that supports the creation and management of objects in a database.
OODBMS stores data in the form of objects, which can contain attributes and methods.
It allows for complex data structures and relationships to be represented more easily.
Examples of OODBMS include db4o, ObjectDB, and ObjectStore.
- Q3. How do you find the number of unique values in a SQL database?
- Ans.
Use the COUNT DISTINCT function in SQL to find the number of unique values in a database.
Use the COUNT DISTINCT function along with the column name to count the number of unique values in that column.
For example, SELECT COUNT(DISTINCT column_name) FROM table_name;
You can also use GROUP BY to find the number of unique values for multiple columns.
- Q4. What is the difference between a hub and a switch in networking?
- Ans.
A hub operates at the physical layer and broadcasts data to all devices on the network, while a switch operates at the data link layer and forwards data only to the intended recipient.
Hub operates at the physical layer, while switch operates at the data link layer
Hub broadcasts data to all devices on the network, while switch forwards data only to the intended recipient
Switch is more efficient and secure compared to a ...
- Q5. Can you explain the different OSI layers?
- Ans.
The OSI (Open Systems Interconnection) model is a conceptual framework that standardizes the functions of a telecommunication or computing system into seven different layers.
Physical Layer: Deals with the physical connection between devices. Example: Ethernet cables.
Data Link Layer: Responsible for node-to-node communication. Example: MAC addresses.
Network Layer: Manages routing of data packets. Example: IP addresses.
T...
- Q6. What are the different protocols supported at each OSI layer?
- Ans.
Different protocols supported at each OSI layer
Layer 1 (Physical): Ethernet, Wi-Fi, Bluetooth
Layer 2 (Data Link): MAC, PPP, HDLC
Layer 3 (Network): IP, ICMP, ARP
Layer 4 (Transport): TCP, UDP, SCTP
Layer 5 (Session): NetBIOS, PPTP
Layer 6 (Presentation): SSL, TLS
Layer 7 (Application): HTTP, FTP, SMTP
Round duration - 15 minutes
Round difficulty - Easy
IF you make it to the HR round you are selected. All 28 that attended got selected . It was more like stuff for formality. The usual questions.
Interview Preparation Tips
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Skills evaluated in this interview
Interview Questionnaire
10 Questions
- Q1. All project related questions .(He found some fault and asked to remove it)?
- Q2. Why do we need garbage collection and how it is done in JAVA ?
- Ans.
Garbage collection is necessary to free up memory occupied by unused objects. Java uses automatic garbage collection.
Garbage collection helps prevent memory leaks and improves performance.
Java uses a mark-and-sweep algorithm to identify and remove unused objects.
The JVM periodically checks for unused objects and frees up memory occupied by them.
Developers can also manually trigger garbage collection using System.gc() m...
- Q3. Difference between TCP and UDP ?
- Ans.
TCP is a connection-oriented protocol while UDP is connectionless.
TCP provides reliable data transfer while UDP does not guarantee reliability.
TCP uses flow control and congestion control while UDP does not.
TCP is slower than UDP due to the overhead of establishing and maintaining a connection.
UDP is faster than TCP for applications that can tolerate data loss such as video streaming or online gaming.
- Q4. In which scenario do we need UDP ?
- Ans.
UDP is used in scenarios where speed is more important than reliability, such as online gaming and video streaming.
UDP is a connectionless protocol that does not guarantee delivery of packets
It is faster than TCP because it does not have to establish a connection before sending data
UDP is commonly used in online gaming, video streaming, and VoIP applications
It is also used for broadcasting and multicasting data to mult...
- Q5. Discussion on Hashmap , Collision function , heap data structure
- Q6. Two puzzles a. Given a bar , cut it twice and pay for 7 days?
- Q7. B. three ants are running on edges of a equilateral triangle with same speed. What is prob that dey will never meet?
- Ans.
The probability that three ants running on the edges of an equilateral triangle will never meet is 1/3.
The ants will never meet if they all move in the same direction (clockwise or counterclockwise) at the same speed.
The probability of this happening is 1/3, as each ant has two possible directions to choose from.
Example: If one ant starts moving clockwise, the other two ants must also move clockwise to never meet.
- Q8. Tell me about yourself ?
- Ans.
I am a software developer with experience in Java and Python.
I have a Bachelor's degree in Computer Science.
I have worked on various projects involving web development and data analysis.
I am proficient in Java and Python programming languages.
I am a quick learner and enjoy working in a team environment.
- Q9. Where do you see yourself in 5 yrs ?
- Ans.
In 5 years, I see myself as a senior software developer leading a team of developers to create innovative solutions.
Leading a team of developers
Creating innovative solutions
Continuing to learn and grow as a developer
Contributing to the success of the company
Building strong relationships with colleagues and clients
- Q10. Your strengths and asked to justify it (Jitni bakar kr skte ho kr do ) ?
Interview Preparation Tips
Experience: Relevance of technology
Round: Technical Interview
Experience: 1. All project related questions .(He found some fault and asked to remove it)?
2. Why do we need garbage collection and how it is done in JAVA ?
3. Difference between TCP and UDP ?
4. In which scenario do we need UDP ?
5. Discussion on Hashmap , Collision function , heap data structure
6. Two puzzles
a. Given a bar , cut it twice and pay for 7 days?
b. three ants are running on edges of a equilateral triangle with same speed. What is prob that dey will never meet?
Round: HR Interview
Experience: 1. Tell me about yourself ?
2. Where do you see yourself in 5 yrs ?
3. Your strengths and asked to justify it (Jitni bakar kr skte ho kr do ) ?
College Name: NA
Skills evaluated in this interview
I applied via Campus Placement and was interviewed before Apr 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Basic java questions and a few easy to medium leetcode.
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Jul 2020. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. It's was my first job in Ericsson question being asked were linux basic nothing much
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed in Sep 2020. There were 3 interview rounds.
Interview Questionnaire
3 Questions
- Q1. Regarding SAP Data Services
- Q2. Designer tool, Project, wf, df, transforms, types of transforms, performance optimisation techniques etc
- Q3. Hana
Interview Preparation Tips
BT Group Interview FAQs
Tell us how to improve this page.
BT Group Interviews By Designations
- BT Group Financial Analyst Interview Questions
- BT Group Network Engineer Interview Questions
- BT Group Associate Engineer Interview Questions
- BT Group Project Coordinator Interview Questions
- BT Group Network Security Engineer Interview Questions
- BT Group Software Engineer Interview Questions
- BT Group Service Reliability Engineer Interview Questions
- BT Group Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Developer Interview Questions
- System Engineer Interview Questions
- Business Analyst Interview Questions
- Power BI Developer Interview Questions
- Developer Interview Questions
- ETL Developer Interview Questions
- Tableau Developer Interview Questions
- Business Intelligence Analyst Interview Questions
- Show more
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Duration
Interview Questions from Similar Companies
BT Group Business Intelligence Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Associate Engineer
328
salaries
|  ₹2.8 L/yr - ₹8 L/yr |
|
Associate
296
salaries
| ₹2.3 L/yr - ₹6.3 L/yr |
|
Financial Analyst
271
salaries
| ₹12.6 L/yr - ₹23 L/yr |
|
Project Manager
222
salaries
| ₹9.3 L/yr - ₹20 L/yr |
|
Service Reliability Engineer
177
salaries
| ₹3.7 L/yr - ₹8.2 L/yr |
Jio
Vodafone Idea
Bharti Airtel
Ericsson
- Home >
- Interviews >
- BT Group Interview Questions
