United Overseas Bank Data Engineer Interview Questions and Answers

Maths and coding questions were asked

Two questions for coding

Q1. Dsa , core cs subjects
Add your answer
Q2. Sort the array using merge sort
Ans. 
Merge sort is a divide and conquer algorithm that recursively divides the array into halves and then merges them in sorted order.
• Divide the array into two halves

• Recursively sort each half

• Merge the sorted halves back together
Answered by AI
Add your answer
Q3. Core subjects questions
Add your answer

Q1. Why you choosed hsbc
Add your answer

Round duration - 45 Minutes
Round difficulty - Easy

The interviewer was friendly. Explained the question well. Allowed to use any preferred platform to write code.

Q1. 
Best Time to Buy and Sell Stock Problem Statement
Given an array prices representing the prices of a stock where each element indicates the price at a given minute, determine the maximum profit you can ac...read more
Ans. 
Find the maximum profit by buying and selling a stock once based on given prices.
• Iterate through the prices array and keep track of the minimum price seen so far and the maximum profit achievable.

• Calculate the profit by subtracting the current price from the minimum price and update the maximum profit if needed.

• Return the maximum profit, ensuring it is not negative.

• Example: prices = [2, 100, 150, 120], Buy at 2, sell a
Answered by AI
View 1 more answer

Round duration - 60 Minutes
Round difficulty - Medium

Q1. 
Dance Team Pairing Challenge
Imagine you are helping Ninja, a dance coach, who needs to form dance pairs from the available boys and girls in a studio. Given the number of boys N, the number of girls M, a...read more
Ans. 
The challenge involves forming dance pairs from available boys and girls based on potential pairings to maximize the number of pairs.
• Parse the input to get the number of test cases, boys, girls, and potential pairings.

• Iterate through the potential pairings and form pairs based on the given indexes.

• Output '1' if a set of maximum possible pairs is returned, else output '0'.

• There can be multiple valid configurations of pa...read more
Answered by AI
Add your answer
Q2. What is the difference between multiprocessing and multithreading?
Ans. 
Multiprocessing involves multiple processes running concurrently, while multithreading involves multiple threads within a single process.
• Multiprocessing utilizes multiple processes to execute tasks simultaneously.

• Multithreading involves multiple threads within a single process sharing the same memory space.

• Multiprocessing is typically used for CPU-bound tasks, while multithreading is more suitable for I/O-bound tasks.

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

Round duration - 60 Minutes
Round difficulty - Hard

Q1. Can you describe the classes and functions involved in the design of a system like Splitwise?
Ans. 
Splitwise is a system for managing shared expenses among groups of people.
• Classes: User, Expense, Group

• Functions: addExpense(), settleUp(), calculateBalance()
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Hard

Q1. Basics of spark , Hadoop,sql, python
Add your answer

Q1. Building a pipeline
Ans. 
Building a pipeline involves creating a series of interconnected data processing steps to move and transform data from source to destination.
• Identify data sources and destinations

• Determine the data processing steps required

• Choose appropriate tools and technologies

• Design and implement the pipeline

• Monitor and maintain the pipeline
Answered by AI
Add your answer

Q1. Resume based questions
Add your answer

Q1. Where do you see yourself in 5 years
Ans. 
In 5 years, I see myself as a senior data engineer leading a team, implementing innovative solutions, and driving data-driven decision-making.
• Leading a team of data engineers

• Implementing innovative solutions to optimize data processing and analysis

• Driving data-driven decision-making across the organization

• Continuously learning and staying updated with the latest technologies and trends in data engineering

• Contributing t
Answered by AI
Add your answer

Q1. Automation done
Add your answer

There was a Coding test on Hackerrank platform of 2 hrs

Q1. Tell me about yourself
Add your answer
Q2. What are your Salary expectations
Add your answer