AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
HSBC Group
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
HSBC Group Data Analyst Interview Questions and Answers
HSBC Group Data Analyst Interview Experiences
7 interviews found
Anonymous
I was interviewed in Sep 2024.
(2 Questions)
- Q1. Load data from hdfs using python
- Ans.
Use PyArrow library to load data from HDFS in Python
Install PyArrow library using pip install pyarrow
Use pyarrow.hdfs.connect to connect to HDFS
Use pyarrow.parquet.read_table to read data from HDFS
- Q2. Query to find the top three salaried employees of each department
- Ans.
Query to find the top three salaried employees of each department
Use a SQL query with a window function like ROW_NUMBER() to rank employees within each department based on salary
Partition the data by department and order by salary in descending order
Filter the results to only include rows where the row number is less than or equal to 3
Skills evaluated in this interview
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
Online self paced test
(1 Question)
- Q1. Python and sql problem solving questions
I applied via Company Website and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. About Data Analyst Role
- Q2. Queries on SQL and Python
(1 Question)
- Q1. Tellme about yourself
- Ans.
I am a data analyst with a strong background in statistics and data visualization.
Experienced in analyzing large datasets to extract valuable insights
Proficient in statistical analysis and data visualization tools like Python, R, and Tableau
Strong problem-solving skills and attention to detail
Excellent communication skills to present findings to stakeholders
HSBC Group interview questions for designations
I applied via Job Portal and was interviewed before Dec 2023. There was 1 interview round.
Basic SQL Questions. Joins, Aggregate function, Window function
Srinjan Bagchi
Selected
I applied via Campus Placement and was interviewed before Dec 2023. There were 5 interview rounds.
Typical Apti with basic QA and Verbal Ability questions.
Topic given around for a GD consisting of 10 people
(5 Questions)
- Q1. Tell me about yourself.
- Ans.
I am a data analyst with a strong background in statistics and data visualization.
Experienced in analyzing large datasets to extract valuable insights
Proficient in using tools like SQL, Python, and Tableau
Strong communication skills to present findings to stakeholders
- Q2. Discussion about relevant experience regarding Data Science and Algorithms.
- Q3. Asked to define Predictive vs Prescriptive analytics.
- Q4. A case scenario to define how I will do a data visualization for best understanding. Define XG Boost in ML.
- Q5. Questions pertaining my major projects, and what algorithms I used. Explaining those.
A problem statement on how a farmer can't repay his loan, and how will I approach this problem. Second, a case scenario regarding a global economic problem, and How will I approach to solve it, with the thought map.
(2 Questions)
- Q1. Salary discussion and expectations
- Q2. Job location discussions
Interview Preparation Tips
- Data Science
- SQL
- Python
- Machine Learning
(1 Question)
- Q1. Chatting about my project and working experience, asked about data dimension modeling
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I was interviewed 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
Interview Questionnaire
1 Question
- Q1. Explain about self introduction
I applied via Walk-in and was interviewed in Apr 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. About your self
Interview Preparation Tips
HSBC Group Interview FAQs
Recently Viewed
INTERVIEWS
Infosys
No Interviews
DESIGNATION
INTERVIEWS
Accenture
No Interviews
SALARIES
Himadri Speciality Chemical
INTERVIEWS
Lexmark International
No Interviews
INTERVIEWS
Genpact
No Interviews
SALARIES
SHYAM METALICS AND ENERGY
LIST OF COMPANIES
Discover companies
Find best workplace
DESIGNATION
INTERVIEWS
Fineotex Chemical
No Interviews
Tell us how to improve this page.
HSBC Group Interviews By Designations
- HSBC Group Assistant Manager Interview Questions
- HSBC Group Software Engineer 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 Software Developer Interview Questions
- HSBC Group Senior Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
HSBC Group Data Analyst Interview Process
based on 8 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
HSBC Group Data Analyst Reviews and Ratings
based on 19 reviews
Rating in categories
|
Assistant Manager
2.6k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Manager
2.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Software Engineer
1.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Assistant Vice President
1.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Software Engineer
1.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Standard Chartered
ICICI Bank
Axis Bank
HDFC Bank
- Home >
- Interviews >
- HSBC Group Interview Questions >
- HSBC Group Data Analyst Interview Questions
