Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by UBS Team. If you also belong to the team, you can get access from here

UBS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

UBS Data Engineer Interview Questions and Answers

Updated 16 Apr 2024

UBS Data Engineer Interview Experiences

3 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 16 Apr 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Coding questions on sql python and spark

Round 2 - Technical 

(2 Questions)

  • Q1. Hacker rank code pair
  • Ans. 

    Implement a function to pair elements of an array based on a given sum.

    • Iterate through the array and check if the current element plus any other element equals the given sum.

    • Use a hash set to store elements already visited to avoid duplicate pairs.

    • Return an array of arrays containing the pairs that sum up to the given value.

  • Answered by AI
  • Q2. Pyspark questions
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Aug 2023. There were 2 interview rounds.

Round 1 - Coding Test 

7 sql questions of easy to medium , 2 python questions, 1 pyspark question

Round 2 - One-on-one 

(1 Question)

  • Q1. Scenatio based, project questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 22 Apr 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
6-8 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Overall question on resume
  • Q2. This is mainly from your resume & your profile for which the process is happening.
Round 3 - Technical 

(1 Question)

  • Q1. Second Round as well was on Credit Risk
Round 4 - One-on-one 

(1 Question)

  • Q1. Credit Risk + Technical stuff like SQL, IFRS9

Data Engineer Jobs at UBS

View all

Interview questions from similar companies

Software Engineer Interview Questions & Answers

Barclays user image Shubham Srivastava

posted on 30 Jan 2016

Interview Preparation Tips

Round: Test
Experience: General aptitude consisted of quantitative questions .There were 6 questions and suggested time as 10 minutes. Questions were of easy level. Questions based on numbers,distance,time etc..Answers of general aptitude were to be written in textbox. eg ans is 4,write 4. there were no options in quant. Answers were integers an easy.
Technical comprehension involved two paragraphs and questions based on sql.
Logical analysis contained questions of logical deduction mainly.
Program tracing involved finding output of programs(mainly while loop and if else)..
Programming : There was only one question of programming(to be solved in 30 minutes). Code was given and was to be modified.Modification involved like , find out the least salary of employees,... (they used file input output and structures).

Tips: Practice basic aptitude.Concepts should be clear.
Duration: 90 minutes
Total Questions: 18

Skills: Basic C/C++, Logical Thinking, Logical Reasoning, General Aptitude
College Name: NIT Raipur

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

  • Answered by AI
  • 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...

  • Answered by AI

Interview Preparation Tips

Round: Case Study Interview
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 Preparation Tips

Round: Test
Experience: There were 15 questions from quant’s, 10 questions from data interpretation with 1 mark each and -.5 for wrong answer also there were 2 case studies with 10 marks each with no –ve marks. Total 45 marks question, I did only 9 from quant and 7 from DI total 16 out of 25 questions and didn’t touch case studies. Quanta and DI were very basics level.

In those 16, 1 question was wrong so basically I did 14.5 out of 45, but with a accuracy of 90%. Didn’t expect to get shortlisted but was very tensed and angry upon myself coz it was my level paper. But around 12 mid night shortlist came and I was at 11th position out of 31 students in the list.

There were total around 90 students who appeared for written test. They allowed Mtech and Mca guys not Btech.
Total Questions: 25

Round: TECHNICAL INTERVIEW
Experience: I went there and greeted him. Firstly he told me to introduce myself, later he asked what I like the most. I told analytical thinking and logical reasoning and yeah I relate it with data base.(since I knew they came for Data analyst profile).

He asked me about join, gave me a table and told me to perform all joins. I did that and he asked me about Order by clause and, having clause then asked me normal forms up to bcnf.

Later asked about pl/sql difference b/w sql and pl/sql, what is trigger explain in detail. Some basics questions of DBMS theory asked me about my 2 projects and at the end he gave me a situation where I have a grocery shop outside nit Surathkal, and from last few days/months I realized a downfall in sales, what possible reasons could I find? I gave him 8 reasons within 2/3 mins. He was impressed…

After 1st round out of 31 only 13 were selected and I was there in d list.

Round: TECHNICAL INTERVIEW
Experience: As soon as I entered the room, mam told me “Ooo tum aao aao ”. I smiled because I was the 1st guy during presentation who asked the first question (she made every1 clap for me there) and she remembered my face. And eventually she did study from IIT Kanpur so yes she was able to speak fluent Hindi (plus point for guys like me :p). with her there was a guy he asked me to write code for taking a no and converting it into binary and 1 question from array- very simple later she gave me a table with employee id, order date and order amount. A customer can place max 1 order in 1 day. I had to find the latest transaction of every customer with amount as well. i did it using max function over date and group by with sub query, she asked me about my resume at the end she gave me 7,9,21,63,100 and told me to find the no of numbers between 1 to 50000 which are exactly divisible by all, i did it in 1 min.

but she was smiling, I thought I made some mistake in hurry, then I asked mam m I doing right or wrong (in curiosity as I find very comfortable there) she smiled and said “Chalo bhago ynha se ye interview h ”.I said sorry but yeah she was impressed with my interview so told ki “you will learn all these things very quickly”.

