Add office photos
Engaged Employer
i
This company page is being actively managed by
Loyalytics Team. If you also belong to the team, you
can get access from
here
Loyalytics
Compare
Filter interviews by
Loyalytics Senior Data Engineer Interview Questions and Answers
Updated
18 Nov 2023
1 interview found
Sort by:
Popular
Anonymous
Interview experience
Excellent
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Selected
I applied via Internshala and was interviewed before Nov 2022.
3 Interview Rounds
1
Coding Test Round
Simple python algo questions
2
One-on-one Round (1 Question)
- Q1. Python concepts Add Answer
3
HR Round (1 Question)
- Q1. About yourself and your experience Add Answer
Top trending discussions
View All
Interview Tips & Stories
2w (edited)
a consultant
Alternate documents for Employee verification?
My new employer asked for my previous offer letters and salary slips. When I inquired, they said it was for background verification.
However, I feel that providing these documents might affect salary negotiations, and it feels a bit unethical too.
What alternative documents can I provide for employment verification?
Got a question about Loyalytics?
Ask anonymously on communities.
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 applied via Naukri.com and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. All questions based on databricks and some pyspark , python , SQL only. Add Answer
- Q2. Learn windows function implementation in databricks note book. Add Answer
2
HR Round (1 Question)
- Q1. This round about your salary discussion around. Add Answer
Interview Preparation Tips
Topics to prepare for Accenture Senior Data Engineer interview:
- Python
- Pyspark
- SQL
- Databricks
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Sql query to write max salary View Answers (1)
- Q2. What is dense rank in sql View Answers (1)
2
Technical Round (2 Questions)
- Q1. What is spark cluster View Answers (1)
- Q2. How hive works in hdfs 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
Loyalytics Interview FAQs
How many rounds are there in Loyalytics Senior Data Engineer interview?
Loyalytics interview process usually has 4 rounds. The most common rounds in the Loyalytics interview process are HR, Resume Shortlist and Coding Test.
How to prepare for Loyalytics 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 Loyalytics. The most common topics and skills that interviewers at Loyalytics expect are Analytics, Business Intelligence, Consulting, Data Modeling and Data Warehousing.
Tell us how to improve this page.
Loyalytics Interviews By Designations
Interview Questions for Popular Designations
- Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Senior Software Engineer Interview Questions
- Database Admin Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
People are getting interviews through
based on 1 Loyalytics interview
Job Portal
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Senior Data Engineer Interview Questions from Similar Companies
Loyalytics Senior Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Data Scientist
37
salaries
|  ₹6 L/yr - ₹22 L/yr |
|
Data Engineer
12
salaries
| ₹8 L/yr - ₹15 L/yr |
|
Business Analyst
9
salaries
| ₹6 L/yr - ₹10 L/yr |
|
Software Developer
5
salaries
| ₹4.2 L/yr - ₹7.8 L/yr |
|
Analytics Consultant
5
salaries
| ₹9.1 L/yr - ₹25.6 L/yr |
Explore more salaries
Compare Loyalytics with
Mu Sigma
Compare
Fractal Analytics
Compare
Tiger Analytics
Compare
LatentView Analytics
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 >
- Loyalytics Interview Questions >
- Loyalytics Senior Data Engineer Interview Questions
Share an Interview