AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
HSBC Group Data Engineer Interview Questions and Answers
11 Interview questions
Spark is a distributed computing framework designed for big data processing.
Spark is built around the concept of Resilient Distributed Datasets (RDDs) which allow for fault-tolerant parallel processing of data.
It provides high-level APIs in Java, Scala, Python, and R for ease of use.
Spark can run on top of Hadoop, Mesos, Kubernetes, or in standalone mode.
It includes modules for SQL, streaming, machine learning, an...
MapReduce is a programming model and processing technique for parallel and distributed computing.
MapReduce is used to process large datasets in parallel across a distributed cluster of computers.
It consists of two main functions - Map function for processing key/value pairs and Reduce function for aggregating the results.
Popularly used in big data processing frameworks like Hadoop for tasks like data sorting, sear...
Lazy evaluation in Spark delays the execution of transformations until an action is called.
Lazy evaluation allows Spark to optimize the execution plan by combining multiple transformations into a single stage.
Transformations are not executed immediately, but are stored as a directed acyclic graph (DAG) of operations.
Actions trigger the execution of the DAG and produce results.
Example: map() and filter() are transf...
Imputer function in PySpark is used to replace missing values in a DataFrame.
Imputer is a transformer in PySpark ML library.
It replaces missing values in a DataFrame with either mean, median, or mode of the column.
It can be used with both numerical and categorical columns.
Example: imputer = Imputer(inputCols=['col1', 'col2'], outputCols=['col1_imputed', 'col2_imputed'], strategy='mean')
Example: imputed_df = impute...
What people are saying about HSBC Group
To delete duplicate rows from a table, use the DISTINCT keyword or GROUP BY clause.
Use the DISTINCT keyword to select unique rows from the table.
Use the GROUP BY clause to group the rows by a specific column and select the unique rows.
Use the DELETE statement with a subquery to delete the duplicate rows.
Create a new table with the unique rows and drop the old table.
Null values in PySpark are handled using functions such as dropna(), fillna(), and replace().
dropna() function is used to drop rows or columns with null values
fillna() function is used to fill null values with a specified value or method
replace() function is used to replace null values with a specified value
coalesce() function is used to replace null values with the first non-null value in a list of columns
SQL query to retrieve the second highest salary from each department
Use the RANK() function to assign a rank to each salary within each department
Filter the results to only include rows with a rank of 2
Group the results by department to get the second highest salary for each department
Window functions are used to perform calculations across a set of rows that are related to the current row.
Commonly used window functions include ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, FIRST_VALUE, LAST_VALUE, and NTILE.
Window functions are used in conjunction with the OVER clause to define the window or set of rows to perform the calculation on.
Window functions can be used to calculate running totals, moving av...
Merge two unsorted lists into a sorted list using inbuilt sorting functions.
Use inbuilt sorting functions to sort the input lists
Merge the sorted lists using a merge algorithm
Return the merged and sorted list
Skewness is a measure of asymmetry in a distribution. Skewed tables are tables with imbalanced data distribution.
Skewness is a statistical measure that describes the asymmetry of the data distribution around the mean.
Positive skewness indicates a longer tail on the right side of the distribution, while negative skewness indicates a longer tail on the left side.
Skewed tables in data engineering refer to tables with...
HSBC Group Data Engineer Interview Experiences
6 interviews found
Anonymous
I applied via Walk-in and was interviewed in Apr 2024. There were 3 interview rounds.
(2 Questions)
- Q1. What is lazy evaluation in spark.
- Ans.
Lazy evaluation in Spark delays the execution of transformations until an action is called.
Lazy evaluation allows Spark to optimize the execution plan by combining multiple transformations into a single stage.
Transformations are not executed immediately, but are stored as a directed acyclic graph (DAG) of operations.
Actions trigger the execution of the DAG and produce results.
Example: map() and filter() are transformat...
- Q2. What is mapreduce
- Ans.
MapReduce is a programming model and processing technique for parallel and distributed computing.
MapReduce is used to process large datasets in parallel across a distributed cluster of computers.
It consists of two main functions - Map function for processing key/value pairs and Reduce function for aggregating the results.
Popularly used in big data processing frameworks like Hadoop for tasks like data sorting, searching...
(1 Question)
- Q1. What is skewness and skewd tables
- Ans.
Skewness is a measure of asymmetry in a distribution. Skewed tables are tables with imbalanced data distribution.
Skewness is a statistical measure that describes the asymmetry of the data distribution around the mean.
Positive skewness indicates a longer tail on the right side of the distribution, while negative skewness indicates a longer tail on the left side.
Skewed tables in data engineering refer to tables with imba...
(1 Question)
- Q1. What is spark and explain working
- Ans.
Spark is a distributed computing framework designed for big data processing.
Spark is built around the concept of Resilient Distributed Datasets (RDDs) which allow for fault-tolerant parallel processing of data.
It provides high-level APIs in Java, Scala, Python, and R for ease of use.
Spark can run on top of Hadoop, Mesos, Kubernetes, or in standalone mode.
It includes modules for SQL, streaming, machine learning, and gra...
Interview Preparation Tips
- Big Data
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
(3 Questions)
- Q1. About past experience
- Q2. Python Coding question about list, dataframe etc
- Q3. RDBMS Questions and SQL theory
Interview Preparation Tips
Selected
I applied via Job Portal and was interviewed in Jul 2024. There was 1 interview round.
English, aptitude test, reasoning
Interview Preparation Tips
(2 Questions)
- Q1. Behavioral test
- Q2. Questions will be repeated randomly we need to select the same response if we could which will assess our behaviors
(2 Questions)
- Q1. Technical discussion
- Q2. Project scenario based
I applied via Naukri.com and was interviewed in Apr 2022. There were 4 interview rounds.
(6 Questions)
- Q1. What is imputer function in PySpark
- Q2. How do you handles null values in PySpark
- Ans.
Null values in PySpark are handled using functions such as dropna(), fillna(), and replace().
dropna() function is used to drop rows or columns with null values
fillna() function is used to fill null values with a specified value or method
replace() function is used to replace null values with a specified value
coalesce() function is used to replace null values with the first non-null value in a list of columns
- Q3. SQL query for getting 2nd highest salary from each department
- Ans.
SQL query to retrieve the second highest salary from each department
Use the RANK() function to assign a rank to each salary within each department
Filter the results to only include rows with a rank of 2
Group the results by department to get the second highest salary for each department
- Q4. How to delete duplicate rows from a table
- Ans.
To delete duplicate rows from a table, use the DISTINCT keyword or GROUP BY clause.
Use the DISTINCT keyword to select unique rows from the table.
Use the GROUP BY clause to group the rows by a specific column and select the unique rows.
Use the DELETE statement with a subquery to delete the duplicate rows.
Create a new table with the unique rows and drop the old table.
- Q5. What are the window functions you have used?
- Ans.
Window functions are used to perform calculations across a set of rows that are related to the current row.
Commonly used window functions include ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, FIRST_VALUE, LAST_VALUE, and NTILE.
Window functions are used in conjunction with the OVER clause to define the window or set of rows to perform the calculation on.
Window functions can be used to calculate running totals, moving average...
- Q6. Merge two unsorted lists such that the output list is sorted. You are free to use inbuilt sorting functions to sort the input lists
- Ans.
Merge two unsorted lists into a sorted list using inbuilt sorting functions.
Use inbuilt sorting functions to sort the input lists
Merge the sorted lists using a merge algorithm
Return the merged and sorted list
(1 Question)
- Q1. 1. What is udf in Spark? 2. Write PySpark code to check the validity of mobile_number column
- Ans.
UDF stands for User-Defined Function in Spark. It allows users to define their own functions to process data.
UDFs can be written in different programming languages like Python, Scala, and Java.
UDFs can be used to perform complex operations on data that are not available in built-in functions.
PySpark code to check the validity of mobile_number column can be written using regular expressions and the `regexp_extract` func...
(1 Question)
- Q1. 1. Salary discussion 2. Why do you want to join HSBC? 3. Tell me a challenge that you faced and how did you overcome it?
Interview Preparation Tips
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There were 3 interview rounds.
Was based on behaviour and cognitive interview round
(2 Questions)
- Q1. Pure technical round based on your skills
- Q2. SQL basic and detailed level interview like Joins, Index, performance tunning, Partition etc
(1 Question)
- Q1. Asked to Fill the Form ad basic details and Current and Expected CTC
Interview Preparation Tips
Interview questions from similar companies
Raunak Chitlangia
I applied via Campus Placement
Interview Preparation Tips
Experience: My resume had a couple of projects and a paper publication added to it, which was a part of my second year intern at TCS Innovation Labs.
Tips: I believe that the resume shortlist to appear for the test is just a formality and not a big deal to get through. Most of the students are allowed to appear for the test which is where, the main shortlisting occurs.
Although, the company does cut off people from certain departments. For example, none of the Agriculture and food engineering students were shortlisted for appearing for the test.
Also, from what I have heard, the company runs resumes through a program to take out the shortlist. Hence, certain key words such as "Scholar" or "Conference" may get you a good chance to get through the shortlisting.
Round: Test
Experience: The test is mainly quant based and how fast you can think and rationalize. They expect excellent speed; they ask you 20 questions to be answered in 30 minutes.
Tips: Normally, if a student is asked to appear for this right after his JEE examination, he would be able to get through it easily. But since our analytical thinking goes way down once we actually get in, it has to be worked upon again. I'd suggest you to solve all the quant questions of any CAT preparatory book for the American Express test. The test questions are quite similar to those that the CAT students prepare for.
Round: Technical Interview
Experience: In general, the American Express interviews are considered to be pretty peaceful compared to the interviews of other companies. I was just asked about my work at TCS Innovation Labs and the paper I would be publishing based on that work and the courses I have done in Data Analytics and what all do I know in it. They do not test the knowledge you say you possess.
Tips: While I was preparing for my interview, I was told to read about Amex and its products. Secondly, and most importantly, I was aksed to read a lot about credit card frauds and suggest ways of preventing that. Even during my time, a lot of people were asked about this and judged severely on that. This is a must must if you would be appearing for its interview.
Also, you would do well if you are able to connect with the interviewer. For instance, if both of you have been a part of the same inter IIT or have the same tastes, etc.
Also, the interviews are that peaceful that you are able to direct the interview in your favour. There are certain parts of your CV that you can easily talk about and certain parts that you would want to avoid. If you are able to think on your feet, it is easy to re direct the interview in your favour and the things that you would like to talk about; in my case, it was my work at TCS.
Round: Puzzle Interview
Experience: The main decision whether you have to be taken in or not is decided in your first round of interview after which, the puzzle interview is just a formality and to find out whether you are able to think on your feet or not. Not a big deal, pretty easy.
Tips: Nothing to be worried about, the puzzles asked are pretty easy and most probably, you would have already heard them if you have a nag of solving puzzles.
General Tips: Do not worry or stress yourself much. The interview is pretty easy if you have an edge in the skills that the company wants. I had started studying Data Analytics in my second year summer vacations, just 1 hour a day for hardly about a month. Which gave me enough of an edge. The main hurdle lies in getting through the test round where about 300 people are simply cut off.
Skill Tips: You should be able to code efficiently. Knowledge in Python and SQL is a big plus.
Also, I had done a course on Coursera called "Machine Learning" of Stanford University. Today, the company does not expect a lot of knowledge in Data Analytics from students which is why this course gave me the edge I needed to get through the interview. It's a pretty easy course and not very demanding. I would recommend this if you want to find out even whether you'd be interested in Data Analytics or not.
I was asked about the things I know and whether I have ever implemented them.
Skills: Analytics And Coding
Duration: 2
College Name: IIT Kharagpur
Motivation: American Express is known to have a good working culture and is currently the third best company to work for in India. The internship stipend is largest compared to any other company in India along with accommodation and travel. The company has a well structured internship program and also has good challenging work to offer.
Funny Moments: After the test, I was not shortlisted for the interview round.. Which broke my heart.
Just after the presentation, I walked up to the person presenting and handed him a hard copy of my resume asking him to at least give me a shot at the interview if they think my profile is good enough.
I believe that this was a turning point of this entire experience. I believe, at that moment itself, I gained their favour to take me in. Which is probably why my interview was peaceful, which is probably why I could get through even though my interview was the last among a bunch of 25 students..
Sharat chandra
Interview Questionnaire
1 Question
- Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.
Interview Preparation Tips
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.
Interview Questionnaire
8 Questions
- Q1. Find a number which occurs odd number of times and all number occurs even number of times
- Q2. Some discussion about my minor project
- Q3. Spiral order of binary tree and mattrix, print it
- Q4. Some question about os,dbms
- Q5. Find pair which have a given sum in a given array
- Q6. Find total number of k element which have a given avg in a given array in minimum time complexity
- Q7. Print all elements which in not boundary element in a given binary tree
- Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question
Interview Preparation Tips
Experience: practice codes on paper
Tips:
Round: Technical Interview
Experience: very good
Tips: please try to explain each and every question in detail
Round: Technical Interview
Experience: my hr round is not taken by them,and some of face 3rd round ,which is HR
Tips: please prepare all types of problem from geeksforgeeks
Skill Tips: please try to understand every problem from geeksforgeeks
Skills: ds
College Name: NIT Bhopal
Motivation: best work culture,and a lots of learning opportunity in this company,and in every 6 month there is a appraisal
Skills evaluated in this interview
I appeared for an interview in Oct 2016.
Interview Questionnaire
4 Questions
- Q1. Select any five companies you would invest in and why given the required metrics.
- Ans.
I cannot provide investment advice, but here are five companies that have shown strong financial performance in recent years.
Apple - consistently high revenue and profit margins
Amazon - dominant player in e-commerce and cloud computing
Microsoft - strong growth in cloud computing and enterprise software
Alphabet (Google) - diversified revenue streams and strong advertising business
Visa - dominant player in the payments i...
- Q2. Questions based on case study.
- Q3. Detailed discussions on the indian economy?
- Q4. Brexit vote and how it would effect the indian economy?
- Ans.
The Brexit vote could have both positive and negative effects on the Indian economy.
Positive effects: Increased trade opportunities with the UK, potential for attracting foreign investments from companies relocating from the UK.
Negative effects: Uncertainty in global markets leading to volatility in exchange rates, potential decline in exports to the UK.
Example: Indian IT companies may face challenges due to stricter i...
Interview Preparation Tips
Experience: We were first taught the basics of operations involved in working with an investment bank. Based on the workshop we were given a case study with a list of companies to select the one's which are potencial candidates for investments. We were all divided into groups of 5 students.
Round: Test
Experience: The test was basic. Economical aptitude requires prior knowledge of economics concepts. The review topicwas GST bill.
Duration: 1 hour
Total Questions: 41
Round: Stress Interview
Tips: It is important to be aware about the current events and economies.
Skills: Economic Affairs, Financial Economics, Knowledge On Current Affairs
College Name: Thapar University, Patiala
HSBC Group Interview FAQs
Some of the top questions asked at the HSBC Group Data Engineer interview -
Tell us how to improve this page.
HSBC Group Interviews By Designations
- HSBC Group Software Engineer Interview Questions
- HSBC Group Assistant Manager Interview Questions
- HSBC Group Analyst Interview Questions
- HSBC Group Business Analyst Interview Questions
- HSBC Group Senior Software Engineer Interview Questions
- HSBC Group Software Engineer Trainee Interview Questions
- HSBC Group Senior Analyst Interview Questions
- HSBC Group Software Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Senior Engineer Interview Questions
- System Engineer Interview Questions
- Data Analyst Interview Questions
- Senior Data Engineer Interview Questions
- Developer Interview Questions
- Azure Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 5 interview experiences
Difficulty level
Duration
Data Engineer Interview Questions from Similar Companies
HSBC Group Data Engineer Reviews and Ratings
based on 8 reviews
Rating in categories
|
Assistant Manager
2.8k
salaries
|  ₹6 L/yr - ₹13.5 L/yr |
|
Manager
2.2k
salaries
| ₹13.9 L/yr - ₹24 L/yr |
|
Senior Software Engineer
1.7k
salaries
| ₹13 L/yr - ₹23.7 L/yr |
|
Assistant Vice President
1.7k
salaries
| ₹25 L/yr - ₹42.5 L/yr |
|
Software Engineer
1.5k
salaries
| ₹7.8 L/yr - ₹14 L/yr |
Wells Fargo
JPMorgan Chase & Co.
Cholamandalam Investment & Finance
Citicorp
- Home >
- Interviews >
- HSBC Group Interview Questions
