Upload Button Icon Add office photos

Filter interviews by

Shriram General Insurance Data Analyst Interview Questions and Answers

Updated 18 Sep 2024

Shriram General Insurance Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 18 Sep 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Tell me about yourself
  • Ans. 

    I am a data analyst with a strong background in statistics and data visualization.

    • Graduated with a degree in Statistics

    • Proficient in programming languages like Python and R

    • Experience in analyzing large datasets and creating data visualizations

    • Strong problem-solving skills

  • Answered by AI

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

Basic 10 apti question

Round 2 - Coding Test 

Basic 5 python question

Round 3 - Coding Test 

Basic 5 SQL question

Round 4 - Technical 

(1 Question)

  • Q1. They asked two python program.
Round 5 - Technical 

(1 Question)

  • Q1. They asked one SQL question
Round 6 - HR 

(1 Question)

  • Q1. Just question based on my resume.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - One-on-one 

(4 Questions)

  • Q1. Tell me about your self?
  • 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...

  • Answered by AI
  • 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
  • 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

Interview Preparation Tips

Interview preparation tips for other job seekers - practice general questions like joins, commands of DML, DFL, DCL, TCL.
For python practice coding like regex, splitting of string etc.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Regularizaion, model improvemnts
  • Q2. Hyperparameter tuning
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Oct 2022. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(2 Questions)

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

Interview Preparation Tips

Interview preparation tips for other job seekers - Be patient
Be confident
Be curious
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Walk-in and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Why do you want to join this company?
Round 2 - One-on-one 

(1 Question)

  • Q1. What is your strength?

I applied via Recruitment Consulltant and was interviewed in Jul 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain feature engineering process in ML modelling
  • Ans. 

    Feature engineering is the process of selecting and transforming relevant features from raw data to improve model performance.

    • Identify relevant features based on domain knowledge and data exploration

    • Transform features to improve their quality and relevance

    • Create new features by combining or extracting information from existing features

    • Select the most important features using feature selection techniques

    • Iterate the proc

  • Answered by AI
  • Q2. Explain classification models I used and why
  • Ans. 

    I have used logistic regression and decision tree models for classification.

    • Logistic regression is a linear model used for binary classification.

    • Decision tree is a non-linear model used for multi-class classification.

    • Logistic regression is simple and easy to interpret while decision tree can handle non-linear relationships.

    • I chose these models based on the nature of the data and the problem at hand.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Explain Tableau Dashboard actions
  • Ans. 

    Tableau Dashboard actions allow users to interact with the data and visualizations by clicking on specific elements.

    • Dashboard actions can be used to filter data, highlight specific data points, or navigate to other dashboards.

    • There are four types of actions in Tableau: filter, highlight, URL, and parameter.

    • For example, a user can click on a bar chart to filter the data in a related table or click on a map to highlight ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was based on Resume only.
Some drill down on the projects and technical skills like Python/Tableau and ML.
Explain my role and what I did to improve productivity.

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed before Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Why con't you remove the netap trainee hire from company side...

Interview Preparation Tips

Interview preparation tips for other job seekers - It's awesome company for who going to build carrier in customer support and data entry..
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-

I applied via Campus Placement

Round 1 - Aptitude Test 

Basic 10 apti question

Round 2 - Coding Test 

Basic 5 python question

Round 3 - Coding Test 

Basic 5 SQL question

Round 4 - Technical 

(1 Question)

  • Q1. They asked two python program.
Round 5 - Technical 

(1 Question)

  • Q1. They asked one SQL question
Round 6 - HR 

(1 Question)

  • Q1. Just question based on my resume.

Senior Data Analyst Interview Questions & Answers

Chubb user image manthena saivarma

posted on 19 Oct 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.

Round 1 - Coding Test 

5 sql coding questions from hacker rank. Basic sql questions, if you are experienced you will solve them in 15 to 20 min

Round 2 - Technical 

