Shriram General Insurance Data Analyst Interview Questions and Answers

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

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. Why do you want to join this company?
Add your answer

Q1. What is your strength?
Add your answer

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
Add your answer
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
Add your answer

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 ...read more
Answered by AI
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

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

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
Add your answer
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...read more
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
Add your answer
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
Add your answer
Q4. Explain primary and secondary indexing. And more questions on indexing
Add your answer

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-...read more
Answered by AI
Add your answer
Q2. Follow up questions on projects
Add your answer
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
Add your answer