Upload Button Icon Add office photos

Filter interviews by

Ethos Life Senior Data Analyst Interview Questions and Answers

Updated 24 Jun 2024

Ethos Life Senior Data Analyst Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Hacker rank test conducted online

Round 2 - Technical 

(1 Question)

  • Q1. Sql question, unique distinct route

Interview Preparation Tips

Interview preparation tips for other job seekers - I wanted to share my recent interview experience for a Senior Data Analyst position with Ethos Life.

The process started with a HackerRank test, which I passed, followed by an interview. During the interview, the panel, led by Mr. Ram Kishore Pasupathi, asked about my background and then gave me a question with a 15-minute time limit. The criteria for evaluation were:
- Speed
- Accuracy
- Readability
- Scalability

I solved the problem in 3-5 minutes and explained my approach step-by-step using a Google Sheet. The interviewer told me my solution was incorrect. I rechecked my work and insisted it was correct, offering to demonstrate it using PostgreSQL if given two minutes. He declined, stating he could read SQL.

I mentioned that there were multiple ways to solve the problem and offered to explain a few more approaches, but he didn't respond. Despite my confidence in my answer, the interview, which was scheduled for an hour, ended after just 15 minutes with only that one question.

After the interview, I created the table and applied my solution, which worked perfectly. I shared this with the hiring team, but I was ultimately not selected.

While not being selected is part of the process, interview panels should adhere to basic ethics. Candidates invest a significant amount of time preparing for tests and interviews. Experiences like this can severely impact a candidate's morale.

Note: My intention is not to damage the reputation of any individual or organization but to highlight how such incidents can affect candidates' morale.

I felt that the interviewer, Mr. Ram Kishore Pasupathi, might have taken my quick solution as a challenge to his ego. Although he gave me 15 minutes, I solved the problem in less than 3-5 minutes. It seemed he took my quick resolution personally.

I would advise the company and the interview panel to teach basic ethics to their employees on how to conduct interviews. If a candidate demonstrates knowledge that an employee may not have, it should be seen as an opportunity for learning and growth, rather than a blow to ego.

I also request that the company review with your team, as I have a Google Sheet with timestamps. Furthermore, please consider recording interviews and sharing these recordings with the candidate also for review.

Senior Data Analyst Jobs at Ethos Life

View all

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

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

Round 2 - Coding Test 

Some questions from the Pandas Data Frame scenario based

Round 3 - One-on-one 

(1 Question)

  • Q1. Ask about work and coding

Interview Preparation Tips

Interview preparation tips for other job seekers - It's Good to start the carrier
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Aug 2023. There were 3 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. Details about yourself
  • Q2. Personal information
Round 3 - Assignment 

They asked question from sql from join group by and from excel they asked about xlookup, vlookup, sumif,countif etc

Interview Preparation Tips

Topics to prepare for PolicyBazaar Business Analyst interview:
  • SQL
  • Advanced Excel
  • guestimate
  • communication
Interview preparation tips for other job seekers - this round is from manager they asked question from guestimate, and about projects you have done
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Referral and was interviewed in Dec 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Basic to Advanced level of SQL
  • Q2. Discussed 1 -2 Business Cases studies
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - One-on-one 

(2 Questions)

  • Q1. What analysis you have done in your previous organization
  • Q2. Find third manager for an employee on sql
  • Ans. 

    Use SQL query to find the third manager for an employee

    • Join the employee table with the manager table on the manager_id

    • Use a subquery to count the number of managers for the employee

    • Filter the results to only include the third manager

  • Answered by AI

Skills evaluated in this interview

I applied via Referral and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. What is your strength
  • Ans. Positive attitude towards work and life
  • Answered by rashmi pandey

Interview Preparation Tips

Interview preparation tips for other job seekers - Be positive and with high confidencd
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Sumifs Functions
  • Q2. Vlookup Function

Interview Preparation Tips

Interview preparation tips for other job seekers - Based on my experience there is lack of hospitality & the interviewer was rude don't know a formal basic speaking btw the interview level is average of below average. Keep one thing in mind that they are looking for an MIS type person on a Business Analyst name. If you are a Business analyst and working on Strategy Implementation and execution part then it may not be a right fit. However, if you still wish to proceed please prepare for the following Topics:

Advance Excel -

Sumifs formula may be they will ask a commission payout question in which you have to find the commission payout value then in Sheet 1 you have the master data, sheet 2 you have Commission percentage in sheet 3 you have to do work

Then use the sumifs formula for just reference i am writing the formula here

=sumifs for the total & join the formula with vlookup for % calculation

in SQL they might ask the questions
-DDL & DML
-Group query etc.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Your past experience
  • Q2. Previous achieve projects
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Case Study 

Question regarding convergence rate

Round 2 - Technical 

(2 Questions)

  • Q1. Sql triggers code
  • Q2. Vlookup, hlookup, match and indexing
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic Sql questions
  • Q2. Basic python questions

Ethos Life Interview FAQs

How many rounds are there in Ethos Life Senior Data Analyst interview?
Ethos Life interview process usually has 2 rounds. The most common rounds in the Ethos Life interview process are Coding Test and Technical.
How to prepare for Ethos Life Senior Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Ethos Life. The most common topics and skills that interviewers at Ethos Life expect are Automation Testing, CCTV Monitoring, Data Analysis, Data Analytics and Data Quality.

Tell us how to improve this page.

Ethos Life Senior Data Analyst Interview Process

based on 2 interviews

Interview experience

1
  
Bad
View more

Ethos Life Senior Data Analyst Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

1.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Senior Data Analyst

Bangalore / Bengaluru

1-5 Yrs

Not Disclosed

Explore more jobs
Technical Project Manager
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Technical Program Manager
4 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Medical Underwriter
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Customer experience Analyst
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Testing Engineer
3 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Ethos Life with

PolicyBazaar

3.6
Compare

ACKO

3.7
Compare

Axis Max Life Insurance

4.1
Compare

ICICI Prudential Life Insurance

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