Round: TECHNICAL INTERVIEW
Experience: After 2nd round 9 were selected and I was one of them. It was basically a Managerial round and it scheduled over Skype. I had to introduce myself as well as my family background. Here comes the harder part when he asked me why you have such a poor academic back ground? I was speechless for a moment but I started telling the truth.

I told despite getting 68% marks in my 10th I was the third topper of my class. I got 60.66 % in 12th but yeah there also out of 700 students only 14 got first division. So basically I concluded that in my state board marking is not that much good. He said ok but what happened in graduation(64%) when you studied in Delhi?(what to say now :p) I said sir I did it from IGNOU and you can Google the fact that even less than 5% of student are able to clear the degree in 3 years. Later I explicitly mentioned that I m not blaming my boards but this is the fact which can’t be change.

Now He asked what happened in PG here also you scored only 7.50 CGPA which is less than even standard score of 8(Meri to jaan hi nikal gayi :p). Then I told him that sir u can see my pointer in first semester is very less close to 6.5 but after that I constantly improved myself. He was smiling …..

He asked me about my family background and then I told him how I struggled, I was giving tuition in my grads to continue my education and after grads took a gap of 1 year and cleared all MCA entrance examination and now sitting in front of him.

Later asked about my best qualities….i told him that I can lead group of people very well. I gave example of me being captain of my department cricket team and I was class monitor through 3rd to 12th std and also some stuff regarding my college events. He noted down something .I don’t know what.

I was not sure that I could clear that interview. When the result came they called all 9 students and said that they find is difficult to eliminate 4 names .i was sure that I m out of picture now but fortunately my name was at 2nd position. Wowwwww

Round: HR Interview
Experience: It was telephonic round and just my hobbies and all, he asked me about my poetry writing hobby as well as Hindi Shayaris. I was told to recite 1 …when he listened, he was very impressed…

College Name: IIT KANPUR

Interview Preparation Tips

Round: Test
Experience: Study data interpretation (calculator allowed) and pattern puzzles

Round: Group Discussion
Experience: Two topics (have been same case studies for past 4 years now): - Mobile app improvement - Making a business decision

Round: HR Interview
Experience: Everything depends only on HR interview
Tips: Make a list of your strengths and an example for each!

Round: Technical Interview
Experience: Short, easy and basic questions asked about projects and DS. Pretty chilled

College Name: Sardar Patel Institute of Technology

Interview Questionnaire 

11 Questions

  • Q1. 1st technical round
  • Q2. How you will find the smallest of 4 numbers without using >.< and min function using java
  • Ans. 

    Finding smallest of 4 numbers without using >.< and min function in Java.

    • Initialize a variable with the first number

    • Compare it with the remaining numbers using if-else statements

    • If a smaller number is found, update the variable

    • Repeat until all numbers are compared

    • The final value of the variable will be the smallest number

  • Answered by AI
  • Q3. Write a code for palindrome
  • Ans. 

    Code for palindrome checking

    • Convert the input to lowercase to ignore case sensitivity

    • Use two pointers, one at the start and one at the end of the string

    • Compare the characters at both pointers and move them towards each other

    • If all characters match, it's a palindrome

  • Answered by AI
  • Q4. Write any javascript code
  • Ans. 

    Javascript code to display 'Hello World!' on the webpage

    • Create a new HTML file

    • Add a script tag with 'type' attribute set to 'text/javascript'

    • Inside the script tag, use document.write() to display 'Hello World!'

  • Answered by AI
  • Q5. Swap two number without using temperory variable
  • Ans. 

    Swap two numbers without using a temporary variable.

    • Use addition and subtraction to swap the values

    • Use XOR operator to swap the values

    • Use multiplication and division to swap the values

  • Answered by AI
  • Q6. How you will add 2 table
  • Ans. 

    To add 2 tables, we need to use a join operation on a common column.

    • Identify the common column between the tables

    • Choose the appropriate join type (inner, outer, left, right)

    • Write the SQL query to join the tables

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

  • Answered by AI
  • Q7. Difference between union and union all
  • Ans. 

    Union combines and removes duplicates, Union All combines all rows including duplicates.

    • Union is used to combine the result sets of two or more SELECT statements and remove duplicates.

    • Union All is used to combine the result sets of two or more SELECT statements and includes all rows, including duplicates.

    • Union is slower than Union All as it has to remove duplicates.

    • Union requires the same number of columns in all SELEC...

  • Answered by AI
  • Q8. They provide an instance, and tell us to write a query for that
  • Q9. Tell me about yourself
  • Q10. The worst situation during your internship period
  • Ans. 

    Being assigned a project with unrealistic deadlines and minimal guidance

    • Received a project with tight deadlines and unclear requirements

    • Struggled to meet the deadlines due to lack of guidance and support

    • Had to work long hours and weekends to try to complete the project

    • Learned the importance of clear communication and setting realistic expectations

  • Answered by AI
  • Q11. How you will overcome from that worst situation

Interview Preparation Tips

