HSBC Group Data Analyst Interview Questions and Answers

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
Answered by AI
Add your answer
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
Answered by AI
Add your answer

Online self paced test

Q1. Python and sql problem solving questions
Add your answer

Q1. About Data Analyst Role
Add your answer
Q2. Queries on SQL and Python
Add your answer

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
Answered by AI
Add your answer

Q1. Chatting about my project and working experience, asked about data dimension modeling
Add your answer