Upload Button Icon Add office photos

Filter interviews by

Stock Holding Corporation of India Data Analyst Interview Questions and Answers

Updated 13 Apr 2024

Stock Holding Corporation of India Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Pranav Kulkarni (PGDM 22-24)

posted on 13 Apr 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Why data analysis and data science
  • Ans. 

    Data analysis and data science are crucial for extracting valuable insights from large datasets to drive informed decision-making.

    • Data analysis and data science help in uncovering patterns and trends within data.

    • They enable businesses to make data-driven decisions for improved efficiency and effectiveness.

    • These fields also play a vital role in predictive analytics and forecasting.

    • Examples include using machine learning...

  • Answered by AI
  • Q2. Why pgdm in business analytics
  • Ans. 

    PGDM in Business Analytics provides specialized knowledge and skills for analyzing data to drive business decisions.

    • Specialized curriculum focusing on data analysis techniques and tools

    • Hands-on experience with real-world data sets

    • Opportunities for networking with industry professionals

    • Career advancement in the field of business analytics

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is K means
  • Ans. 

    K-means is a popular clustering algorithm used to partition data points into K clusters based on similarity.

    • K-means aims to minimize the sum of squared distances between data points and their respective cluster centroids.

    • It requires the number of clusters (K) to be specified in advance.

    • The algorithm iteratively assigns data points to the nearest cluster centroid and updates the centroids until convergence.

    • K-means is se...

  • Answered by AI
  • Q2. Type 1 and Type 2 error

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Assignment 

I had been interviewed on the basis of excel test related to advanced excel tecniques.

Round 2 - One-on-one 

(2 Questions)

  • Q1. I have been interviewed on the basis of alternative assets, finance etc.
  • Q2. Tell me about hedge funds
  • Ans. 

    Hedge funds are investment funds that use various strategies to maximize returns for their investors.

    • Hedge funds are typically only available to accredited investors due to their complex and risky nature.

    • They often use leverage and derivatives to amplify returns, but this also increases the risk of losses.

    • Hedge funds charge both a management fee (usually 2%) and a performance fee (usually 20%) based on profits earned.

    • S...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on finance, alternative assets, excel and good communication skills.
Interview experience
4
Good
Difficulty level
-
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Walk through resume
Round 2 - Group Discussion 

Excel question, ask about your previous experience

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

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

Round 1 - Aptitude Test 

In the aptitude test has 40 questions and give a answer in a proper manner l.

Round 2 - One-on-one 

(2 Questions)

  • Q1. Myself introduction
  • Q2. What is past experience in working in last organisation
  • Ans. 

    I have 2 years of experience working as a Data Entry Operator in my last organization.

    • Entered and updated data into computer systems

    • Verified accuracy of data entered

    • Maintained confidentiality of sensitive information

    • Assisted in organizing and maintaining files and records

  • Answered by AI
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Apr 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Tableau, python, previous projects
  • Q2. Natural language processing, regression
Round 2 - Coding Test 

Clustering code on cricket anslytics

Round 3 - Case Study 

Audit assurance case study… examples and estimation

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-

I applied via LinkedIn and was interviewed in Feb 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Focus on little bit of dynamic programming

Round 2 - Technical 

(5 Questions)

  • Q1. Apache spark architecture and ecosystem along with memory management
  • Q2. SQL queries for manager salary
  • Q3. Python decorators --> @
  • Q4. RANK and other window functions
  • Q5. Joins along with use case
  • Ans. 

    Joins are used in SQL to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Use cases for joins include combining customer data with order data, merging employee information with department details

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is K means
  • Ans. 

    K-means is a popular clustering algorithm used to partition data points into K clusters based on similarity.

    • K-means aims to minimize the sum of squared distances between data points and their respective cluster centroids.

    • It requires the number of clusters (K) to be specified in advance.

    • The algorithm iteratively assigns data points to the nearest cluster centroid and updates the centroids until convergence.

    • K-means is se...

  • Answered by AI
  • Q2. Type 1 and Type 2 error

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

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

Round 1 - Assignment 

I had been interviewed on the basis of excel test related to advanced excel tecniques.

Round 2 - One-on-one 

(2 Questions)

  • Q1. I have been interviewed on the basis of alternative assets, finance etc.
  • Q2. Tell me about hedge funds
  • Ans. 

    Hedge funds are investment funds that use various strategies to maximize returns for their investors.

    • Hedge funds are typically only available to accredited investors due to their complex and risky nature.

    • They often use leverage and derivatives to amplify returns, but this also increases the risk of losses.

    • Hedge funds charge both a management fee (usually 2%) and a performance fee (usually 20%) based on profits earned.

    • S...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well on finance, alternative assets, excel and good communication skills.
Interview experience
4
Good
Difficulty level
-
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Walk through resume
Round 2 - Group Discussion 

Excel question, ask about your previous experience

Stock Holding Corporation of India Interview FAQs

How many rounds are there in Stock Holding Corporation of India Data Analyst interview?
Stock Holding Corporation of India interview process usually has 1 rounds. The most common rounds in the Stock Holding Corporation of India interview process are One-on-one Round.
What are the top questions asked in Stock Holding Corporation of India Data Analyst interview?

Some of the top questions asked at the Stock Holding Corporation of India Data Analyst interview -

  1. why data analysis and data scie...read more
  2. why pgdm in business analyt...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

ICICI Securities Interview Questions
3.9
 • 145 Interviews
Angel One Interview Questions
3.9
 • 126 Interviews
Kotak Securities Interview Questions
3.6
 • 112 Interviews
HDFC Securities Interview Questions
3.6
 • 99 Interviews
Link Group Interview Questions
3.8
 • 34 Interviews
Go-Jek Interview Questions
3.7
 • 31 Interviews
View all

Stock Holding Corporation of India Data Analyst Reviews and Ratings

based on 2 reviews

5.0/5

Rating in categories

5.0

Skill development

4.0

Work-Life balance

3.2

Salary & Benefits

4.4

Job Security

5.0

Company culture

4.4

Promotions/Appraisal

4.0

Work Satisfaction

Explore 2 Reviews and Ratings
Executive
276 salaries
unlock blur

₹2.5 L/yr - ₹6.7 L/yr

Office Trainee
116 salaries
unlock blur

₹1.8 L/yr - ₹4 L/yr

Assistant Manager
102 salaries
unlock blur

₹4.2 L/yr - ₹15.5 L/yr

Branch Manager
57 salaries
unlock blur

₹4.5 L/yr - ₹13 L/yr

Back Office Executive
50 salaries
unlock blur

₹1 L/yr - ₹4.2 L/yr

Explore more salaries
Compare Stock Holding Corporation of India with

Central Depository Services (I)

3.3
Compare

National Securities Depository

3.1
Compare

Karvy Stock Broking

3.7
Compare

Geojit Financial Services

3.8
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview