Upload Button Icon Add office photos

HSBC Group

Compare button icon Compare button icon Compare
4.0

based on 4.5k Reviews

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

HSBC Group Assistant Vice President Business Analytical Interview Questions and Answers

Updated 15 Feb 2023

HSBC Group Assistant Vice President Business Analytical Interview Experiences

1 interview found

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

I applied via Recruitment Consulltant and was interviewed in Jan 2023. 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 - One-on-one 

(2 Questions)

  • Q1. Explain current project in details.
  • Q2. What are two most important deliverables of BA
  • Ans. 

    The two most important deliverables of a BA are requirements gathering and analysis.

    • Requirements gathering: identifying and documenting the needs and expectations of stakeholders

    • Analysis: using data and information to identify patterns, trends, and insights to inform decision-making

    • Examples: creating user stories, use cases, process flows, data models, and functional specifications

  • Answered by AI
Round 3 - Aptitude Test 

Which option best suits you. Four options were given we have to select any two

Interview Preparation Tips

Interview preparation tips for other job seekers - Pratical knowledge is must if you have knowledge and hands-on experience interview is easy to crack

Interview questions from similar companies

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

(2 Questions)

  • Q1. SQL , Oracle SQL, distinct
  • Q2. SQL, analytical SQL query
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Group Discussion 

Topic was renewable resources

Round 2 - Technical 

(2 Questions)

  • Q1. Warer jug problem
  • Q2. Aptitude (maths)

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
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 - Technical 

(5 Questions)

  • Q1. SQL queries regarding your project
  • Q2. Pratice joining concepts
  • Q3. Regarding end to end intercation with your project manager
  • Q4. ETL process and tableau concepts
  • Q5. Dashboard related to Tableau

Interview Preparation Tips

Interview preparation tips for other job seekers - - Be confident
- Don't make you down at the time of interview.
- Answer what's real
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Sep 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Question related to BFSI - mostly from resume, collection startegy, Sas, project handling
Round 3 - Technical 

(1 Question)

  • Q1. Case studies related to collection, segmentation, market based questions in contact strategy
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
No response

I was interviewed in Jan 2024.

Round 1 - Technical 

(1 Question)

  • Q1. 1. Macro quoting functions in SAS 2. ways to create macro variable in Data step 3. date functions-intck() and intnx() 4.situational scenario based questions 5.Automatic variables in SAS
  • Ans. 

    The interview questions cover topics such as macro quoting functions, creating macro variables, date functions, situational scenario-based questions, and automatic variables in SAS.

    • Macro quoting functions in SAS allow for the creation of macro variables with special characters.

    • Macro variables can be created in the data step using the %LET statement or by using the CALL SYMPUTX routine.

    • The date functions INTCK() and INT...

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Wells Fargo Analytics Consultant interview:
  • SAS
  • SQL

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Aug 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Logistic regression, modeling experience, choosing best model, SQL.. Find the third transaction of customer from dataset

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare your CV properly, expect question to test your knowledge and experience.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Telephonic Call 

(1 Question)

  • Q1. Connections in tableau, sas, sql and power bi
  • Ans. 

    Connections in Tableau, SAS, SQL, and Power BI are used to access and analyze data from various sources.

    • Connections in Tableau allow you to connect to different data sources such as databases, spreadsheets, and cloud services.

    • In SAS, you can use LIBNAME statements to establish connections to external data sources.

    • SQL uses connection strings to establish a connection to a database.

    • Power BI allows you to connect to a wid...

  • Answered by AI

Skills evaluated in this interview

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

I applied via Recruitment Consulltant and was interviewed in Jan 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. SQL hard questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare v hard for sql
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Since this was management position leader was focussing questions on leadership experienced areas networking etc
Round 3 - Technical 

(1 Question)

  • Q1. Two US folks interviewed me .Both are in senior leadership positions. it was mix of technical and mgmnt

HSBC Group Interview FAQs

How many rounds are there in HSBC Group Assistant Vice President Business Analytical interview?
HSBC Group interview process usually has 3 rounds. The most common rounds in the HSBC Group interview process are Resume Shortlist, One-on-one Round and Aptitude Test.

Tell us how to improve this page.

Interview Questions from Similar Companies

ICICI Bank Interview Questions
4.0
 • 2.4k Interviews
HDFC Bank Interview Questions
3.9
 • 2.1k Interviews
Axis Bank Interview Questions
3.8
 • 1.4k Interviews
IndusInd Bank Interview Questions
3.6
 • 581 Interviews
Wells Fargo Interview Questions
3.9
 • 552 Interviews
Yes Bank Interview Questions
3.8
 • 409 Interviews
American Express Interview Questions
4.2
 • 356 Interviews
UBS Interview Questions
4.0
 • 333 Interviews
View all

HSBC Group Assistant Vice President Business Analytical Reviews and Ratings

based on 3 reviews

5.0/5

Rating in categories

4.1

Skill development

4.8

Work-Life balance

4.5

Salary & Benefits

4.8

Job Security

5.0

Company culture

4.5

Promotions/Appraisal

4.5

Work Satisfaction

Explore 3 Reviews and Ratings
Assistant Manager
2.7k salaries
unlock blur

₹4.5 L/yr - ₹14.6 L/yr

Manager
2k salaries
unlock blur

₹8 L/yr - ₹28.1 L/yr

Senior Software Engineer
1.7k salaries
unlock blur

₹7.2 L/yr - ₹26 L/yr

Assistant Vice President
1.4k salaries
unlock blur

₹12.5 L/yr - ₹45 L/yr

Software Engineer
1.3k salaries
unlock blur

₹4.9 L/yr - ₹14.5 L/yr

Explore more salaries
Compare HSBC Group with

Standard Chartered

3.8
Compare

Citibank

3.9
Compare

ICICI Bank

4.0
Compare

Axis Bank

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