Upload Button Icon Add office photos
Engaged Employer

i

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

Stellar Innovations Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Stellar Innovations Data Analyst Interview Questions and Answers

Updated 1 Oct 2024

Stellar Innovations Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 1 Oct 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Walk-in and was interviewed in Sep 2024. There was 1 interview round.

Round 1 - Aptitude Test 

Check typing speed and communications

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 26 Feb 2022

I applied via Referral and was interviewed in Aug 2021. There were 2 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 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - For Beginners better company and Improve knowledge

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

Interview Questionnaire 

2 Questions

  • Q1. If you are fresher, good communication is only enough to crack all the levels.
  • Q2. If you have experience, you need to explain the project and workflow with good communication without lag.

Interview Preparation Tips

Interview preparation tips for other job seekers - update your communication.

I applied via Recruitment Consultant and was interviewed in Mar 2018. There was 1 interview round.

Interview Preparation Tips

General Tips: Interview was short. Explained the role which was similar to the work I was doing before in my previous healthcare organization.

EDI related questions were asked. All type of file conversion and Excel formulas been asked.

Prepare well with on the above areas. It takes around 30 minutes.
Skills: Problem Solving, Analytical Skills, Presentation Skills, Time Management
Duration: <1 week
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
More than 8 weeks
Result
No response

I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Assignment 

SQL and python questions are very easy.

Interview Preparation Tips

Interview preparation tips for other job seekers - Ghost interview they will not respond after completing infact i also submitted pre joining form also.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Dec 2021. There were 4 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 - Coding Test 

It was an online coding test, with 2 python questions(DP and String) and 8 MCQs.

Round 3 - Technical 

(1 Question)

  • Q1. Asked about a coding question(easy level array question) , my one of project(explain line by line), permutation and combination question.
Round 4 - Technical 

(1 Question)

  • Q1. Same as second round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please prepare your basic coding(array and string well from leetcode easy level)
Interview experience
2
Poor
Difficulty level
Hard
Process Duration
-
Result
No response

I applied via Campus Placement and was interviewed before Feb 2022. 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 - Coding Test 

Though I applied for Data Analyst position through campus Recruitment Program (Kolkata). It had MCQs and Coding test, but surprisingly the MCQs were about Java, OOPs concept and basic coding questions. Hardly any ML or Analytics related like Python, SQL or BI tools related questions. As if I appeared for SDE role, not sure why it happened, but later I came to know they hired none from our college.

Round 3 - Assignment 

This did not happen, as they didn't call anyone from our college.

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on the basic skills, if you have already studied OOPs and other subjects in your semester, brush them up, still in case.

I applied via twocom.com and was interviewed in Oct 2021. There were 3 interview rounds.

Round 1 - Coding Test 

We were provided with 3 basic data stucture questions all three were leetcode medium easy question. Total time alloted was 1hr for three questions.

Round 2 - Coding Test 

2nd round was again coding round but this time question level was hard plus 10 MCQs were also given based on basic computer science knowledge.
There were 2 data structure question that was leetcode medium hard questions.

Round 3 - One-on-one 

(3 Questions)

  • Q1. How can you prove to the client that a students with higher classes are taller than that of lower classes?
  • Ans. 

    We can use statistical analysis to prove that students in higher classes are taller than those in lower classes.

    • Collect height data of students from different classes

    • Use statistical measures like mean, median, and mode to compare the heights of students in different classes

    • Perform hypothesis testing to determine if the difference in height between classes is statistically significant

    • Visualize the data using graphs and ...

  • Answered by AI
  • Q2. Compare two arrays in python and print if both of them are same or not?
  • Ans. 

    Compare two arrays in python and print if both of them are same or not.

    • Use the '==' operator to compare the arrays.

    • If the arrays have the same elements in the same order, they are considered the same.

    • If the arrays have different elements or different order, they are considered different.

    • Print 'Same' if the arrays are the same, otherwise print 'Different'.

  • Answered by AI
  • Q3. What is permutation and combination and how is it used in data science?
  • Ans. 

    Permutation and combination are mathematical concepts used to count the number of possible outcomes in a given scenario.

    • Permutation is the arrangement of objects in a specific order while combination is the selection of objects without considering the order.

    • Permutation formula: nPr = n!/(n-r)! where n is the total number of objects and r is the number of objects selected.

    • Combination formula: nCr = n!/r!(n-r)! where n i...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Dont stuck on any question, think, take time be vocal on what you are thinking and if you are not getting anything let the interviewer know this. Dont waste his/her time.

