Upload Button Icon Add office photos

Filter interviews by

Statestreet HCL Services Data Analyst Interview Questions and Answers

Updated 24 Apr 2024

Interview questions from similar companies

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

Aptitude test on reasoning and problem solving

Round 2 - Technical 

(2 Questions)

  • Q1. What is list and tuple
  • Ans. 

    List and tuple are both data structures in Python. Lists are mutable, ordered collections of items, while tuples are immutable, ordered collections.

    • List is mutable, meaning its elements can be changed after creation

    • Tuple is immutable, meaning its elements cannot be changed after creation

    • List is defined using square brackets [], while tuple is defined using parentheses ()

    • Example of list: my_list = [1, 2, 3]

    • Example of tu

  • Answered by AI
  • Q2. How tableau works
  • Ans. 

    Tableau is a data visualization tool that helps users create interactive and shareable dashboards and reports.

    • Tableau connects to various data sources such as Excel, SQL databases, and cloud services.

    • Users can drag and drop fields to create visualizations like charts, graphs, and maps.

    • Tableau allows for interactive filtering and drilling down into data for deeper insights.

    • Users can create dashboards and stories to pres...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Stick with basic

Skills evaluated in this interview

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

(2 Questions)

  • Q1. Walk through your project?
  • Ans. 

    Developed a predictive model to forecast sales based on historical data

    • Collected and cleaned historical sales data

    • Performed exploratory data analysis to identify trends and patterns

    • Built and trained a machine learning model using regression techniques

    • Evaluated model performance using metrics like RMSE and MAE

  • Answered by AI
  • Q2. Behavioral questions?
Round 2 - Technical 

(2 Questions)

  • Q1. Questions based on Advanced Excel like Vlookup, Index match, sumifs, pivot tables
  • Q2. Behavioral questions
Round 3 - HR 

(1 Question)

  • Q1. Salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with your projects
Basic SQL, Advanced Excel, Tableau or Power BI
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Aug 2024. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Introduce about yourself...
  • Ans. 

    I am a data analyst with a strong background in statistics and data visualization.

    • Graduated with a degree in Statistics

    • Proficient in programming languages like Python and R

    • Experience in analyzing large datasets and creating data visualizations

    • Strong problem-solving skills

  • Answered by AI
Round 2 - HR 

(2 Questions)

  • Q1. Introduce yourself
  • Ans. 

    I am a data analyst with 5 years of experience in analyzing and interpreting complex data sets to drive business decisions.

    • 5 years of experience in data analysis

    • Proficient in statistical analysis and data visualization tools such as Python, R, and Tableau

    • Strong problem-solving skills and attention to detail

    • Experience in developing and implementing data-driven strategies

    • Excellent communication and presentation skills

  • Answered by AI
  • Q2. Property related questions
Round 3 - Aptitude Test 

Maths and English reasoning related

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare very well for this interview

Data Analyst Interview Questions & Answers

Foundever user image A.V Sai Pranathi

posted on 13 Aug 2024

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

Power BI report for shoe case analysis.

Round 2 - Technical 

(2 Questions)

  • Q1. Basic introduction about previous projects and skillsets.
  • Q2. Related to Power BI, SQL
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Dec 2023.

Round 1 - Aptitude Test 

Medical knowledge based questions

Round 2 - Technical 

(2 Questions)

  • Q1. General medical questions
  • Q2. Antidiabetics , gerd, antihypertension,gout,bones,fracture
Round 3 - HR 

(1 Question)

  • Q1. Introducation salary expectation skills personality
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 Jan 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 - HR 

(1 Question)

  • Q1. What are your background and history?
  • Ans. 

    I have a strong background in data analysis with experience in various industries.

    • Bachelor's degree in Statistics

    • Worked as a Data Analyst for 3 years at XYZ Company

    • Proficient in SQL, Python, and Tableau

    • Experience in analyzing large datasets and generating insights

    • Developed predictive models to optimize business strategies

    • Collaborated with cross-functional teams to drive data-driven decision making

  • Answered by AI
Round 3 - One-on-one 

(2 Questions)

  • Q1. Asked about an understanding of roles and responsibilities shared in JD, background, and contribution.
  • Ans. I did my research and development about the roles and responsibilities and answered them.
  • Answered by Shakti Singh
  • Q2. Asked teamwork and cooperation-related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - To kickstart your career and if you want work-life balance with low average pay.

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

Interview Questionnaire 

3 Questions

  • Q1. How to give answer of interview quition
  • Q2. How to do work in task us
  • Q3. How to talk with colleagues

Interview Preparation Tips

Interview preparation tips for other job seekers - Give interview confidently ....talk with employees politely with conscience....according to guide line do your work
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Coding Test 

Java, python, r, powerbi

Round 2 - Group Discussion 

About powerbi, they have conducted.....

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

(2 Questions)

  • Q1. Please tell me about your self
  • Q2. What is your typing spite

Statestreet HCL Services Interview FAQs

How many rounds are there in Statestreet HCL Services Data Analyst interview?
Statestreet HCL Services interview process usually has 1 rounds. The most common rounds in the Statestreet HCL Services interview process are HR.

Tell us how to improve this page.

Data Analyst Interview Questions from Similar Companies

View all
Statestreet HCL Services Data Analyst Salary
based on 7 salaries
₹2 L/yr - ₹2.8 L/yr
61% less than the average Data Analyst Salary in India
View more details

Statestreet HCL Services Data Analyst Reviews and Ratings

based on 1 review

2.0/5

Rating in categories

3.0

Skill development

3.0

Work-Life balance

3.0

Salary & Benefits

4.0

Job Security

3.0

Company culture

2.0

Promotions/Appraisal

3.0

Work Satisfaction

Explore 1 Review and Rating
Senior Analyst
5.1k salaries
unlock blur

₹1.5 L/yr - ₹5.5 L/yr

Specialist
3k salaries
unlock blur

₹2.7 L/yr - ₹7.1 L/yr

Team Lead
1.4k salaries
unlock blur

₹5.3 L/yr - ₹10 L/yr

Analyst
1.1k salaries
unlock blur

₹1.5 L/yr - ₹4 L/yr

Financial Analyst
838 salaries
unlock blur

₹1.4 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Statestreet HCL Services with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.7
Compare

Cognizant

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