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 Data Analyst Intern Interview Questions and Answers

Updated 17 Oct 2024

Innovaccer Data Analyst Intern Interview Experiences

2 interviews found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Python coding, simple

Round 2 - Technical 

(2 Questions)

  • Q1. Data analytics related, imbalanced data set handling
  • Q2. Overfit and how to fix that
  • Ans. 

    Overfitting occurs when a model learns the noise in the training data rather than the underlying pattern.

    • Regularization techniques like L1 and L2 regularization can help prevent overfitting by penalizing large coefficients.

    • Cross-validation can be used to evaluate the model's performance on unseen data and prevent overfitting.

    • Feature selection or dimensionality reduction techniques can help reduce overfitting by focusin...

  • Answered by AI

Skills evaluated in this interview

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

It had 1 SQL question & 1 question on Dynamic Programming.

Round 2 - Technical 

(2 Questions)

  • Q1. Question on group by, aggregate functions.
  • Q2. Window functions
Round 3 - HR 

(2 Questions)

  • Q1. What projects have you worked on ?
  • Q2. Any interesting problem solved ?
  • Ans. 

    Developed a predictive model to forecast customer churn for a telecom company.

    • Identified key factors contributing to customer churn such as call drop rates and customer service response times.

    • Collected and cleaned data from various sources including customer call logs and service records.

    • Used machine learning algorithms such as logistic regression and random forest to build the predictive model.

    • Achieved a prediction ac...

  • Answered by AI

Data Analyst Intern Interview Questions Asked at Other Companies

Q1. Water Jug Problem Statement You have two water jugs with capaciti ... read more
Q2. Insertion Sort in a Linked List Given a singly linked list with ' ... read more
Q3. What is the difference between loc and iloc in data science, and ... read more
Q4. Can you explain the different types of keys in a database and the ... read more
Q5. What do you mean by MTD ? How to create it

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
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
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

I applied via LinkedIn and was interviewed before Sep 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Normal aptitude question

Round 2 - Coding Test 

Detail of sql especially joins

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
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - Coding Test 

Retention analysis based on tables given, flowed by structure of RCA analysis

I was interviewed before Apr 2021.

Round 1 - Coding Test 

(3 Questions)

Round duration - 90 minutes
Round difficulty - Medium

This round had 3 coding questions of Medium to Hard level of difficulty.

  • Q1. 

    Balanced Parentheses Combinations

    Given an integer N representing the number of pairs of parentheses, find all the possible combinations of balanced parentheses using the given number of pairs.

    Explanati...

  • Ans. 

    Generate all possible combinations of balanced parentheses for a given number of pairs.

    • Use recursion to generate all possible combinations of balanced parentheses.

    • Keep track of the number of open and close parentheses used in each combination.

    • Return the valid combinations as an array of strings.

  • Answered by AI
  • Q2. 

    Trapping Rain Water Problem Statement

    You are given a long type array/list ARR of size N, representing an elevation map. The value ARR[i] denotes the elevation of the ith bar. Your task is to determine th...

  • Ans. 

    Calculate the total amount of rainwater that can be trapped between given elevations in an array.

    • Iterate through the array and calculate the maximum height on the left and right of each bar.

    • Calculate the amount of water that can be trapped at each bar by taking the minimum of the maximum heights on the left and right.

    • Sum up the trapped water at each bar to get the total trapped water for the entire array.

  • Answered by AI
  • Q3. 

    Rotting Oranges Problem Statement

    You are given a grid containing oranges where each cell of the grid can contain one of the three integer values:

    • 0 - representing an empty cell
    • 1 - representing a fre...
  • Ans. 

    Find the minimum time required to rot all fresh oranges adjacent to rotten oranges.

    • Create a queue to store the coordinates of rotten oranges and perform BFS to rot adjacent fresh oranges.

    • Track the time taken to rot all fresh oranges and return -1 if not all fresh oranges can be rotten.

    • Update the grid with the new state of oranges after each second.

    • Handle edge cases such as empty grid or no fresh oranges present.

    • Example...

  • Answered by AI
Round 2 - Face to Face 

(3 Questions)

Round duration - 60 Minutes
Round difficulty - Medium

