Upload Button Icon Add office photos

HSBC Group

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

HSBC Group Senior Data Engineer Interview Questions and Answers

Updated 23 Jul 2024

HSBC Group Senior Data Engineer Interview Experiences

1 interview found

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

(1 Question)

  • Q1. Cheapest option to load data from gcs to bq, pipeline shd be triggered based on file arrival
  • Ans. 

    Use Cloud Functions to trigger Dataflow job for loading data from GCS to BQ

    • Set up a Cloud Function to trigger when a new file arrives in GCS

    • Use the Cloud Function to start a Dataflow job that reads the file from GCS and loads it into BigQuery

    • Dataflow is a cost-effective option for processing large amounts of data in real-time

    • Utilize Dataflow templates for easy deployment and management

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Expect more scenario based questions from the interviewer.
For cloud they will provide scenarios and expect you to chose services ,pipeline etc

Skills evaluated in this interview

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. I was mostly asked about the process. First round was technical, mostly on Java
  • Q2. JVM Architecture, Java 9 new feature, collection framework, hibernate
  • Q3. 2nd round was mostly on tools and processes.

Interview Preparation Tips

Interview preparation tips for other job seekers - Always come prepare with whatever you have mentioned in your resume, if you talking about any tools, you should have end to end knowledge on that, you can't say I used Jenkins and then while answering, you would say I don't know how to create a job or pipeline. That kind of answer is not acceptable.

Interview Questionnaire 

1 Question

  • Q1. Questions on angular framework,.net core , dependency injection,legacy .net, session management , agile ceremonies.

I applied via Recruitment Consulltant and was interviewed before Mar 2021. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Java and OOPS Associated Questions
  • Q2. Spring and Basic Programming Like Sort, Searching

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't bother to give interviews it's not a good place to work for.

I applied via LinkedIn and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. - Data Structures and Algo - Core Python specific questions
  • Q2. - Design a Cache and some design based questions

Interview Preparation Tips

Interview preparation tips for other job seekers - I actually attended a Weekend drive. So in the 1st round almost related to 2/3 DS Algo questions.
2nd round was related to design small cache and little bit on python questions.
3rd round was managerial and some basic technical questions.

Interview Questionnaire 

1 Question

  • Q1. 1)Questions were asked related to Oracle plsql langauge and 2) Performance tuning and about 3) my data science master program,and like 4)my most challenging task ever I faced in my carrier.

Interview Questionnaire 

1 Question

  • Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.

Interview Preparation Tips

Round: Test
Experience: Practice questions on Indiabix.

Round: Technical Interview
Experience: Operating Systems basics, Dbsa basics

General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skill Tips: Make sure you do a course on object oriented programming
Skills: C, Sql, Java
College Name: BITS PILANI
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.

I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1. Explain SCD Type 2 Implementation in Informatica
  • Ans. 

    SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

    • SCD Type 2 maintains a separate row for each change in data, with a start and end date.

    • It requires a surrogate key to uniquely identify each row.

    • Informatica provides a built-in SCD Type 2 transformation to implement this technique.

    • Example: tracking changes in customer addresses over time.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Kindly focus on basic BI terminologies, common to trivial scenarios and introductory information on latest trending tools and technologies.

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Dec 2020. There was 1 interview round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be 100% technical in java here they will not be any support u need to dig deep lot of complex modules which we cannot understand in depth

I applied via LinkedIn and was interviewed before Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. All microsoft technologies related

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing

HSBC Group Interview FAQs

How many rounds are there in HSBC Group Senior Data Engineer interview?
HSBC Group interview process usually has 1 rounds. The most common rounds in the HSBC Group interview process are Technical.
How to prepare for HSBC Group Senior Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at HSBC Group. The most common topics and skills that interviewers at HSBC Group expect are Financial Services, Agile Coaching, Analytical Chemistry, Application Support and Beam.

Tell us how to improve this page.

HSBC Group Senior Data Engineer Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 575 Interviews
Citicorp Interview Questions
3.7
 • 573 Interviews
American Express Interview Questions
4.2
 • 365 Interviews
BNY Interview Questions
3.9
 • 347 Interviews
UBS Interview Questions
3.9
 • 338 Interviews
Morgan Stanley Interview Questions
3.6
 • 293 Interviews
View all
HSBC Group Senior Data Engineer Salary
based on 8 salaries
₹14 L/yr - ₹30.9 L/yr
13% more than the average Senior Data Engineer Salary in India
View more details
Assistant Manager
2.6k salaries
unlock blur

₹4.5 L/yr - ₹14.8 L/yr

Manager
2.1k salaries
unlock blur

₹8.1 L/yr - ₹28.1 L/yr

Senior Software Engineer
1.6k salaries
unlock blur

₹7.8 L/yr - ₹26 L/yr

Assistant Vice President
1.5k salaries
unlock blur

₹13.8 L/yr - ₹45 L/yr

Software Engineer
1.4k salaries
unlock blur

₹4.9 L/yr - ₹14.5 L/yr

Explore more salaries
Compare HSBC Group with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

Cholamandalam Investment & Finance

3.9
Compare

Citicorp

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