Upload Button Icon Add office photos

Filter interviews by

HSBC Global Banking and Markets Data Analyst Interview Questions and Answers

Updated 28 Nov 2021

HSBC Global Banking and Markets Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 28 Nov 2021

I applied via Campus Placement and was interviewed before Nov 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. How can you remove duplicates using SAS, SQL, Excel etc.?
  • Ans. 

    Duplicates can be removed using SAS, SQL, Excel etc.

    • In SAS, use PROC SORT and the nodupkey option

    • In SQL, use the DISTINCT keyword in the SELECT statement

    • In Excel, use the Remove Duplicates feature under the Data tab

    • In Python, use the Pandas library and the drop_duplicates() method

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared with your basics

Skills evaluated in this interview

Interview questions from similar companies

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

(1 Question)

  • Q1. Explain different type of SQL query?

Interview Preparation Tips

Interview preparation tips for other job seekers - they ask mostly throretical questions.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

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

Round 1 - Technical 

(2 Questions)

  • Q1. Asked regarding sql to make a table and given some queries to solve over the table
  • Q2. Given easy code to solve before them very easy
Round 2 - HR 

(2 Questions)

  • Q1. Regarding place
  • Q2. Regarding night shifts

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well for sql and coding and focus on our projects
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(3 Questions)

  • Q1. Tell me about your self
  • Q2. SQL basics
  • Q3. Banking terms
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What is data analyst
  • Ans. 

    A data analyst is a professional who collects, processes, and analyzes data to provide insights and support decision-making.

    • Collects data from various sources

    • Cleans and processes data to ensure accuracy

    • Analyzes data using statistical methods and tools

    • Interprets data to identify trends and patterns

    • Presents findings and recommendations to stakeholders

  • Answered by AI
  • Q2. Asked question regarding project mention

Skills evaluated in this interview

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

Hackerrank test of 2 medium questions

Round 2 - Technical 

(1 Question)

  • Q1. ALL technical from your resume
Round 3 - One-on-one 

(1 Question)

  • Q1. Typical HR Interview
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Referral and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Case Study 

Was asking to solve case study based on Python, find the relevant insights

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

(1 Question)

  • Q1. Qliksense related questions
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Sas proc format
  • Q2. How have you debug macros
  • Ans. 

    I have debugged macros by reviewing code, checking for errors, using print statements, and stepping through code.

    • Reviewing the macro code line by line to identify any syntax errors or logical mistakes

    • Using print statements to output variable values and check for unexpected results

    • Stepping through the code using a debugger tool to track the flow of execution and pinpoint issues

    • Testing the macro with different inputs to

  • Answered by AI
  • Q3. How big data handled by you
  • Ans. 

    I handle big data by using advanced analytics tools and techniques to extract valuable insights.

    • Utilize data visualization tools like Tableau or Power BI to analyze and present data

    • Use programming languages like Python or R for data manipulation and statistical analysis

    • Implement machine learning algorithms to uncover patterns and trends in large datasets

    • Leverage cloud computing platforms like AWS or Google Cloud for sc...

  • Answered by AI

Skills evaluated in this interview

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

I applied via Campus Placement

Round 1 - Aptitude Test 

Basic maths questions

Round 2 - Group Discussion 

Basic topics movies vs series

Round 3 - Technical 

(2 Questions)

  • Q1. Sql Queries were asked
  • Q2. Was based on resume
Round 4 - HR 

(2 Questions)

  • Q1. Based on resume the questions were
  • Q2. Questions about family

Tell us how to improve this page.

HSBC Global Banking and Markets Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
HSBC Global Banking and Markets Data Analyst Salary
based on 4 salaries
₹9.5 L/yr - ₹13 L/yr
54% more than the average Data Analyst Salary in India
View more details

HSBC Global Banking and Markets Data Analyst Reviews and Ratings

based on 3 reviews

4.4/5

Rating in categories

4.0

Skill development

4.7

Work-life balance

3.4

Salary

4.3

Job security

4.3

Company culture

3.4

Promotions

3.5

Work satisfaction

Explore 3 Reviews and Ratings
Assistant Manager
289 salaries
unlock blur

₹4.2 L/yr - ₹12 L/yr

Manager
141 salaries
unlock blur

₹7.6 L/yr - ₹23 L/yr

Analyst
118 salaries
unlock blur

₹4.6 L/yr - ₹18 L/yr

Assistant Vice President
106 salaries
unlock blur

₹16 L/yr - ₹50 L/yr

Senior Analyst
80 salaries
unlock blur

₹5 L/yr - ₹21.8 L/yr

Explore more salaries
Compare HSBC Global Banking and Markets with

JPMorgan Chase & Co.

4.0
Compare

Goldman Sachs

3.5
Compare

Morgan Stanley

3.7
Compare

Barclays

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