This was a standard DS/Algo round where I was given 2 questions to solve under 60 minutes. I was able to come up with the optimal approach for both the questions and then at the end of the interview I was also asked the famous Die Hard Water Puzzle.

  • Q1. 

    Queue Using Stacks Implementation

    Design a queue data structure following the FIFO (First In First Out) principle using only stack instances.

    Explanation:

    Your task is to complete predefined functions t...

  • Ans. 

    Implement a queue using stacks following FIFO principle.

    • Use two stacks to simulate a queue.

    • For enQueue operation, push elements onto stack1.

    • For deQueue operation, if stack2 is empty, pop all elements from stack1 and push onto stack2, then pop from stack2.

    • For peek operation, if stack2 is empty, pop all elements from stack1 and push onto stack2, then return top of stack2.

    • For isEmpty operation, check if both stack1 and st...

  • Answered by AI
  • Q2. 

    Merge Intervals Problem Statement

    You are provided with 'N' intervals, each containing two integers denoting the start time and end time of the interval.

    Your task is to merge all overlapping intervals a...

  • Ans. 

    Merge overlapping intervals and return sorted list of merged intervals by start time.

    • Sort the intervals based on start time.

    • Iterate through intervals and merge overlapping ones.

    • Return the merged intervals in sorted order.

  • Answered by AI
  • Q3. You have a 3-liter jar and a 5-liter jar. How can you measure exactly 4 liters using these two jars?
Round 3 - Face to Face 

(4 Questions)

Round duration - 60 Minutes
Round difficulty - Medium

This round had 2 coding questions - first one related to Binary Tree and the second one was a simple question from Bit Manipulation. This was followed by some questions from OOPS.

  • Q1. 

    Binary Tree Diameter Problem Statement

    You are given a Binary Tree, and you need to determine the length of the diameter of the tree.

    The diameter of a binary tree is the length of the longest path betwe...

  • Ans. 

    The task is to find the diameter of a binary tree, which is the length of the longest path between any two end nodes in the tree.

    • Traverse the tree to find the longest path between two nodes.

    • Keep track of the maximum diameter found during traversal.

    • The diameter may not necessarily pass through the root node.

    • Consider both left and right subtrees while calculating the diameter.

    • Example: For input 1 2 3 4 -1 5 6 -1 7 -1 -1

  • Answered by AI
  • Q2. 

    Power of 2 Problem Statement

    Determine if it is possible to reorder the digits of a given integer 'N' such that the resulting number is a power of two. The leading digit must not be zero.

    Input:

    The fir...
  • Ans. 

    The problem involves determining if it is possible to reorder the digits of a given integer to form a power of 2.

    • Iterate through all possible permutations of the digits of the given integer.

    • Check if any of the permutations form a power of 2.

    • Return 1 if a valid permutation is found, else return 0.

  • Answered by AI
  • Q3. What are some advantages of using Object-Oriented Programming (OOP)?
  • Ans. 

    Advantages of OOP include code reusability, modularity, and easier maintenance.

    • Code reusability: Objects can be reused in different parts of the program, reducing redundancy.

    • Modularity: OOP allows for breaking down complex problems into smaller, more manageable parts.

    • Easier maintenance: Changes to one part of the codebase do not necessarily affect other parts, making maintenance easier.

    • Encapsulation: Data hiding and ab...

  • Answered by AI
  • Q4. What are access specifiers and what is their significance in Object-Oriented Programming?
  • Ans. 

    Access specifiers define the level of access to class members in Object-Oriented Programming.

    • Access specifiers include public, private, protected, and default

    • Public members are accessible from outside the class

    • Private members are only accessible within the class

    • Protected members are accessible within the class and its subclasses

    • Default access is when no access specifier is specified

  • Answered by AI
Round 4 - HR 

(1 Question)

Round duration - 30 Minutes
Round difficulty - Easy

This was my last round and I hoped it to go good just like the other rounds. The interviewer was very straight to point
and professional. The interview lasted for 30 minutes.

  • Q1. Why should we hire you?

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPAPracto interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, DBMS, OS, Aptitude, OOPSTime required to prepare for the interview - 4 MonthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