Skills evaluated in this interview

I appeared for an interview in Jun 2022.

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 - Coding Test 

2 easy level coding questions and aptitude mcqs

Round 3 - One-on-one 

(1 Question)

  • Q1. 3 coding questions easy to medium level. Discussion on my project and past internship experience. Basic maths questions from probability, statistic, pnc etc..

Interview Preparation Tips

Interview preparation tips for other job seekers - Have a look on basic dsa and 12th class maths question.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Aptitude Test 

Basic data structures, puzzles questions and statistics problems

Round 3 - One-on-one 

(5 Questions)

  • Q1. What was your previous company project
  • Q2. What are different types of indexing
  • Ans. 

    Different types of indexing include primary indexing, secondary indexing, clustered indexing, and non-clustered indexing.

    • Primary indexing: Index based on the primary key of a table, typically implemented using a B-tree structure.

    • Secondary indexing: Index based on a non-primary key column, allowing for faster retrieval of data based on that column.

    • Clustered indexing: Physically reorders the table based on the indexed co...

  • Answered by AI
  • Q3. How does random forest work
  • Ans. 

    Random forest is an ensemble learning method that builds multiple decision trees and merges their predictions.

    • Random forest creates a set of decision trees from randomly selected subsets of the training data.

    • Each tree in the random forest independently predicts the outcome, and the final prediction is made by averaging the predictions of all the trees.

    • Random forest is effective in handling high-dimensional data and can...

  • Answered by AI
  • Q4. Explain over fitting
  • Ans. 

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

    • Overfitting happens when a model is too complex and captures noise in the training data.

    • It leads to poor generalization to new, unseen data.

    • Regularization techniques like L1/L2 regularization can help prevent overfitting.

    • Cross-validation can be used to detect and prevent overfitting.

    • Example: A decision tree with too...

  • Answered by AI
  • Q5. Explain macros inExcel
  • Ans. 

    Macros in Excel are automated sequences of commands that can be created to perform repetitive tasks.

    • Macros can be recorded or written using Visual Basic for Applications (VBA)

    • They can automate tasks such as formatting, data manipulation, and calculations

    • Macros can be assigned to buttons or keyboard shortcuts for easy access

    • They can save time and reduce errors in repetitive tasks

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Tiger Analytics Data Analyst interview:
  • SQL
  • Python

Skills evaluated in this interview

Stellar Innovations Interview FAQs

How many rounds are there in Stellar Innovations Data Analyst interview?
Stellar Innovations interview process usually has 1-2 rounds. The most common rounds in the Stellar Innovations interview process are Resume Shortlist, HR and Aptitude Test.

Tell us how to improve this page.

Stellar Innovations Data Analyst Interview Process

based on 2 interviews

Interview experience

4.5
  
Good
View more
Stellar Innovations Data Analyst Salary
based on 29 salaries
₹1.2 L/yr - ₹3.7 L/yr
68% less than the average Data Analyst Salary in India
View more details

Stellar Innovations Data Analyst Reviews and Ratings

based on 10 reviews

2.2/5

Rating in categories

2.1

Skill development

2.2

Work-life balance

2.0

Salary

2.5

Job security

2.2

Company culture

2.0

Promotions

2.1

Work satisfaction

Explore 10 Reviews and Ratings
Process Associate
328 salaries
unlock blur

₹1 L/yr - ₹4.6 L/yr

Senior Process Associate
112 salaries
unlock blur

₹2 L/yr - ₹4.5 L/yr

Senior Analyst
98 salaries
unlock blur

₹2 L/yr - ₹5.3 L/yr

Software Engineer
56 salaries
unlock blur

₹2.4 L/yr - ₹7 L/yr

Title Examiner
48 salaries
unlock blur

₹2.5 L/yr - ₹4.8 L/yr

Explore more salaries
Compare Stellar Innovations with

ITC Infotech

3.6
Compare

CMS IT Services

3.1
Compare

KocharTech

3.9
Compare

Xoriant

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