lloyds banking group logo
Lloyds Banking Group· Data Engineer 2

DE 2 | Lloyds banking group | Hyderabad | Selected

Location
Hyderabad
Experience
2.5 years
Posted
2 Apr 2025
281 reads

Summary

I interviewed for a Data Engineer 2 role at Lloyds Banking Group in Hyderabad and was selected after three rounds covering project discussions, technical questions on SQL, Spark, and system design, followed by an HR round.

How it went

Interview Experience: No OA Because one of my friend referred and i had strong profile which matched completely with JD.

Round 1 Deep discussion on projects

  • why choose this tech stack
  • Alerting + Monitoring
  • Deployment strategies used
  • CI/CD
  • Can you write Airflow code

SQL Questions on window functions

Round 2 Asked technical Questions

  • spark vs hadoop
  • spark transform, jobs, stages
  • spark sql (window functions)
  • Sql join questions
  • Real life scenarios where joins are used
  • many more on sql and spark

Round 3 HR

Verdict Selected

Questions asked (8)

  1. 01

    Tech Stack Choice Justification

    Other

    Discussion on the rationale behind choosing specific technologies for projects.

  2. 02

    Alerting and Monitoring Strategies

    System Design

    Discussion on strategies and implementation of alerting and monitoring for data pipelines/systems.

  3. 03

    Deployment Strategies

    System Design

    Discussion on deployment strategies used for data engineering projects.

  4. 04

    CI/CD in Data Engineering

    System Design

    Discussion on Continuous Integration/Continuous Deployment practices relevant to data engineering.

  5. 05

    Airflow Code Implementation

    Data Structures & Algorithms

    Question testing the ability to write Apache Airflow code.

  6. 06

    Spark vs. Hadoop Comparison

    System Design

    Comparison between Apache Spark and Apache Hadoop, discussing their use cases, architectures, and advantages/disadvantages.

  7. 07

    Spark Transformations, Jobs, and Stages

    System Design

    Discussion on Spark transformations, jobs, and stages, covering their concepts and how they relate to Spark's execution model.

  8. 08

    Real-life SQL Join Scenarios

    Data Structures & Algorithms

    Discussion on practical, real-world scenarios where different types of SQL joins (INNER, LEFT, RIGHT, FULL OUTER) would be applied.

Know someone preparing? Send it to them:WhatsAppLinkedInX

Interviewed at Lloyds Banking Group recently?

Write up your rounds while you still remember the questions. It helps the next person more than you would think.

Share your experience
Discussion 0

Questions for the author, or how your own interview compared.

Join the discussion

Sign in with Google to comment or ask the author a question.

No comments yet

Be the first to share your thoughts and start the discussion!