Bharti Airtel PMO Analyst Interview Questions and Answers

Q1. Write program to print series
Ans. 
Program to print series of numbers or characters
• Use a loop to iterate through the series

• Print each element of the series in the loop

• Consider using different types of loops like for loop or while loop

• For example, to print numbers from 1 to 10: for(int i=1; i<=10; i++) { System.out.println(i); }
Answered by AI
Add your answer
Q2. Sql join questions,, simple
Add your answer

Q1. Questions were based on DSA and C
Add your answer
Q2. It was basically a coding round with simple logic
Add your answer

Q1. Tell me about yourself?
Add your answer
Q2. Explain your role in your current project and how you handled your customer in problematic situation?
Add your answer

Python was asked and data warehousing

Q1. Data warehouses concept
Ans. 
Data warehouses are centralized repositories that store integrated data from various sources for analysis and reporting.
• Data warehouses are designed for query and analysis rather than transaction processing.

• They consolidate data from multiple sources to provide a single, comprehensive view of the organization's data.

• Data warehouses often use a dimensional model with facts (measurable, quantitative data) and dimensions ...read more
Answered by AI
Add your answer
Q2. Sql question was asked
Add your answer

Q1. Can you automate dashobaord on excel on daily routine, Do you know proper formulation of dashboard.
Add your answer
Q2. How many years experience do you have in sql. Please provide solution for some sql technical questions. Or can you properly provide adhoc requirement by urgently analysing on compony database. There was s...read more
Add your answer

Q1. Work experience on discrete manufacturing
Ans. 
I have 3 years of work experience in discrete manufacturing.
• I have worked in a production line environment where products are manufactured in batches.

• I have experience in setting up and operating machinery such as CNC machines and assembly lines.

• I have knowledge of quality control processes and have worked with various measuring tools.

• I have also worked on process improvement projects to increase efficiency and reduce ...read more
Answered by AI
Add your answer

Q1. About previous experiences, shot term and long term goals
Add your answer

Q1. What do you like about this job role?
Add your answer
Q2. Being a techy student ,whybdonyou want to switch to business analyst post?
Add your answer

Q1. Tell me your project for a while .
Add your answer
Q2. Tell me about yourself
Add your answer

Q1. How will you do end to end automation
Ans. 
End to end automation will be achieved through a systematic approach involving analysis, design, implementation, testing, and deployment.
• Identify the processes that can be automated

• Design a solution that integrates with existing systems

• Implement the automation using appropriate tools and technologies

• Test the automation thoroughly to ensure it meets requirements

• Deploy the automation and monitor its performance

• Continuous
Answered by AI
Add your answer
Q2. How will you inform the business if something is not automatable
Ans. 
I will communicate the limitations of automation and suggest alternative solutions.
• Identify the specific task or process that cannot be automated

• Analyze the reasons why it cannot be automated

• Provide alternative solutions or workarounds

• Communicate the limitations and alternatives to the business stakeholders
Answered by AI
Add your answer

Q1. Director came and said you are hired
Add your answer
Q2. Asked about the technologies on which I worked upon
Add your answer
Q3. Basic understanding about my previous role
Add your answer