Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Innovaccer Team. If you also belong to the team, you can get access from here

Innovaccer Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Innovaccer Senior Data Analyst Interview Questions and Answers

Updated 14 Dec 2024

Innovaccer Senior Data Analyst Interview Experiences

2 interviews found

Senior Data Analyst Interview Questions & Answers

user image Simarpreet Singh

posted on 14 Dec 2024

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response
Round 1 - Technical 

(2 Questions)

  • Q1. What is the SQL query used to remove duplicates from a dataset?
  • Ans. 

    Use the DISTINCT keyword in a SELECT query to remove duplicates from a dataset.

    • Use the SELECT DISTINCT statement to retrieve unique rows from a table

    • Example: SELECT DISTINCT column1, column2 FROM table_name;

    • Another way is to use the GROUP BY clause with aggregate functions like COUNT() or SUM() to remove duplicates

  • Answered by AI
  • Q2. What is the SQL query to find the third highest salary in a table?
  • Ans. 

    Use a subquery to find the third highest salary in a table using SQL.

    • Use the ORDER BY clause to sort the salaries in descending order.

    • Use the LIMIT clause to limit the results to the third row.

    • Use a subquery to select the third highest salary from the sorted list.

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. What are the different roles in Power BI?
  • Ans. 

    Different roles in Power BI include Power BI Developer, Power BI Analyst, Power BI Administrator, and Power BI User.

    • Power BI Developer - responsible for creating and maintaining Power BI reports and dashboards

    • Power BI Analyst - analyzes data using Power BI to provide insights and recommendations

    • Power BI Administrator - manages security, access, and data sources in Power BI

    • Power BI User - consumes reports and dashboards

  • Answered by AI
  • Q2. SQL - basicand advanced questions

Senior Data Analyst Interview Questions & Answers

user image Gourav Chourasia

posted on 5 Sep 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Instahyre and was interviewed before Sep 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. SQL Questions on joins, case, functions
  • Q2. Healthcare domain questions

Senior Data Analyst Interview Questions Asked at Other Companies

Q1. What is the difference between Least Squares Method and the maxim ... read more
Q2. How do you improve the performance of Linear Regression
asked in Proftware
Q3. Imagine you are presented with a complex dataset from a multinati ... read more
Q4. How do you handle overfitting and underfitting in Decision Trees
Q5. What metrics do you use to evaluate classification models

Interview questions from similar companies

Data Analyst Interview Questions & Answers

Practo user image Pratik Chaudhari

posted on 17 Nov 2015

I applied via Referral

Interview Preparation Tips

Round: Resume Shortlist
Experience: Sent resume to an HR through Linkedin and got the call for interview

Round: Technical Interview
Experience: Had 3 rounds of technical interviews with Product Owner, Product Manager and VP Product. Most of the questions were related to maths, statistics and a few on machine learning. Even though I did not have much background on these, I was asked to give my inputs and try to find a solution. We discussed recommendation engines for Quora, Linkedin and e-commerce websites. Then they asked me how can we remove the bias that comes in the practo ratings of the doctors due to feedback from various channels. How can we identify if the customer is booking an appointment by looking at reviews or ratings? How can we identify spam reviews before publishing them? How can we build a product which can help users write a better quality review? Most of the questions were related to data science and how we can improve the products using data. The data analyst role for which I was being interviewed, was a first of its kind role in Practo. The JD was to basically work with the product team and help them in improving products, building new features etc. using data science/ data analytics.

Skills: Product Sense, Attitude, Data Science, Data Analysis, Basics Of Machine Learning
College Name: IIT Madras
Motivation: being the leader of the healthcare industry, high growth startup, opportunity to solve interesting problems using data

I applied via LinkedIn and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. SQL joins, python basics, resume based,

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare the basics well

I applied via Company Website and was interviewed in Apr 2022. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on SQL Puzzles Guesstimates
Round 2 - Case Study 

Puzzles
Case Study

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice more case studies, puzzles
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(5 Questions)

  • Q1. Basic Excel Questions
  • Q2. Medium and Basic SQL Questions
  • Q3. Resume based Question
  • Q4. Case Study Questions
  • Q5. Questions on Project

I applied via LinkedIn and was interviewed in Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. How can you reduce the delivery time of the order?
  • Ans. 

    Reducing delivery time can be achieved by optimizing the supply chain, improving communication, and automating processes.

    • Analyze the supply chain and identify bottlenecks

    • Implement automation tools to streamline processes

    • Improve communication between departments and with customers

    • Use data analytics to forecast demand and plan accordingly

    • Consider outsourcing or partnering with third-party logistics providers

    • Invest in tec...

  • Answered by AI
  • Q2. Questions based on Case Studies

