HSBC Group Senior Data Engineer Interview Questions and Answers

Medium leetcode question on array list

Q1. Core java and collections, exceptions and threading
Add your answer
Q2. Core java collections
Add your answer
Q3. Multi threading
Add your answer
Q4. Executor framework
Add your answer

Q1. Threading related questions
Add your answer

Test was for Web Development - React
75min test
3 Questions
1 Coding Question
2 Scenario based questions

Q1. React Optimization techniques
Add your answer
Q2. React Advantages
Add your answer

Q1. How to debug in production environment?
Add your answer

Q1. Challenges faced during work and how you overcome?
Add your answer

Q1. Why you choose Wells fargo over other offers?
Add your answer

Q1. Sorting of 1d array
Ans. 
Sorting a 1d array of strings
• Use a sorting algorithm like bubble sort, selection sort, or merge sort

• Consider using built-in sorting functions in programming languages like sort() in Python or Arrays.sort() in Java

• Ensure to compare strings correctly based on their ASCII values
Answered by AI
Add your answer
Q2. Basics of Camunda, Java and Spring boot.
Add your answer

1 coding question based on DP for 25 minutes and 30 MCQs on Java , OOPS and code snippet questions also some basic questions based on trees like number of leaf nodes in a complete binary tree with n nodes.

Q1. Write code for finding palindrome of a string
Ans. 
Code to find palindrome of a string
• Iterate through the string from both ends and compare characters

• Use two pointers, one starting from the beginning and one from the end

• If characters at both pointers match, continue checking until they meet in the middle

• If all characters match, the string is a palindrome
Answered by AI
Add your answer
Q2. What is dynamic memory allocation in Java
Ans. 
Dynamic memory allocation in Java refers to the process of allocating memory for objects at runtime.
• Dynamic memory allocation allows for objects to be created and destroyed during program execution.

• The 'new' keyword is used to dynamically allocate memory for objects in Java.

• Dynamic memory allocation helps in managing memory efficiently by allocating memory only when needed.

• Example: int[] arr = new int[5]; dynamically a
Answered by AI
Add your answer
Q3. You are designing an e commerce website which database will you choose and what will you use for authentication given that you can't use JWT or even third party like Google authentication
Ans. 
I would choose a relational database like MySQL and implement a custom authentication system using session management.
• Choose a relational database like MySQL for storing user data, product information, and orders.

• Implement a custom authentication system using session management to securely authenticate users without JWT or third-party services.

• Use encryption techniques to store and validate user passwords securely.

• Util...read more
Answered by AI
Add your answer

Aptitude was very basic.

Q1. What is constant?
Ans. 
A constant is a value that does not change during the execution of a program.
• Constants are used to store values that remain the same throughout the program.

• They are declared using the 'const' keyword in many programming languages.

• Examples include mathematical constants like pi (3.14159) or physical constants like the speed of light (299,792,458 m/s).
Answered by AI
Add your answer
Q2. What is object oriented programming?
Ans. 
Object oriented programming is a programming paradigm based on the concept of objects, which can contain data and code.
• Objects are instances of classes, which define the structure and behavior of the objects.

• Encapsulation, inheritance, and polymorphism are key principles of object oriented programming.

• Example: Inheritance allows a subclass to inherit attributes and methods from a superclass.
Answered by AI
Add your answer

Q1. Salary Negotiation
Add your answer
Q2. Work culture description
Ans. 
Our work culture is collaborative, innovative, and focused on continuous learning and growth.
• Encourages teamwork and open communication

• Emphasizes creativity and problem-solving

• Provides opportunities for professional development

• Values diversity and inclusion

• Promotes a healthy work-life balance
Answered by AI
Add your answer

Q1. Spring related questions
Add your answer
Q2. Java related questions
Add your answer
Q3. Couple of coding questions (Easy)
Add your answer

Basic aptitude test like distance problem , age etc

Q1. Explain error handling in PySpark
Ans. 
Error handling in PySpark involves using try-except blocks and logging to handle exceptions and errors.
• Use try-except blocks to catch and handle exceptions in PySpark code

• Utilize logging to record errors and exceptions for debugging purposes

• Consider using the .option('mode', 'PERMISSIVE') method to handle corrupt records in data processing
Answered by AI
Add your answer

Q1. Data Warehousing related questions
Add your answer

Q1. Data Modelling related questions
Add your answer