Add office photos
Filter interviews by
Lloyd Senior Data Engineer Interview Questions and Answers
Updated
14 Feb 2024
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Approached by Company and was interviewed in Jan 2024.
2 Interview Rounds
1
Aptitude Test Round
Contains 5 sections
On section we need to write programs
Rest 4 are multiple choices
2
Technical Round (2 Questions)
- Q1. What are data warehouse automation tools? View Answers (1)
- Q2. Dimensions modelling Add Answer
Interview questions from similar companies
Interview experience
Good
Difficulty level
Easy
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (6 Questions)
- Q1. Can you introduce yourself and describe your current project experience? View Answers (1)
- Q2. Decorators in python View Answers (1)
- Q3. What is the SQL query to group by employee ID in order to combine the first name and last name with a space? View Answers (1)
- Q4. What are constructors in Python? View Answers (1)
- Q5. Indexing in sql View Answers (1)
- Q6. Why spark works well with parquet files? View Answers (1)
Skills evaluated in this interview
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I was interviewed in Aug 2024.
3 Interview Rounds
1
Coding Test Round
Python and sql tasks
2
Technical Round (2 Questions)
- Q1. Project related questions Add Answer
- Q2. Coding questions on pyspark windows Add Answer
3
One-on-one Round (1 Question)
- Q1. Managerial discussions, mostly in and around the previous projects Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I was interviewed in Sep 2024.
1 Interview Round
1
Technical Round (3 Questions)
- Q1. Coding in pyspark View Answers (1)
- Q2. Databricks optimisation technique View Answers (1)
- Q3. Aqe details in databricks View Answers (1)
Skills evaluated in this interview
Manoj Karan Singh
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Not Selected
I applied via Naukri.com and was interviewed in Sep 2024.
1 Interview Round
1
Coding Test Round
Spark Optimization, Transformation, DLT, DL, Data Governance
Python
SQL
Interview Preparation Tips
Interview preparation tips for other job seekers - Ingestion, Integration, Spark, Optimization, Python, SQL, Data Warehouse
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Naukri.com and was interviewed in May 2024.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. All medium level theory and SQL, python/pyspark code. Add Answer
2
Technical Round (1 Question)
- Q1. More in detail about tools and technologies, project handling, agile, CICD, scenario based. Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
-
I applied via LinkedIn and was interviewed in Feb 2024.
3 Interview Rounds
1
Technical Round (2 Questions)
- Q1. How to work with nested json using pyspark View Answers (1)
- Q2. How to implement scd2 step by step View Answers (1)
2
Technical Round (2 Questions)
- Q1. Write a SQL query to select data from table 2 where data exists in table 1 View Answers (1)
- Q2. After performing joins how many records would be retrieved for inner, left, right and outer joins View Answers (1)
3
HR Round (1 Question)
- Q1. About previous company and reason for leaving Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Don't be afraid of giving interviews. Prepare well attend confidently if you clear it's an opportunity if you don't it's an experience!!
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Recruitment Consulltant and was interviewed in Mar 2024.
2 Interview Rounds
1
One-on-one Round (1 Question)
- Q1. How the files will be read in AWS GLUE View Answers (1)
2
Technical Round (2 Questions)
- Q1. How to get duplicate records View Answers (1)
- Q2. How to get the second highest salary Add Answer
Skills evaluated in this interview
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Previous projects Add Answer
- Q2. Basic questions on python, azure cloud Add Answer
2
HR Round (2 Questions)
- Q1. Why company change Add Answer
- Q2. Salary negotiations Add Answer
Interview experience
Average
Difficulty level
Easy
Duration
2-4 weeks
Result
Not Selected
I was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (1 Question)
- Q1. Tell me about yourself; Projects done; What is Columnar format file in Spark; Internals of Spark, Difference between OLAP and OLTP; About Datawarehouse- facts, ...read more View Answers (1)
Skills evaluated in this interview
Lloyd Interview FAQs
How many rounds are there in Lloyd Senior Data Engineer interview?
Lloyd interview process usually has 2 rounds. The most common rounds in the Lloyd interview process are Aptitude Test and Technical.
Tell us how to improve this page.
Lloyd Interviews By Designations
Interview Questions for Popular Designations
- Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Database Admin Interview Questions
- Senior Data Scientist Interview Questions
- Data Analyst Interview Questions
- Senior Consultant Interview Questions
- Show more
Senior Data Engineer Interview Questions from Similar Companies
|
Sales Executive
19
salaries
|  ₹1.9 L/yr - ₹5 L/yr |
|
Assistant Manager
14
salaries
| ₹5.4 L/yr - ₹13 L/yr |
|
AC Technician
9
salaries
| ₹1 L/yr - ₹4.5 L/yr |
|
Branch Head
7
salaries
| ₹15.4 L/yr - ₹28.9 L/yr |
|
Senior Executive
7
salaries
| ₹3.6 L/yr - ₹4.8 L/yr |
Explore more salaries
Compare Lloyd with
Voltas
Compare
Blue Star
Compare
Godrej Industries Group
Compare
Whirlpool
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- Lloyd Interview Questions >
- Lloyd Senior Data Engineer Interview Questions
Share an Interview