Premium Employer

i

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

Lloyds Technology Centre Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Lloyds Technology Centre Senior Data Engineer Interview Questions and Answers

Updated 9 Jan 2025

Lloyds Technology Centre Senior Data Engineer Interview Experiences

2 interviews found

Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Coding and technical questions they are asking to check a number is prime number ir not for 11 years experience candidate
  • Q2. SQL joins

Interview Preparation Tips

Interview preparation tips for other job seekers - Please have the proper requirement for a position/role before start hiring. Do not waste candidates time
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sql loop query to unnest nested list
  • Ans. 

    Use SQL loop query to unnest nested list

    • Use a recursive CTE (Common Table Expression) to unnest the nested list

    • Join the CTE with the original table to retrieve the unnested data

    • Consider using functions like JSON_ARRAY_ELEMENTS() for JSON data

  • Answered by AI

Skills evaluated in this interview

Senior Data Engineer Interview Questions Asked at Other Companies

asked in 7 Eleven
Q1. Write a query to get the customer with the highest total order va ... read more
asked in 7 Eleven
Q2. There are 10 million records in the table and the schema does not ... read more
asked in 7 Eleven
Q3. How do you handle data pipeline when the schema information keeps ... read more
asked in 7 Eleven
Q4. Difference between Parquet and ORC file. Why industry uses parque ... read more
asked in 7 Eleven
Q5. What is Normalisation and Denormalisation? When do we use them? G ... read more

Interview questions from similar companies

I was interviewed before May 2016.

Interview Preparation Tips

Round: Written Test
Experience: I attended interview at hyderabad location for java Sr.Software Engineer.
1Q) Find out given string palindrome or not.
Ex: madam
2Q) Find first and last index searching number in a array.
Ex: [1,2,3,3,3,3,4,5]
Output : 2,5
3Q) Arrange Strings in alphabetical order.

Tips: Prepare numeric and string related algorithms

Interview Preparation Tips

Round: Test
Experience: The written test was quite similar to the typical CAT pattern. It contained sections on Reading Comprehension, Data Interpretation and Mathematics.

Round: Technical + HR Interview
Experience: There were 2 interviewers in the first interview, one was a technical guy and the other was from HR. They asked me a few very simple puzzles, a few basic programming questions (swapping the value of two variables etc.), questions related to the development cycle of software products. The HR guy asked stuff like what do you want to achieve in life? Strengths, weaknesses etc.

Round: Case Study Interview
Experience: The third interview was the most important one (and I guess that was the deciding interview). The interviewer started with questions like why finance? Which companies are you sitting for? Then he gave me a case study:

Interview Questionnaire 

2 Questions

  • Q1. Oops, os, dbms, project
  • Q2. Why hsbc, why should I hire you.
  • Ans. 

    I have a strong background in software engineering and a passion for innovation, making me a valuable asset to HSBC.

    • I have a proven track record of successfully delivering high-quality software solutions in previous roles.

    • I am highly skilled in various programming languages and technologies, including Java, Python, and SQL.

    • I have experience working in agile development environments, allowing me to adapt quickly to chan...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 4 sections, 15 questions each. Sections on apti, english, programming, technical.
Tips: Time management, complete english and technical first
Duration: 1 hour
Total Questions: 60

Round: Group Discussion
Experience: We were asked which super hero would you like to be. Shared the information. Always present the positives and negatives and emphasize that despite of being negatives
Tips: Think everything through before speaking
Duration: 40 minutes

Round: Technical Interview
Experience: Prepare well, anything can be asked on the things written on your resume

Round: HR Interview
Experience: Sell yourself. Tell them why you would be the best candidate.
Tips: Tell your advantages of being a fresher that you would be comfortable in any technology

College Name: Acropolis institute of technology and research

I applied via Campus Placement and was interviewed before Jan 2021. There were 4 interview rounds.

Round 1 - Group Discussion 

Generic topics that were trending at the time

Round 2 - One-on-one 

(1 Question)

  • Q1. Puzzle round - aptitude
Round 3 - One-on-one 

(1 Question)

  • Q1. Technical Round - coding related questions
Round 4 - Group Discussion 
Pro Tip by AmbitionBox:
Be a good listener. GDs are not just about speaking. Your listening skills will give you a lot of points to counter and speak when your turn comes.
View all tips

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and ensure you're clear with job requirements to clear rounds

Interview Questionnaire 

1 Question

  • Q1. Questions on angular framework,.net core , dependency injection,legacy .net, session management , agile ceremonies.

I applied via Recruitment Consultant and was interviewed in Dec 2020. There was 1 interview round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be 100% technical in java here they will not be any support u need to dig deep lot of complex modules which we cannot understand in depth

I applied via Recruitment Consulltant and was interviewed before Mar 2021. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Java and OOPS Associated Questions
  • Q2. Spring and Basic Programming Like Sort, Searching

Interview Preparation Tips

Interview preparation tips for other job seekers - Don't bother to give interviews it's not a good place to work for.

Interview Questionnaire 

1 Question

  • Q1. Core Java and aws

Lloyds Technology Centre Interview FAQs

How many rounds are there in Lloyds Technology Centre Senior Data Engineer interview?
Lloyds Technology Centre interview process usually has 1 rounds. The most common rounds in the Lloyds Technology Centre interview process are Technical.
How to prepare for Lloyds Technology Centre Senior 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 Lloyds Technology Centre. The most common topics and skills that interviewers at Lloyds Technology Centre expect are Data Engineering, Appdynamics, Azure Cloud, Clinical Data Management and Data Analysis.
What are the top questions asked in Lloyds Technology Centre Senior Data Engineer interview?

Some of the top questions asked at the Lloyds Technology Centre Senior Data Engineer interview -

  1. Sql loop query to unnest nested l...read more
  2. coding and technical questions they are asking to check a number is prime numb...read more

Tell us how to improve this page.

Lloyds Technology Centre Senior Data Engineer Interview Process

based on 2 interviews

Interview experience

3
  
Average
View more
Join Lloyds Technology Centre We're changing financial services and we want you to join us

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.9
 • 569 Interviews
HSBC Group Interview Questions
4.0
 • 491 Interviews
UBS Interview Questions
3.9
 • 339 Interviews
Morningstar Interview Questions
3.9
 • 241 Interviews
Bank of America Interview Questions
4.3
 • 237 Interviews
Apex Group Interview Questions
2.7
 • 132 Interviews
Kotak Securities Interview Questions
3.6
 • 116 Interviews
TresVista Interview Questions
2.9
 • 114 Interviews
View all
Lloyds Technology Centre Senior Data Engineer Salary
based on 18 salaries
₹12 L/yr - ₹39.6 L/yr
36% more than the average Senior Data Engineer Salary in India
View more details

Lloyds Technology Centre Senior Data Engineer Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

3.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
79 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
73 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Data Analyst
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Quality Engineer
23 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Data Engineer
18 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Lloyds Technology Centre with

HSBC Group

3.9
Compare

Standard Chartered Plc

3.0
Compare

Barclays PLC

3.9
Compare

JPMorgan Chase & Co.

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