Upload Button Icon Add office photos
Engaged Employer

i

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

Blackrock Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Blackrock Data Analyst Interview Questions and Answers

Updated 18 Sep 2024

Blackrock Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image tejas jain

posted on 18 Sep 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Aptitude Test 

Three sections are there 1) Aptitude Test 2) SQL 3) DSA

Round 2 - Technical 

(2 Questions)

  • Q1. What is DSA , sorting , difference between array and linked list
  • Ans. 

    DSA stands for Data Structures and Algorithms. Sorting is the process of arranging data in a particular order. Array is a data structure that stores elements of the same data type in contiguous memory locations, while linked list is a data structure that stores elements in nodes with pointers to the next node.

    • DSA stands for Data Structures and Algorithms

    • Sorting is the process of arranging data in a particular order

    • Arra...

  • Answered by AI
  • Q2. Written a SQL query
Round 3 - HR 

(2 Questions)

  • Q1. Coding question like add numbers
  • Q2. Experience on your project
  • Ans. 

    I have experience working on various data analysis projects, including market research, customer segmentation, and predictive modeling.

    • Developed predictive models to forecast customer behavior and optimize marketing strategies

    • Conducted market research to identify trends and opportunities for growth

    • Performed customer segmentation analysis to target specific demographics with personalized marketing campaigns

  • Answered by AI

Skills evaluated in this interview

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 16 May 2024

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

I applied via Campus Placement and was interviewed before May 2023. There was 1 interview round.

Round 1 - One-on-one 

(1 Question)

  • Q1. Difference between mutual and hedge funds
  • Ans. 

    Mutual funds pool money from multiple investors to invest in a diversified portfolio, while hedge funds are more exclusive and use more aggressive strategies.

    • Mutual funds are open to all investors, while hedge funds are typically only available to accredited investors.

    • Mutual funds are regulated by the SEC, while hedge funds have more flexibility in their investment strategies.

    • Mutual funds are more diversified and have ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just know whatever is written in you resume and be prepared with all the basic financial knowledge

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

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

I was interviewed in Dec 2024.

Round 1 - Technical 

(6 Questions)

  • Q1. Tell me About Yourself
  • Ans. 

    I am a data analyst with a background in statistics and experience in analyzing large datasets.

    • Background in statistics

    • Experience in analyzing large datasets

    • Proficient in data visualization tools like Tableau

    • Strong problem-solving skills

    • Excellent communication skills

  • Answered by AI
  • Q2. Project working and day to day activities I do
  • Q3. Rate Yourself In SQL out of 5
  • Ans. 

    I would rate myself a 4 out of 5 in SQL proficiency.

    • Proficient in writing complex SQL queries

    • Experienced in optimizing database performance

    • Familiar with data manipulation and analysis functions

    • Comfortable working with large datasets

  • Answered by AI
  • Q4. Sql 3 question based on windows function
  • Q5. Very basic python 2 Question
  • Q6. What You do on power bi in your work Explain with full details workflow
  • Ans. 

    I use Power BI to analyze and visualize data for insights and decision-making in my work.

    • Connect to data sources to import data

    • Transform and clean data using Power Query Editor

    • Create relationships between different data tables

    • Design interactive reports and dashboards

    • Use DAX formulas for calculations and measures

    • Share reports with stakeholders and collaborate on insights

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. All 3 sql Questions very simple Round but they didn't provide any Data tables just tell this and that so it may get confusing I slove 2 out of three but rejected on this Round questions Are intermidate

Interview Preparation Tips

Interview preparation tips for other job seekers - Overall interview Is Very simple just listen there Questions Clearly on sql You Will Crack Deloitte
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Dec 2024. There were 4 interview rounds.

Round 1 - Aptitude Test 

Set of questions on english , aptitude , all are at easy level

Round 2 - Coding Test 

Sql basics and some query questions

Round 3 - HR 

(2 Questions)

  • Q1. Why do u want to join zs ; what do u know about zs; where do u see urself after 5 years ; question on real life scenarios ;
  • Q2. Question on real life scenarios
Round 4 - HR 

