Upload Button Icon Add office photos

Filter interviews by

Lloyds Groups Data Engineer Interview Questions and Answers

Updated 28 Jun 2024

Lloyds Groups Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 28 Jun 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Design system to load data from onpremise to cloud
  • Ans. 

    Design a system to load data from on-premise to cloud

    • Set up a secure VPN connection between on-premise and cloud

    • Use ETL tools like Apache NiFi or Talend to extract, transform, and load data

    • Implement data encryption and compression for secure data transfer

    • Schedule regular data syncs to ensure data consistency

    • Monitor data transfer performance and troubleshoot any issues

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Sql to find highest salary
  • Ans. 

    Use SQL query with MAX function to find highest salary in a table.

    • Use SELECT MAX(salary) FROM employees;

    • Make sure to replace 'employees' with the actual table name.

    • Consider using GROUP BY clause if there are multiple departments or categories.

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I appeared for an interview in Sep 2016.

Interview Preparation Tips

Round: Test
Experience: There was an online test having 3 section, one for aptitude testing, one for logical testing and the last one for technical testing.
Aptitude and logical questions were very basic.
Technical questions included : C C++ Java DS DBMS DAA
Tips: For aptitude and logical part, you need to prepare regularly. Nothing comes out of the box, but you just have to be quick in solving the questions.
For the technical part, prepare well by revising your course materials. Basic one word questions are asked.
Duration: 1 hour
Total Questions: 60

Round: Coding
Experience: This round consists of multiple sets of coding. One question per paper. It's on your luck, which question you'll get. Also,net is allowed. You have to complete the code and show it to the invigilator.
Tips: This round is generally not there in placement drives of DELL. It is on your luck.

Skills: Communication, Data Structures, Basic Knowledge Of DBMS
College Name: Manipal University Jaipur

I applied via Referral and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Process,Simulation, CAD

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident

I applied via Walk-in and was interviewed before Apr 2021. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Explain Compilation process steps?
  • Ans. 

    Compilation process involves several steps to convert source code into executable code.

    • Preprocessing: Includes header file inclusion, macro expansion, and conditional compilation.

    • Compilation: Translates source code into assembly code.

    • Assembly: Converts assembly code into machine code.

    • Linking: Combines object files and libraries to create an executable file.

    • Loading: Loads the executable file into memory and prepares it

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well prior the interview, revise all the basic concepts of Embedded C and MATLAB if you have applied for embedded systems.

I applied via Campus Placement and was interviewed before Feb 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Quant , Logical REASONING , Java

Round 2 - HR 

(3 Questions)

  • Q1. Why should we hire you?
  • Q2. What is your family background?
  • Q3. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Great company to work for , Be honest and well rounded discussions on CV

I applied via Walk-in and was interviewed before Dec 2019. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Only experience .

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing

I applied via Company Website and was interviewed before Mar 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. They ask all about besic and some advanced question.
  • Q2. Dont be hyper

Interview Preparation Tips

Interview preparation tips for other job seekers - be true and simple

I applied via Campus Placement and was interviewed before May 2021. There were 2 interview rounds.

Round 1 - Coding Test 

1 hour

Round 2 - One-on-one 

(1 Question)

  • Q1. About Ds and Linux commands

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare datastructres and alogorithms and linux commands properly .

I applied via Referral and was interviewed before Jun 2020. There were 5 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. Basic networking theory like arp, ping, vlans, subnetting
  • Q2. Switching scenarios mostly related to STP
  • Q3. OSI layer based questions. For example, which layer deals with congestion control.
  • Q4. Basics of routing. Ospf n bgp scenarios
  • Q5. One of the challenging cases worked on
  • Ans. 

    Developed a solution for optimizing a complex algorithm for a client in the finance industry

    • Client had a large dataset that needed to be processed quickly

    • Implemented parallel processing to speed up the algorithm

    • Optimized the code to reduce memory usage

    • Collaborated with the client to fine-tune the algorithm for their specific needs

  • Answered by AI
  • Q6. Scenarios questions to check how you would approach a problem and work towards resolution. Like what all information would you ask from the customer to understand the issue and how you would make use of it...

Interview Preparation Tips

Interview preparation tips for other job seekers - Having a concrete networking experience and understanding would help you to crack the interview easily.
The scenarios are not tough and are basically put to check if you know the basics.

I applied via Recruitment Consultant and was interviewed in Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions were related to the post John Deere were offering to candidates. For me it was Diagnostics Author position.

Interview Preparation Tips

Interview preparation tips for other job seekers - Always be aware that answer as simple as you can.
If you don't know the answer don't try to attempt simply say that you don't know and assure interviewer that if you ll get a chance you will definitely answer that.

Be optimistic and attentive.

Lloyds Groups Interview FAQs

How many rounds are there in Lloyds Groups Data Engineer interview?
Lloyds Groups interview process usually has 2 rounds. The most common rounds in the Lloyds Groups interview process are Technical.
What are the top questions asked in Lloyds Groups Data Engineer interview?

Some of the top questions asked at the Lloyds Groups Data Engineer interview -

  1. Design system to load data from onpremise to cl...read more
  2. Sql to find highest sal...read more

Tell us how to improve this page.

Lloyds Groups Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Assistant Manager
4 salaries
unlock blur

₹8.5 L/yr - ₹9.5 L/yr

Senior Software Engineer
4 salaries
unlock blur

₹25 L/yr - ₹35 L/yr

Explore more salaries
Compare Lloyds Groups with

UST

3.8
Compare

Vivo

4.1
Compare

Dell

3.9
Compare

Hyundai Motor India Limited

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