Upload Button Icon Add office photos
Engaged Employer

i

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

Sunstone Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Sunstone Data Analyst Interview Questions and Answers

Updated 12 Sep 2022

Sunstone Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 12 Sep 2022

I applied via LinkedIn and was interviewed in Mar 2022. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Asked about the gist of resume and working experience
  • Q2. Asked about the tools they use and if I've working knowledge of those tools.
Round 2 - One-on-one 

(2 Questions)

  • Q1. Why do one wanna join the company?
  • Q2. If i'm availabe for three months and what day to day activity would look like.
  • Ans. 

    As a data analyst for three months, I would be responsible for analyzing data, creating reports, and presenting insights to stakeholders.

    • Analyze data to identify trends and patterns

    • Create reports and visualizations to communicate insights

    • Collaborate with stakeholders to understand their needs and provide recommendations

    • Use statistical tools and techniques to validate findings

    • Continuously monitor and improve data qualit...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Apply if your skills matches with the JD and you're good to go.

Interview questions from similar companies

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not 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:
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 - HR 

(2 Questions)

  • Q1. The first round of interviews was smooth; I had to visit their office in Andheri and then have a face-to-face conversation with Neeraj sir (Hr). The questions were to introduce yourself, what is big data, ...
  • Q2. After answering, he seemed somehow satisfied, but later he was encouraging me to enroll in their course and enhance my skills. And I'm still getting their emails and promotional messages for the same.
Round 3 - Technical 

(2 Questions)

  • Q1. The second round was on the call, which was rescheduled thrice. Then finally I got a call where Ashish sir (Hr) asked me to introduce myself, what are T&Z testing, overfitting, K neighbour algorithm, can w...
  • Q2. The job position was for a fresher Data analyst, but they were asking questions related to Data scientist position. Basically, they were looking for a candidate who has hands-on experience with real-time d...

Interview Preparation Tips

Topics to prepare for Imarticus Learning Data Analyst interview:
  • Data Science
  • R
  • Python
  • Excel
Interview preparation tips for other job seekers - Learn more about Data science, the company is into placing students in MNC's if they are skillful.

Interview Questionnaire 

1 Question

  • Q1. Any type of questions in data field

I applied via Naukri.com and was interviewed before Sep 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Question was moderate.based on logical reasoning and math.

Round 2 - Coding Test 

Coding test question based on sql and python.

Interview Preparation Tips

Interview preparation tips for other job seekers - if u have good knowledge on python ,machine learning and sql, then u can easily crack the exam.
Interview experience
1
Bad
Difficulty level
-
Process Duration
2-4 weeks
Result
-

I applied via LinkedIn and was interviewed in Feb 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. What's your experience?
  • Q2. Don't you have Data Science experience?
  • Ans. 

    No, I don't have direct Data Science experience.

    • However, I have worked with data extensively in my previous roles as a Data Analyst.

    • I have experience in data cleaning, data visualization, and statistical analysis.

    • I am also familiar with programming languages such as Python and R, which are commonly used in Data Science.

    • I am willing to learn and expand my skills in Data Science if given the opportunity.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - No pre screening process. Directly recruiter asked for suitable time for an interview and it was scheduled and JD has not given. No proper response from the recruiting team.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - Aptitude Test 

Average question where asked

Round 2 - Assignment 

Normal sql based assignment was there

Round 3 - One-on-one 

(1 Question)

  • Q1. Normal question where asked to me

Interview Preparation Tips

Interview preparation tips for other job seekers - Clear all the basics
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(2 Questions)

  • Q1. Asked about the Statistics concepts hypothesis,pvalue,mean,meadian.mode,normaldistrubution?
  • Q2. Sql joins questions based on three tables, complex joins

Interview Preparation Tips

Topics to prepare for Simplilearn Data Analyst interview:
  • Statistics
  • SQL
  • joins
