Upload Button Icon Add office photos

Filter interviews by

Shairu Gems Diamonds Data Analyst Interview Questions and Answers

Updated 8 Feb 2023

Shairu Gems Diamonds Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 8 Feb 2023

Interview experience
3
Average
Difficulty level
Easy
Process Duration
-
Result
-

I applied via Job Fair and was interviewed in Aug 2022. 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 - One-on-one 

(2 Questions)

  • Q1. Excel formula regarding
  • Q2. Previous work experience regarding work

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic normal question qualification, previous job experience regarding no aptitude test and no practical test

Interview questions from similar companies

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

(1 Question)

  • Q1. SQL question difference between having and where
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Sastra University and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Well designed to test the aptitude competence of the candidate.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Explanations for the answers given to the aptitude questions.
  • Q2. Questions from python.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare based on the JD.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(3 Questions)

  • Q1. What is key features python programming
  • Ans. 

    Key features of Python programming include simplicity, readability, versatility, and extensive libraries.

    • Python is known for its simple and readable syntax, making it easy to learn and understand.

    • It is a versatile language that can be used for various purposes such as web development, data analysis, and artificial intelligence.

    • Python has a vast collection of libraries and frameworks that provide ready-to-use tools for ...

  • Answered by AI
  • Q2. What is pandas word?
  • Ans. 

    Pandas is a powerful data manipulation library in Python, used for data analysis and data wrangling tasks.

    • Pandas is a Python library that provides data structures and functions for efficient data manipulation.

    • It is widely used for tasks like data cleaning, transformation, and analysis.

    • Pandas offers powerful tools for handling structured data, such as CSV or Excel files.

    • It provides functionalities like filtering, sortin...

  • Answered by AI
  • Q3. Different between seaborn and matplotlib
  • Ans. 

    Seaborn is a high-level interface for statistical data visualization, while Matplotlib is a low-level library for creating basic plots.

    • Seaborn provides a more aesthetically pleasing and informative visual representation of data compared to Matplotlib.

    • Seaborn has built-in themes and color palettes that make it easier to create visually appealing plots.

    • Matplotlib offers more flexibility and control over plot customizatio...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - It's good

Skills evaluated in this interview

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

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

Round 1 - HR 

(1 Question)

  • Q1. How would you use your skill for sales

Interview Preparation Tips

Interview preparation tips for other job seekers - Do your best
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Phone screening 

(2 Questions)

  • Q1. Why your interested
  • Q2. Why you want to Jon
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

First round is gaming round with 13 levels
And the aptitude with science, technical and non technical questions

Round 2 - HR 

(4 Questions)

  • Q1. General questions were asked Tell me about yourself And then technical he round with puzzles and aptitude to solve
  • Q2. Long term and short term goals
  • Q3. Strength and weakness
  • Q4. Puzzles and aptitude questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare yourself with general aptitude and puzzles
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 tips
Round 2 - Aptitude Test 

Common logical and reasoning questions and also has a pseudocode

Round 3 - Gamified and Essay writing 

(1 Question)

  • Q1. Gamified round with time limits and essay writing for the given picture
Round 4 - Technical 

(1 Question)

  • Q1. Asked about whatever you put in the resume and mainly focus on aptitude
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
Not Selected

I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - Aptitude Test 

Logical and aptitude test, game round

Interview Preparation Tips

Interview preparation tips for other job seekers - Focus on projects and logical questions

I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Complex sql scenarios and their results
  • Ans. 

    Complex SQL scenarios and their results

    • Using subqueries to filter data

    • Joining multiple tables with complex conditions

    • Using window functions to calculate running totals

    • Pivoting data to transform rows into columns

    • Using recursive queries to traverse hierarchical data

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Should have strong knowledge in SQL, ETL & DWH concepts

Skills evaluated in this interview

Shairu Gems Diamonds Interview FAQs

How many rounds are there in Shairu Gems Diamonds Data Analyst interview?
Shairu Gems Diamonds interview process usually has 2 rounds. The most common rounds in the Shairu Gems Diamonds interview process are Resume Shortlist and One-on-one Round.

Tell us how to improve this page.

Shairu Gems Diamonds Data Analyst Interview Process

based on 1 interview

Interview experience

3
  
Average
View more
Shairu Gems Diamonds Data Analyst Salary
based on 7 salaries
₹1.8 L/yr - ₹3.5 L/yr
56% less than the average Data Analyst Salary in India
View more details

Shairu Gems Diamonds Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

3.0

Skill development

3.0

Work-life balance

2.0

Salary

5.0

Job security

5.0

Company culture

2.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
Data Analyst
7 salaries
unlock blur

₹1.8 L/yr - ₹3.5 L/yr

Accountant
4 salaries
unlock blur

₹3.2 L/yr - ₹6 L/yr

MIS Executive
4 salaries
unlock blur

₹3 L/yr - ₹3.2 L/yr

Executive Accountant
4 salaries
unlock blur

₹2.5 L/yr - ₹4.5 L/yr

Accounts Manager
3 salaries
unlock blur

₹7 L/yr - ₹8.2 L/yr

Explore more salaries
Compare Shairu Gems Diamonds with

KGK Group

3.6
Compare

Rosy Blue

3.7
Compare

Asian Star

3.3
Compare

Kiran Gems

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