(2 Questions)

  • Q1. Salary expectation
  • Q2. When can u join

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare all topics thorougly and general scenario questions and be confident and able to provide justice to ur approach
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Explain all types of joins
  • Ans. 

    Different types of joins in SQL are inner join, left join, right join, and full outer join.

    • Inner join: Returns rows when there is a match in both tables

    • Left join: Returns all rows from the left table and the matched rows from the right table

    • Right join: Returns all rows from the right table and the matched rows from the left table

    • Full outer join: Returns rows when there is a match in either table

  • Answered by AI
  • Q2. Difference between having and where
  • Ans. 

    The main difference between 'having' and 'where' in SQL is that 'having' is used with aggregate functions to filter groups, while 'where' is used to filter rows.

    • HAVING is used with GROUP BY to filter groups based on aggregate functions results

    • WHERE is used to filter rows based on conditions

    • HAVING is applied after GROUP BY, while WHERE is applied before GROUP BY

    • Example: SELECT department, AVG(salary) FROM employees GROU...

  • Answered by AI

Skills evaluated in this interview

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

(2 Questions)

  • Q1. Power BI Difference between ALL() and ALLSELECTED()
  • Ans. 

    ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.

    • ALL() removes all filters from the specified column or table.

    • ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

    • Example: ALL('Table') would remove all filters on the 'Table' in the query context.

    • Example: ALLSELECTED('Column') would remove filte...

  • Answered by AI
  • Q2. Excel Difference between COUNT() and COUNTA()
  • Ans. 

    COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.

    • COUNT() counts only cells with numerical values.

    • COUNTA() counts all non-empty cells, including text and errors.

    • Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Resume based questions like explain the projects that you have done.
  • Q2. Sample dataset questions

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Sql questions checking ur knowledge
  • Q2. Self join questions about sql
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 Sep 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Tableau, SQL related question
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Indeed and was interviewed in Jan 2024. There were 2 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Basics of power bi and sql
  • Q2. What are joins and types of join
  • Q3. How to add date table in power bi
Round 2 - Technical 

(4 Questions)

  • Q1. Sql scenario based question on joins
  • Q2. Window function questions
  • Q3. Performance tuning
  • Q4. Power bi dax question
Interview experience
3
Average
Difficulty level
Easy
Process Duration
-
Result
Selected Selected
Round 1 - HR 

(1 Question)

  • Q1. How good are you with numbers
Round 2 - Technical 

(1 Question)

  • Q1. Vlookup, pivot table, sumif, average, graphs
Round 3 - Behavioral 

(1 Question)

  • Q1. Do you know the role and responsibility of this position

Blackrock Interview FAQs

How many rounds are there in Blackrock Data Analyst interview?
Blackrock interview process usually has 2 rounds. The most common rounds in the Blackrock interview process are One-on-one Round, Aptitude Test and Technical.
What are the top questions asked in Blackrock Data Analyst interview?

Some of the top questions asked at the Blackrock Data Analyst interview -

  1. What is DSA , sorting , difference between array and linked l...read more
  2. Difference between mutual and hedge fu...read more
  3. Coding question like add numb...read more

Tell us how to improve this page.

Blackrock Data Analyst Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more
Blackrock Data Analyst Salary
based on 38 salaries
₹6 L/yr - ₹17.3 L/yr
58% more than the average Data Analyst Salary in India
View more details

Blackrock Data Analyst Reviews and Ratings

based on 4 reviews

4.1/5

Rating in categories

4.9

Skill development

4.2

Work-life balance

3.3

Salary

4.2

Job security

4.2

Company culture

3.4

Promotions

4.1

Work satisfaction

Explore 4 Reviews and Ratings
Analyst
1.1k salaries
unlock blur

₹5 L/yr - ₹16.5 L/yr

Associate
861 salaries
unlock blur

₹10 L/yr - ₹37 L/yr

Vice President
363 salaries
unlock blur

₹18.8 L/yr - ₹65 L/yr

Financial Analyst
136 salaries
unlock blur

₹4 L/yr - ₹16 L/yr

Software Engineer
53 salaries
unlock blur

₹10 L/yr - ₹22 L/yr

Explore more salaries
Compare Blackrock with

Vanguard

4.1
Compare

State Street Global Advisors

3.8
Compare

Fidelity Investments

4.2
Compare

Goldman Sachs

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