Interview Preparation Tips

Interview preparation tips for other job seekers - The process consisted of two rounds. First was the business analysis kind of round which included the questions like how can you reduce the delivery time of the order? The second round was technical round where the person asked the questions on SQL and Excel

I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Estimate the sale of Umbrella in a year in Bangalore without any inputs given.
  • Ans. 

    Estimating sales of umbrellas in Bangalore without any inputs.

    • Analyze historical sales data of umbrellas in Bangalore

    • Consider weather patterns and forecast for the year

    • Evaluate competition and market trends

    • Assess population density and demographics

    • Factor in events and festivals that may affect sales

    • Use statistical models and regression analysis

    • Consider potential impact of COVID-19 on sales

  • Answered by AI
  • Q2. They will give one online test (SQL based)
  • Q3. Questions about SQL and probablity

Interview Preparation Tips

Interview preparation tips for other job seekers - I was not prepared with SQL on an advanced level, unfortunately, I was unable to clear.
If you want to apply, Be prepared with SQL and probability and general business analysis questions.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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 Resume tips
Round 2 - Technical 

(2 Questions)

  • Q1. Prepare on SQL in depth
  • Q2. Prepare on Excel & Python in depth
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via IIM Jobs and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

SQL + Python based questions

Round 2 - Technical 

(2 Questions)

  • Q1. More SQL + simple aptitude problems
  • Q2. Questions on joins, group by etc. Other questions on average speed, guesstimates.
Round 3 - Case Study 

A data set was given and the questions were asked around strategies to handle cancellations.

Interview Preparation Tips

Topics to prepare for Practo Business Analyst interview:
  • SQL
  • Case Studies
Interview preparation tips for other job seekers - Focus on SQL and problem solving.
Contribute & help others!
anonymous
You can choose to be anonymous

Innovaccer Interview FAQs

How many rounds are there in Innovaccer Senior Data Analyst interview?
Innovaccer interview process usually has 1-2 rounds. The most common rounds in the Innovaccer interview process are One-on-one Round, Technical and HR.
How to prepare for Innovaccer 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 Innovaccer. The most common topics and skills that interviewers at Innovaccer expect are Python, Data Modeling, Healthcare, SQL and Health Insurance.
What are the top questions asked in Innovaccer Senior Data Analyst interview?

Some of the top questions asked at the Innovaccer Senior Data Analyst interview -

  1. What is the SQL query used to remove duplicates from a datas...read more
  2. What is the SQL query to find the third highest salary in a tab...read more
  3. SQL Questions on joins, case, functi...read more

Recently Viewed

JOBS

Browse jobs

Discover jobs you love

COMPANY BENEFITS

KNR Constructions

20 benefits

COMPANY BENEFITS

IRB Infrastructure

60 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

COMPANY BENEFITS

Dilip Buildcon

304 benefits

INTERVIEWS

C DOT

No Interviews

SALARIES

AST Corporation

INTERVIEWS

DCB Bank

No Interviews

SALARIES

CNH Industrial

INTERVIEWS

Innovaccer

No Interviews

Tell us how to improve this page.

Innovaccer Senior Data Analyst Interview Process

based on 4 interviews

Interview experience

3.8
  
Good
View more

Interview Questions from Similar Companies

Globant Interview Questions
3.8
 • 172 Interviews
Chetu Interview Questions
3.3
 • 172 Interviews
Oracle Cerner Interview Questions
3.7
 • 157 Interviews
Tata 1mg Interview Questions
3.6
 • 146 Interviews
AVASOFT Interview Questions
3.6
 • 146 Interviews
Brane Enterprises Interview Questions
2.0
 • 132 Interviews
ivy Interview Questions
3.6
 • 122 Interviews
DE Shaw Interview Questions
3.8
 • 120 Interviews
ServiceNow Interview Questions
4.1
 • 120 Interviews
View all
Innovaccer Senior Data Analyst Salary
based on 171 salaries
₹8 L/yr - ₹25 L/yr
32% more than the average Senior Data Analyst Salary in India
View more details

Innovaccer Senior Data Analyst Reviews and Ratings

based on 16 reviews

3.7/5

Rating in categories

3.5

Skill development

3.7

Work-life balance

3.8

Salary

3.3

Job security

3.6

Company culture

3.5

Promotions

3.5

Work satisfaction

Explore 16 Reviews and Ratings
Data Analyst
307 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Data Analyst
171 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Software Engineer
96 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Data Engineer
68 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Development Engineer II
61 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Innovaccer with

Practo

3.2
Compare

Lybrate

3.5
Compare

Portea Medical

3.8
Compare

PharmEasy

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