Round: Test
Experience: The question were not that much difficult. Many apti questions are easy. Technical was very easy for me.
The questions were fully based on java, c and SQL. 7 to 8 questions are from SQL. But all are straight forward questions. Other 2 sections were easy and any student who had a good sort of thinking ability can able to solve those questions.
Tips: Just refer all the basic topics in java, c and sql.
Duration: 60 minutes
Total Questions: 50

Round: Technical Interview
Experience: It was fully based on the final sem project which i was doing.
Since my project is company's employee portal, i was asked about that. They will dig into deep with respect to that project.
Tips: U should be aware of each and everything in your project which you are going to explain them. The question which they use to ask is really unpredictable.

Round: Technical Interview
Experience: This is pure technical round where i was asked the questions which is easy but takes time to think. Anyhow, i answered all these questions and get into the next round.
Tips: Logical thinking matters. Though questions look easier, sometimes we co calculate with wrong manner.
So keep calm and think in a broader manner.

Round: Technical Interview
Experience: Technical round with pure database stuffs. I was asked only few question in this. Since it was straight forward, i answered all the questions.

Round: HR Interview
Experience: Confidence really matters. Though i was not that much good in conversing, i spoke with brave and confidently which makes me to became a part of the barclays team.

General Tips: Be confident enough and answer them what you know.
Talking too much as well as taking less is also a problematic.
Skills: Logical thinking, Technical skills ( Especially about database )
College Name: MANIPAL INSTITUTE OF TECHNOLOGY, MANIPAL
Motivation: Credits should goes to my bro who motivates me to apply to this comapny.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.

Interview Preparation Tips

Round: Test
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.

I was interviewed before Jun 2016.

Interview Questionnaire 

6 Questions

  • Q1. Tell me about yourself from the day u were born till today (Stopped mid way when I mentioned the finance course)
  • Q2. What is a Brownian motion? Properties of Brownian motion?
  • Ans. 

    Brownian motion is the random motion of particles in a fluid due to collisions with other particles.

    • Brownian motion was first observed by Robert Brown in 1827.

    • It is named after the botanist Robert Brown.

    • The motion is caused by the random movement of fluid molecules.

    • Brownian motion is a continuous-time stochastic process.

    • It is often used to model various phenomena in physics, finance, and biology.

    • Properties of Brownian ...

  • Answered by AI
  • Q3. What is a Martingale? What are Markov Processes? Is Martingale a Markov Process? Are Markov Processes Martingales?
  • Ans. 

    A Martingale is a mathematical concept used in probability theory and statistics. Markov Processes are stochastic processes that satisfy the Markov property.

    • A Martingale is a sequence of random variables where the expected value of the next variable, given the current and past variables, is equal to the current variable.

    • Markov Processes are stochastic processes where the future state depends only on the current state a...

  • Answered by AI
  • Q4. Then the HR guy asked me One trait of mine that I’m not proud of?
  • Q5. Then there was a puzzle m2 = n2 + 32294 ( It was also asked in last year’s interview)
  • Q6. Then there was another HR question, In a group would it be better for me to assume a leadership position or simply be a part of it? Why?

Interview Preparation Tips

Round: Test
Experience: The Maths section had questions on basic probability and statistics. Also the Maths section had a higher weight age than the other sections (Questions carrying 3 marks each while other sections had 1 or 2 marks for each question. They were here, offering a quant profile so that justifies the distribution.) The DI/Quant (2 marks each) and English (1 Mark Each) section were similar to CAT. The finance section had questions on Basic Accounting. Anyone who did well in the Maths section could find his name in the shortlist.

Round: Technical + HR Interview
Experience: Possible Lapses: I

UBS Interview FAQs

How many rounds are there in UBS Data Engineer interview?
UBS interview process usually has 2-3 rounds. The most common rounds in the UBS interview process are Technical, One-on-one Round and Coding Test.
How to prepare for UBS Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at UBS. The most common topics and skills that interviewers at UBS expect are Oracle, Informatica, Information Security, Postgresql and Python.
What are the top questions asked in UBS Data Engineer interview?

Some of the top questions asked at the UBS Data Engineer interview -

  1. hacker rank code p...read more
  2. Credit Risk + Technical stuff like SQL, IF...read more
  3. Second Round as well was on Credit R...read more

Tell us how to improve this page.

UBS Data Engineer Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more
UBS Data Engineer Salary
based on 60 salaries
₹10 L/yr - ₹30 L/yr
101% more than the average Data Engineer Salary in India
View more details

UBS Data Engineer Reviews and Ratings

based on 4 reviews

3.4/5

Rating in categories

2.5

Skill development

3.5

Work-life balance

2.9

Salary

2.6

Job security

3.0

Company culture

2.1

Promotions

2.5

Work satisfaction

Explore 4 Reviews and Ratings
Data Engineer

Pune

7-10 Yrs

Not Disclosed

Explore more jobs
Associate Director
3.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Vice President
2.3k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Authorized Officer
1.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Exempt NON Officer
1.5k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

ENO
1.4k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare UBS with

Morgan Stanley

3.7
Compare

Goldman Sachs

3.5
Compare

JPMorgan Chase & Co.

4.0
Compare

Deutsche Bank

3.9
Compare
Did you find this page helpful?
Yes No
write
Share an Interview