Cholamandalam MS General Insurance Lead Data Scientist Interview Questions and Answers

Q1. Type of sql Joints
Ans. 
SQL Joins are used to combine rows from two or more tables based on a related column between them.
• Types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

• INNER JOIN returns rows when there is at least one 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 tab...read more
Answered by AI
Add your answer
Q2. Write DAX for create data modeling on inactive relationship?
Ans. 
Use DAX to create data modeling on inactive relationship in Power BI.
• Use USERELATIONSHIP function to create an inactive relationship between two tables.

• Specify the relationship between the tables and the columns to be used in the relationship.

• Use CALCULATE function along with USERELATIONSHIP to perform calculations using the inactive relationship.
Answered by AI
Add your answer

Duration - 60 Minutes
Topic - Advance DAX, Joints using DAX, all except all

First round will be aptitude test

Q1. Why should I hire you
Ans. 
I have a strong analytical background, excellent problem-solving skills, and a proven track record of delivering actionable insights.
• I have a degree in data analytics and relevant work experience

• I am proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

• I have successfully completed projects where I identified trends and patterns in data to drive business decisions
Answered by AI
Add your answer
Q2. Tell me about your self
Add your answer

Q1. Salary expectation
Add your answer
Q2. Position of the candidate
Add your answer

Q1. Basic Excel function
Add your answer
Q2. Scenario based questions
Add your answer

More questions about my experience & reason to join.

20 min for 25 question that are related to u r profile

Q1. They dont have knowledge about the profile asking some stupied questions
Add your answer
Q2. You are working before on MNC clients
Ans. 
Yes, I have worked with MNC clients before.
• I have experience working with multinational clients in my previous roles.

• I have successfully managed projects for MNC clients, delivering high-quality data analysis.

• I am familiar with the challenges and requirements of working with MNC clients, such as cultural differences and complex data sets.

• I have collaborated with cross-functional teams to meet the specific needs of MNC ...read more
Answered by AI
Add your answer
Q3. They dont know this compeny is MNC asking again and again u r working in MNC
Add your answer

Assignment on Sales data to find revenue ,split column

Q1. How much project you done in last year ?
Ans. 
I have completed multiple projects in the last year.
• I have completed 5 projects in the last year.

• One of the projects involved analyzing customer data to identify trends and patterns.

• Another project focused on optimizing inventory management using data analysis techniques.

• I also worked on a project that involved creating a predictive model for sales forecasting.

• In addition, I collaborated on a project to analyze social ...read more
Answered by AI
Add your answer
Q2. After clering all rounds they arrange the salary discussion round but not done salary discussion round and not getting any response on email & call
Add your answer
Q3. HR not given proper feedback about selection not getting any response on call & email
Add your answer
Q4. It is so difficult to decide U r selected or not & u can wait or join another
Add your answer

All the questions are based on the MCQ , and the syllabus is covered python SQL Power BI

Some questions from the Pandas Data Frame scenario based

Q1. Ask about work and coding
Add your answer

Q1. Walk us through you resume
Add your answer

Q1. Relevant question to the projects
Add your answer

Sql interiew, you will be asked to answer it on google meet chat

Simple cases of sql in 1 hr interview