Stock Holding Corporation of India Data Analyst Interview Questions and Answers

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

Q1. I have been interviewed on the basis of alternative assets, finance etc.
Add your answer
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...read more
Answered by AI
Add your answer

Q1. Walk through resume
Add your answer

Excel question, ask about your previous experience

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

Q1. Myself introduction
Add your answer
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
Add your answer

Q1. Tableau, python, previous projects
Add your answer
Q2. Natural language processing, regression
Add your answer

Clustering code on cricket anslytics

Audit assurance case study… examples and estimation

Focus on little bit of dynamic programming

Q1. Apache spark architecture and ecosystem along with memory management
Add your answer
Q2. SQL queries for manager salary
Add your answer
Q3. Python decorators --> @
Add your answer
Q4. RANK and other window functions
Add your answer
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
Add your answer

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...read more
Answered by AI
Add your answer
Q2. Type 1 and Type 2 error
Add your answer

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

Q1. I have been interviewed on the basis of alternative assets, finance etc.
Add your answer
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...read more
Answered by AI
Add your answer

Q1. Walk through resume
Add your answer

Excel question, ask about your previous experience