Bharti Airtel Interview Questions, Process, and Tips

Q1. Mere pahle experience ke bare mein
Ans. 
1 years sbi bank me and 3 year kotak Mahindra Bank limited me
Answered Anonymously
Add your answer
Q2. Aur mere bare mein mere karya karne ki kshamta ke bad
Ans. 
Mera Naam Ho Raha hai main UP Jaunpur jile se hun aur mere family mein meri mummy papa Bhai bahan hai aur main graduation BSc final kiya hun 2018 mein Kanpur University se.
Answered Anonymously
Add your answer

Meri salary aur meri expectation ke bare mein

Q1. Ham kis tarah se Kam karenge vah sab detail mein
Add your answer
Q2. Aur company ke bare mein kuchh detail mein bataenge kaise aur kam karte hain call kar sakte hain
Ans. 
Hamar jo total work tha abhi tak ka banking work tha customer ke sath relation maintain karna hota tha aur customer se le Lena hota tha banking ke account se bank account current account
Answered Anonymously
Add your answer

Kuchh bhi kahe samasya aati hai karya karne mein ham kaise theek karenge yah sab ke bare mein

Ham kya accepted test

Q1. Technical kya problem a raha hai vah sab solve karne ke bad
Add your answer
Q2. Aur ham log solve karke dekh ke upar se service denge
Add your answer

Q1. Kuchh bhi problem aata hai uska round pura ham follow Karen solve karenge 100%
Add your answer
Q2. Customer ko udaas nahin jaane denge ham usse kuchh Na kuchh karenge
Add your answer

Q1. Could you elaborate on your roles and responsibilities in your previous employment?
Ans. 
In my previous role, I was responsible for analyzing data, creating reports, and providing insights to support decision-making.
• Performed data cleaning, transformation, and analysis using tools like Excel, SQL, and Python.

• Generated reports and dashboards to visualize data trends and patterns.

• Collaborated with cross-functional teams to identify key metrics and KPIs for business performance.

• Presented findings and recommen...read more
Answered by AI
Add your answer
Q2. What was your role in the project, specifically related to data transformation and dashboard creation?
Ans. 
I was responsible for data cleaning, transformation, and visualization to create interactive dashboards for stakeholders.
• Performed data cleaning and transformation to ensure accuracy and consistency of data

• Utilized tools like SQL, Python, and Tableau to manipulate and visualize data

• Collaborated with stakeholders to understand their requirements and design interactive dashboards

• Generated insights from data analysis to d
Answered by AI
Add your answer
Q3. How do you optimize and manage large datasets, and what data sources do you utilize to obtain this data?
Ans. 
I optimize and manage large datasets by using tools like SQL, Python, and Excel. I utilize various data sources such as databases, APIs, and web scraping.
• Utilize SQL queries to efficiently extract and manipulate data from databases

• Use Python for data cleaning, analysis, and visualization tasks

• Leverage Excel for organizing and summarizing data in a user-friendly format

• Obtain data from sources like internal databases, ex
Answered by AI
Add your answer
Q4. Guesstimates like how many traffic signals are there in Noida.
Ans. 
There are approximately 500-600 traffic signals in Noida.
• Estimate based on the size and population of Noida

• Consider the number of major intersections and roads in the city

• Take into account the traffic density and need for traffic management

• Consult local traffic authorities for more accurate data
Answered by AI
Add your answer
Q5. The interviewer asked SQL questions related to window functions, joins, and advanced aggregations, such as running sum and rolling sum.
Add your answer

Q1. Second round is also a technical round and similar to first round . Medium to high level sql questions and questions related to the project you're working on and Guesstimates will be asked by the interview...read more
Add your answer

Q1. Project manager will take the third round interview and inquire about your knowledge of the company, and some technical and scenario-based questions related to decision-making and problem-solving approach.
Add your answer

Q1. Final round will be an HR round.
Add your answer

Q1. Zambia, Tanzania, Nigeria,chad.congo.b
Add your answer
Q2. Vode dump Zambia
Ans. 
Vode dump copy then Extract again merge then ..
Answered by FIDAUL HAOUE
Add your answer
Q3. What is alter command
Ans. 
ALTER command is used to modify the structure of a database table.
• ALTER command can be used to add, modify, or drop columns in a table.

• It can also be used to rename a table or change its data type.

• Example: ALTER TABLE table_name ADD column_name datatype;
Answered by AI
View 1 more answer
Q4. What is join ,Equi join,inner join,Left outer join full outer join
Add your answer
Q5. Type of constraints Primary key,not null,check, unique, default, foreign key
Add your answer