Airtel interview experience Real time questions & tips from candidates to crack your interview
SDE - 1
Airtel
3 rounds | 3 Coding
problems
Selected Interview preparation journey
Preparation
Duration: 4 Months
Topics: DBMS, MySQL, PLSQL, Linux, Shell Scripting, Oracle Apps, Machine Learning with Python
Tip 1 : Remember all the basic commands and their syntax in PLSQL
Tip 2 : Try to optimize the query being asked in the interview.
Application process
Where: Linkedin
Eligibility: Mandatory Experience in SQL, PLSQL
Tip 1 : No false things.
Tip 2 : Highlight your achievements and skills.
Interview rounds
01
Round
Medium
Video Call
Duration60 Minutes
Interview date6 Jan 2022
Coding problem1
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. DBMS Questions
Difference between SQL and PLSQL
DDL,DML commands in SQL
Procedures in PLSQL
Triggers in SQL
02
Round
Hard
Video Call
Duration70 Minutes
Interview date6 Jan 2022
Coding problem2
Interviewer directly started asking questions in SQL,PLSQL AND SHELL SCRIPTING
1. DBMS Questions
Subqueries in SQL
JOINS IN SQL and output related questions of JOINS
Difference between Truncate and Delete SQL commands
PLSQL Cursor and Tables
Difference between Procedure and Trigger in PLSQL
Exception Handling in PLSQL
Packages in SQL
2. SQL Query
SQL Query to find second highest salary
Problem approach
First write simple query to find highest salary and then nest the query to find second highest query.
03
Round
Medium
HR Round
Duration30 Minutes
Interview date6 Jan 2022
Coding problem0
The HR and Final discussion round was with VP of Engineering,Airtel.
The round started with introduction and my previous company experience. Then I was told about what my role and work would be, expectations from me if I get selected for the role and the culture of the company.
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
What is recursion?
Choose another skill to practice
Similar interview experiences
SDE - 1
4 rounds | 6 problems
Interviewed by Airtel
Selected 
4554 views
0 comments
0 upvotes
SDE - 1
2 rounds | 3 problems
Interviewed by Airtel
Rejected
1135 views
0 comments
0 upvotes
SDE - 1
4 rounds | 8 problems
Interviewed by Airtel
Rejected
1660 views
0 comments
0 upvotes
SDE - 1
3 rounds | 5 problems
Interviewed by Airtel
Selected 1752 views
0 comments
0 upvotes
Companies with similar interview experiences
SDE - 1
5 rounds | 12 problems
Interviewed by Amazon
Selected 114579 views
24 comments
0 upvotes
SDE - 1
4 rounds | 5 problems
Interviewed by Microsoft
Selected 57825 views
5 comments
0 upvotes
SDE - 1
3 rounds | 7 problems
Interviewed by Amazon
Selected 34961 views
7 comments
0 upvotes