Bharti AXA Life Insurance Data Analyst Intern Interview Questions and Answers

Q1. Tell me about yourself
Add your answer
Q2. Tell me a time when you had to deal with a failure, how you tackled it
Add your answer

Q1. Tell me something about your self
Add your answer

Q1. Why you left your previous organization
Ans. 
Seeking new challenges and growth opportunities
• Desire for career advancement

• Limited growth opportunities in previous organization

• Seeking new challenges and experiences
Answered by AI
Add your answer

Q1. Tell me about yourself, introducing
Ans. 
I am a dedicated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Statistics and experience working with large datasets

• I am proficient in statistical software such as R and Python

• I have a proven track record of delivering actionable insights to drive business decisions
Answered by AI
Add your answer

Q1. Tell me about your self?
Add your answer
Q2. What is SQL and diffrent joins in SQL?
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Different joins in SQL include inner join, outer join, left join, and right join.
• SQL is a standard programming language for managing and manipulating relational databases.

• Different types of joins in SQL include inner join, outer join, left join, and right join.

• Inner join returns rows when there is at least one match in both tables.

• Ou...read more
Answered by AI
Add your answer
Q3. How to separate portion before @ and after @ from mail using python?
Ans. 
Use Python to separate portion before and after @ in an email address.
• Use the split() method to separate the email address into two parts based on the @ symbol.

• Access the parts using index 0 for the portion before @ and index 1 for the portion after @.

• Example: email = 'example@email.com'; parts = email.split('@'); before = parts[0]; after = parts[1];
Answered by AI
Add your answer
Q4. What is the rank, Dense Rank and Row Number?
Ans. 
Rank, Dense Rank, and Row Number are functions used in SQL to assign a ranking to rows in a result set.
• Rank function assigns a unique rank to each row based on the specified column values.

• Dense Rank function assigns a unique rank to each row without any gaps.

• Row Number function assigns a sequential integer to each row in the result set.
Answered by AI
Add your answer

Q1. Regularizaion, model improvemnts
Add your answer
Q2. Hyperparameter tuning
Add your answer

Basic 10 apti question

Basic 5 python question

Basic 5 SQL question

Q1. They asked two python program.
Add your answer

Q1. They asked one SQL question
Add your answer

Q1. Just question based on my resume.
Add your answer

Q1. What is cat modelling
Ans. 
Cat modeling is a statistical method used to estimate the probability of loss due to a catastrophic event.
• It involves analyzing historical data to identify patterns and trends in losses caused by natural disasters such as hurricanes, earthquakes, and floods.

• The model then uses this data to predict the likelihood and severity of future losses, which helps insurance companies to price their policies accurately and manage...read more
Answered by AI
Add your answer
Q2. What do you mean by geocoding
Ans. 
Geocoding is the process of converting addresses into geographic coordinates (latitude and longitude).
• Geocoding helps in mapping and analyzing data based on location.

• It is used in various applications like navigation, logistics, and marketing.

• Examples of geocoding services include Google Maps API, Bing Maps API, and OpenStreetMap Nominatim API.
Answered by AI
Add your answer