Interview Questionnaire 

8 Questions

  • Q1. Implement queue with the help of two stacks
  • Ans. 

    Queue can be implemented using two stacks by maintaining the order of elements in the stacks.

    • Create two stacks, let's call them stack1 and stack2

    • When an element is enqueued, push it to stack1

    • When an element is dequeued, pop all elements from stack1 and push them to stack2

    • Pop the top element from stack2 and return it as the dequeued element

    • If stack2 is empty, repeat step 3

    • To get the front element of the queue, peek the

  • Answered by AI
  • Q2. Iven a table “student” of with columns Name and Marks. You have to write a SQL query to get the 2nd highest marks from the table. Also write a query to find the nth highest marks, where n can be any number
  • Q3. What is left join. Give example. And Full outer join?
  • Ans. 

    Left join returns all records from left table and matching records from right table. Full outer join returns all records from both tables.

    • Left join is used to combine two tables based on a common column.

    • In left join, all records from the left table are returned along with matching records from the right table.

    • If there is no match in the right table, NULL values are returned.

    • Example: SELECT * FROM table1 LEFT JOIN table...

  • Answered by AI
  • Q4. What is magic functions and autoloading in PHP?
  • Ans. 

    Magic functions are special methods in PHP that start with __. Autoloading is a way to automatically load classes.

    • Magic functions are used to handle certain events in PHP, such as object creation or property access.

    • Autoloading allows PHP to automatically load classes when they are needed, without requiring manual includes.

    • Magic functions can be used in conjunction with autoloading to dynamically load classes or handle

  • Answered by AI
  • Q5. Given three arrays sorted in non-decreasing order, print all common elements in these arrays. Examples: ar1[] = {1, 5, 10, 20, 40, 80} ar2[] = {6, 7, 20, 80, 100} ar3[] = {3, 4, 15, 20, 30, 70, 80, 120} Ou...
  • Ans. 

    Given three sorted arrays, find common elements.

    • Create three pointers to traverse each array

    • Compare the elements at the pointers and move the pointer of the smallest element

    • If all pointers point to the same element, add it to the result and move all pointers

    • Repeat until any pointer reaches the end of its array

  • Answered by AI
  • Q6. A puzzle. You will be given with a 3 Litre container & a 7 Litre Container. Measure exactly 5 Litres of water
  • Q7. Asked about one of my projects I mentioned in my resume?
  • Q8. Find if a number is a power of 2 or not?
  • Ans. 

    Check if a number is a power of 2 or not.

    • A power of 2 has only one bit set in its binary representation.

    • Use bitwise AND operator to check if the number is a power of 2.

    • If n is a power of 2, then n & (n-1) will be 0.

  • Answered by AI

Interview Preparation Tips

Skills: Data structures, PHP, Algortihm
College Name: na
Motivation: Overall it was a very good experience. They test you from every aspect. In the End I would like to say that Practo is one of the best companies to work for.

Skills evaluated in this interview

Contribute & help others!
anonymous
You can choose to be anonymous

Innovaccer Interview FAQs

How many rounds are there in Innovaccer Data Analyst Intern interview?
Innovaccer interview process usually has 2-3 rounds. The most common rounds in the Innovaccer interview process are Coding Test, Technical and HR.
What are the top questions asked in Innovaccer Data Analyst Intern interview?

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

  1. overfit and how to fix t...read more
  2. Any interesting problem solve...read more
  3. data analytics related, imbalanced data set handl...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

E2E Networks

No Interviews

INTERVIEWS

Innovaccer

No Interviews

SALARIES

E2E Networks

INTERVIEWS

AIT Global

No Interviews

INTERVIEWS

AIT Global

No Interviews

Tell us how to improve this page.

Innovaccer Data Analyst Intern 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
 • 170 Interviews
Oracle Cerner Interview Questions
3.7
 • 157 Interviews
Tata 1mg Interview Questions
3.6
 • 146 Interviews
AVASOFT Interview Questions
3.2
 • 143 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 Data Analyst Intern Salary
based on 4 salaries
₹12 L/yr - ₹13 L/yr
340% more than the average Data Analyst Intern Salary in India
View more details
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