AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Bharti Airtel Software Developer Interview Questions, Process, and Tips
Top Bharti Airtel Software Developer Interview Questions and Answers
- Q1. 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' ...read more
- Q2. 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 nega ...read more
- Q3. 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. Examp ...read more
Bharti Airtel Software Developer Interview Experiences
5 interviews found
Anonymous
(1 Question)
- Q1. How to optimise fetching 1 lakh entries from db
- Ans.
Use pagination, indexing, caching, and query optimization to fetch 1 lakh entries efficiently from the database.
Implement pagination to fetch data in smaller chunks
Create indexes on columns frequently used in queries
Use caching to store frequently accessed data
Optimize queries by avoiding unnecessary joins and using appropriate indexes
Consider using database-specific optimizations like query hints or stored procedures
I appeared for an interview in Jan 2022.
Round duration - 60 Minutes
Round difficulty - Medium
The round started with the Introduction followed by the discussion of projects done mentioned in my resume(all related to Machine Learning and Deep Learning). Then the recruiter asked me about my previous company experience and the work which I was doing there. After the discussion, interviewer started asking basic questions of SQL and PLSQL.
(1 Question)
Round duration - 70 Minutes
Round difficulty - Hard
Interviewer directly started asking questions in SQL,PLSQL AND SHELL SCRIPTING
- Q1. Write an SQL query to find the second highest salary.
- Ans.
SQL query to find the second highest salary
Use the ORDER BY clause to sort the salaries in descending order
Use the LIMIT clause to limit the result to the second row
Use a subquery to exclude the highest salary from the result
Interview Preparation Tips
Tip 1 : Remember all the basic commands and their syntax in PLSQL
Tip 2 : Try to optimize the query being asked in the interview.
Tip 1 : No false things.
Tip 2 : Highlight your achievements and skills.
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed before Jul 2022. There were 4 interview rounds.
Coding round with 3 DSA questions and a few MCQs on aptitude.
(1 Question)
- Q1. Interviewer asked questions on DSA.
(1 Question)
- Q1. The interviewer asked general questions on DSA.
What people are saying about Bharti Airtel
I appeared for an interview before May 2021.
(2 Questions)
Round duration - 60 Minutes
Round difficulty - Medium
Online Technical Interview ( Coding Round) with 2 medium-hard problem
- Q1.
Trapping Rain Water Problem Statement
You are given a long type array/list
ARRof sizeN, representing an elevation map. The valueARR[i]denotes the elevation of theithbar. Your task is to determine th... - Ans.
Calculate the total amount of rainwater that can be trapped between given elevations in an elevation map.
Iterate through the array to find the maximum height on the left and right of each bar.
Calculate the amount of water that can be trapped above each bar by taking the minimum of the maximum heights on the left and right.
Sum up the trapped water above each bar to get the total trapped water for the elevation map.
- Q2.
Longest Consecutive Sequence Problem Statement
You are provided with an unsorted array/list
ARRofNintegers. Your task is to determine the length of the longest consecutive sequence present in the array... - Ans.
Find the length of the longest consecutive sequence in an unsorted array of integers.
Iterate through the array and store each element in a set for constant time lookup.
For each element, check if it is the start of a sequence by looking for its previous number in the set.
Update the length of the current consecutive sequence and track the longest sequence found so far.
Return the length of the longest consecutive sequence...
(2 Questions)
Round duration - 60 Minutes
Round difficulty - Medium
Online Technical Coding Interview
- Q1.
Stack using Two Queues Problem Statement
Develop a Stack Data Structure to store integer values using two Queues internally.
Your stack implementation should provide these public functions:
Explanation:
... - Ans.
Implement a stack using two queues to store integer values with specified functions.
Create a stack using two queues internally
Implement functions for push, pop, top, size, and isEmpty
Handle edge cases such as empty stack or invalid data
Ensure the stack functions work correctly and efficiently
Test the implementation with sample inputs and outputs
- Q2.
Left View of a Binary Tree
Given a binary tree, your task is to print the left view of the tree. The left view of a binary tree contains the nodes visible when the tree is viewed from the left side.
Inpu...
- Ans.
Print the left view of a binary tree, containing nodes visible from the left side.
Traverse the tree in a level order manner and print the first node at each level.
Use a queue to keep track of nodes at each level.
Handle null nodes represented by -1 in the input.
Interview Preparation Tips
Tip 1 : Practice problem solving as much as you can
Tip 2 : Try to solve online coding problem as much as possible to get good understanding of DSA
Tip 3 : Be confident with your Resume
Tip 1 : Should have some projects on resume
Tip 2 : Resume sections should be clear and no false information
Skills evaluated in this interview
Bharti Airtel interview questions for designations
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
Get interview-ready with Top Bharti Airtel Interview Questions
Interview questions from similar companies
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 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
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
Bharti Airtel Interview FAQs
Tell us how to improve this page.
Bharti Airtel Interviews By Designations
- Bharti Airtel Territory Sales Manager Interview Questions
- Bharti Airtel Accounts Manager Interview Questions
- Bharti Airtel Network Engineer Interview Questions
- Bharti Airtel Sales Executive Interview Questions
- Bharti Airtel Territory Manager Interview Questions
- Bharti Airtel Store Manager Interview Questions
- Bharti Airtel Assistant Manager Interview Questions
- Bharti Airtel Customer Relationship Officer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Software Developer Interview Questions
- Associate Software Developer Interview Questions
- Lead Software Engineer Interview Questions
- Software Development Engineer II Interview Questions
- Software Engineer Interview Questions
- Software Development Engineer 1 Interview Questions
- Software Engineer Level 1 Interview Questions
- Senior Software Engineer Interview Questions
- Show more
Bharti Airtel Software Developer Interview Process
based on 3 interviews
Interview experience
Software Developer Interview Questions from Similar Companies
Fast track your campus placements
Bharti Airtel Software Developer Reviews and Ratings
based on 15 reviews
Rating in categories
|
Assistant Manager
2.2k
salaries
|  ₹3 L/yr - ₹13 L/yr |
|
Network Engineer
1.5k
salaries
| ₹2 L/yr - ₹7 L/yr |
|
Manager
1.4k
salaries
| ₹6.3 L/yr - ₹22.7 L/yr |
|
Territory Sales Manager
1.3k
salaries
| ₹2.7 L/yr - ₹11.2 L/yr |
|
Senior Executive
1.3k
salaries
| ₹2.1 L/yr - ₹10 L/yr |
Jio
Vodafone Idea
Ericsson
Tata Communications
- Home >
- Interviews >
- Bharti Airtel Interview Questions >
- Bharti Airtel Software Developer Interview Questions