Interview preparation tips for other job seekers - brush up all skills be polite while answering
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in May 2024. There were 5 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Question based on Window Functions in sql
  • Q2. Order of execution
  • Ans. 

    Order of execution refers to the sequence in which operations are carried out in a program or system.

    • Execution starts from the top of the program and moves downwards.

    • Operations within parentheses are executed first.

    • Multiplication and division are executed before addition and subtraction.

    • Functions are executed when they are called.

    • Control structures like loops and conditionals affect the order of execution.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Write a sql query to find out different routes for a airline. Table has two columns which are destination and source
  • Ans. 

    Use a SQL query to find different routes for an airline based on source and destination columns in a table.

    • Use a SELECT statement to retrieve the distinct combinations of source and destination.

    • Use the DISTINCT keyword to ensure only unique routes are returned.

    • Order the results by source and destination for easier analysis.

  • Answered by AI
  • Q2. Situational questions based on Business KPI
Round 3 - Behavioral 

(1 Question)

  • Q1. Simple discussion on the role and company culture
Round 4 - Head Of Analytics round 

(1 Question)

  • Q1. Case study question
Round 5 - HR 

(1 Question)

  • Q1. Basic Discussion on relocation and interest in joining the company.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interviewers were friendly but the level of interview for technical round was above moderate. SQL proficiency is must.

Skills evaluated in this interview

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

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

Round 1 - HR 

(1 Question)

  • Q1. The first round was a basic telephonic interview. Then simple basic SQL questions and some question based on Normalisation and DBMS were asked.
Round 2 - Technical 

(1 Question)

  • Q1. This was the toughest Data Analyst Interview I have faced till now. Interview was of 1 hr. Required higher level of SQL understanding. Asked to share screen and then solve SQL queries. Question based on jo...
Interview experience
4
Good
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There were 3 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. Technical questions mostly around sql, project based and few theoretical questions on python
Round 2 - Technical 

(1 Question)

  • Q1. This was one of the most grilled interview i have given, require moderate level of sql understanding, was asked to share screen and solve it , also i had show how it is working then basic questions of py...
Round 3 - HR 

(1 Question)

  • Q1. Was asked basic HR questions

Interview Preparation Tips

Topics to prepare for Simplilearn Data Analyst interview:
  • SQL
  • Python
  • Excel
  • Case Studies
Contribute & help others!
anonymous
You can choose to be anonymous

Sunstone Interview FAQs

How many rounds are there in Sunstone Data Analyst interview?
Sunstone interview process usually has 2 rounds. The most common rounds in the Sunstone interview process are One-on-one Round.

Recently Viewed

SALARIES

Disha Computer Institute

INTERVIEWS

DPS International

No Interviews

SALARIES

Disha Computer Institute

INTERVIEWS

Sunstone

No Interviews

COMPANY BENEFITS

Venus Industrial Corporation

No Benefits

SALARIES

Disha Computer Institute

SALARIES

Venus Industrial Corporation

No Salaries

INTERVIEWS

Sunstone

No Interviews

SALARIES

Disha Computer Institute

INTERVIEWS

DPS International

No Interviews

Tell us how to improve this page.

Interview Questions from Similar Companies

upGrad Interview Questions
3.7
 • 198 Interviews
Simplilearn Interview Questions
3.2
 • 101 Interviews
Jaro Education Interview Questions
2.5
 • 101 Interviews
NIIT Interview Questions
3.6
 • 84 Interviews
Great Learning Interview Questions
3.7
 • 56 Interviews
TALENTEDGE Interview Questions
3.3
 • 21 Interviews
View all
Sunstone Data Analyst Salary
based on 4 salaries
₹3.5 L/yr - ₹6 L/yr
16% less than the average Data Analyst Salary in India
View more details
Assistant Manager
109 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Manager
88 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Development Manager
49 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Professor
43 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Associate
42 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Sunstone with

upGrad

3.7
Compare

Simplilearn

3.2
Compare

Great Learning

3.7
Compare

Imarticus Learning

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