Airtel DTH Services Data Analyst Interview Questions and Answers

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. It was an easy situational ques
Add your answer
Q2. It was an easy situational questiokn
Add your answer

Q1. Same as the first one
Add your answer
Q2. Same as the previous round
Add your answer

Q1. Previous experience
Add your answer

Q1. Current roles and responsibilities, Few queries to write, few questions related to DWH and what type of role you have done in past etc
Add your answer

Q1. Managerial round mostly questions like what challenges did you face, how did you overcome on that, what was the major success / appreciation you got
Add your answer

There was a question which say, write the string in the reverse order.

Q1. What are your strengths and weakness.
Ans. 
My strengths include strong analytical skills and attention to detail. My weakness is that I can be overly critical of my own work.
• Strength: Strong analytical skills

• Strength: Attention to detail

• Weakness: Overly critical of my own work
Answered by AI
Add your answer
Q2. Tell me about yourself
Ans. 
I am a data analyst with experience in analyzing and interpreting complex data sets to drive business insights.
• Proficient in SQL, Python, and Excel for data analysis

• Skilled in data visualization using Tableau and Power BI

• Experience in conducting statistical analysis and creating predictive models

• Strong problem-solving and critical thinking skills

• Effective communication and presentation skills

• Ability to work collaborati
Answered by AI
Add your answer

Q1. SQL joins and simple query
Add your answer
Q2. Phython basics and simle data fram
Add your answer
Q3. Hr round only formality
Add your answer

Q1. Difference between joins
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer
Q2. Window function
Add your answer

Q1. Write sql query in pythons
Ans. 
Writing SQL queries in Python allows for seamless integration of data analysis and manipulation.
• Use libraries like pandas or sqlalchemy to execute SQL queries in Python

• Remember to establish a connection to the database before executing queries

• Utilize Python's flexibility to manipulate and analyze data retrieved from SQL queries
Answered by AI
Add your answer