(4 Questions)

  • Q1. How do you seperate name from emails for example *****,***** etc.. We need to get name form those mails in sql
  • Ans. 

    Use SQL string functions like SUBSTRING and CHARINDEX to separate name from emails.

    • Use CHARINDEX to find the position of the '@' symbol in the email address.

    • Use SUBSTRING to extract the characters before the '@' symbol as the name.

    • Consider handling cases where there are multiple names or special characters in the email address.

  • Answered by AI
  • Q2. There is a table matches which has team 1,team 2 and winner columns. Sample data like ind pak pak and pak ind ind and sl ban sl. So a team can play mutliple matches. Final output should be team, no of matc...
  • Ans. 

    Calculate the number of matches won and lost by each team based on the given data in the matches table.

    • Group the data by team and count the number of matches won and lost for each team.

    • Use the winner column to determine the outcome of each match.

    • Create a query to calculate the number of matches won and lost for each team.

    • Example: Team A won 2 matches and lost 1 match.

    • Example: Team B won 1 match and lost 2 matches.

  • Answered by AI
  • Q3. Table a has 1, 1,0,0,null and table b has 1,0,null,null. Resultant rows for all joins
  • Ans. 

    The resultant rows for all joins between table a and table b with given values.

    • Inner join: 1

    • Left join: 1, 1, 0, 0, null

    • Right join: 1, 0, null, null

    • Full outer join: 1, 1, 0, 0, null, null

  • Answered by AI
  • Q4. Explain primary and secondary indexing. And more questions on indexing
Round 3 - Technical 

(3 Questions)

  • Q1. Explain about your projects
  • Ans. 

    I have worked on various projects involving data analysis, visualization, and predictive modeling.

    • Developed predictive models to forecast sales trends and customer behavior

    • Created interactive dashboards using Tableau for data visualization

    • Performed data cleaning and preprocessing to ensure accuracy and consistency

    • Utilized machine learning algorithms such as regression and clustering for analysis

    • Collaborated with cross-...

  • Answered by AI
  • Q2. Follow up questions on projects
  • Q3. Write a query to seperate first name, midle name and last name from full name in sql
  • Ans. 

    Use SUBSTRING_INDEX function in SQL to separate first name, middle name, and last name from full name.

    • Use SUBSTRING_INDEX function to extract first name by specifying space as delimiter

    • Use SUBSTRING_INDEX function to extract last name by specifying space as delimiter and -1 as position

    • Use combination of SUBSTRING_INDEX and REPLACE functions to extract middle name if present

  • Answered by AI

Skills evaluated in this interview

Shriram General Insurance Interview FAQs

How many rounds are there in Shriram General Insurance Data Analyst interview?
Shriram General Insurance interview process usually has 1 rounds. The most common rounds in the Shriram General Insurance interview process are HR.

Tell us how to improve this page.

Shriram General Insurance Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Shriram General Insurance Data Analyst Salary
based on 4 salaries
₹3 L/yr - ₹6 L/yr
28% less than the average Data Analyst Salary in India
View more details

Shriram General Insurance Data Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

4.0

Skill development

4.0

Work-life balance

2.0

Salary

5.0

Job security

2.0

Company culture

3.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Marketing Executive
216 salaries
unlock blur

₹1.2 L/yr - ₹3.6 L/yr

Senior Executive
199 salaries
unlock blur

₹2 L/yr - ₹4.8 L/yr

Branch Manager
171 salaries
unlock blur

₹3.2 L/yr - ₹8.5 L/yr

Executive Accountant
162 salaries
unlock blur

₹1.4 L/yr - ₹3.8 L/yr

Assistant Manager
158 salaries
unlock blur

₹2.2 L/yr - ₹7 L/yr

Explore more salaries
Compare Shriram General Insurance with

ICICI Lombard General Insurance Company

3.7
Compare

Bajaj Allianz General Insurance

3.9
Compare

HDFC Ergo General Insurance

3.9
Compare

Reliance General Insurance

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview