Add office photos
Filter interviews by
JLL Technologies Data Engineer Interview Questions and Answers
Updated
14 Feb 2024
2 interviews found
Sort by:
Popular
Anonymous
Interview experience
Excellent
Difficulty level
Hard
Duration
2-4 weeks
Result
Selected
I applied via Referral and was interviewed in Nov 2022.
3 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
2
Technical Round (2 Questions)
- Q1. I don't remember Add Answer
- Q2. Asked question on my domain Add Answer
3
One-on-one Round (2 Questions)
- Q1. I don't remember Add Answer
- Q2. Project explanation and evaluated technical skills Add Answer
Interview experience
Good
Difficulty level
Moderate
Duration
2-4 weeks
Result
Selected
I applied via Approached by Company and was interviewed before Feb 2023.
2 Interview Rounds
1
Technical Round (1 Question)
- Q1. Basic Sql and python questions Add Answer
2
Technical Round (1 Question)
- Q1. Data Engineering questions via pyspark and SQL 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 JLL Technologies?
Ask anonymously on communities.
Interview questions from similar companies
Interview experience
Average
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I applied via Company Website and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Sql constrainsts, star schema, dml dcl commands Add Answer
- Q2. About cureent project and responsibilities Add Answer
2
Technical Round (2 Questions)
- Q1. Current projects and resposibilities Add Answer
- Q2. Where vs having, reason for job change Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - 1. Technical - about you current project and responsibilities, basic SQL question-constraints, starschema, DML DCL command, one sql query write.
2. Technical with senior manager- about project ,where vs having , reason of job change
2. Technical with senior manager- about project ,where vs having , reason of job change
Interview experience
Average
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
No response
I applied via Naukri.com and was interviewed in Oct 2024.
2 Interview Rounds
1
Technical Round (7 Questions)
- Q1. How do you optimize SQL queries? View Answers (1)
- Q2. How do you do performance optimization in Spark. Tell how you did it in you project. View Answers (1)
- Q3. What is SparkContext and SparkSession? View Answers (1)
- Q4. When a spark job is submitted, what happens at backend. Explain the flow. View Answers (2)
- Q5. Calculate second highest salary using SQL as well as pyspark. View Answers (1)
- Q6. 2 types of modes for Spark architecture ? View Answers (1)
- Q7. If you want very less latency - which is better standalone or client mode? View Answers (1)
2
Technical Round (2 Questions)
- Q1. Scenario based. Write SQL and pyspark code for a dataset. Add Answer
- Q2. If you have to find latest record based on latest timestamp in a table for a particular customer(table is having history) , how will you do it. Self join and ne...read more Add Answer
Interview Preparation Tips
Topics to prepare for LTIMindtree Data Engineer interview:
- SQL
- pyspark
- ETL
Skills evaluated in this interview
Sashikanta Parida
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I applied via Recruitment Consulltant and was interviewed in Nov 2024.
2 Interview Rounds
1
Technical Round (3 Questions)
- Q1. What are different type of joins available in Databricks? View Answers (1)
- Q2. How do you make your data pipeline fault tolerant? View Answers (1)
- Q3. What is AutoLoader? View Answers (1)
2
Technical Round (2 Questions)
- Q1. How do you connect to different services in Azure? View Answers (1)
- Q2. What are linked Services? View Answers (1)
Rutuja Bhagat
Interview experience
Good
Difficulty level
Easy
Duration
-
Result
-
I applied via Recruitment Consulltant and was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (7 Questions)
- Q1. Difference between bigtable and bigquery. View Answers (1)
- Q2. How to remove duplicate rows from bigquery? find the month of a given date in bigquery. View Answers (1)
- Q3. What operator is used in composer to move data from gcs to bq View Answers (1)
- Q4. Write a code for this - input = [1,2,3,4]
output = [1,4,9,16] View Answers (1)
- Q5. Dataflow vs dataproc. View Answers (1)
- Q6. Architecture of bq. Query optimization techniques in bigquery. View Answers (1)
- Q7. RDD vs dataframe vs dataset in pyspark View Answers (1)
Lakshmi Narayana
Interview experience
Good
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Explain adf questions in detail View Answers (1)
- Q2. Project related questions Add Answer
2
Technical Round (2 Questions)
- Q1. Project data related questions Add Answer
- Q2. Databricks and SQL interview questions Add Answer
Interview experience
Poor
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Coding Test Round
Oops dsa sql network
2
Technical Round (2 Questions)
- Q1. Dsa based python question Add Answer
- Q2. Dsa based python question on tress Add Answer
3
Technical Round (2 Questions)
- Q1. Sql question queries Add Answer
- Q2. Sql question query Add Answer
Interview experience
Excellent
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Selected
I applied via Recruitment Consulltant and was interviewed in Jun 2024.
1 Interview Round
1
One-on-one Round (20 Questions)
- Q1. Tell me about yourself View Answers (1)
- Q2. Project Architecture Add Answer
- Q3. Rate yourself out of 5 in Pyspark , Python and SQL View Answers (1)
- Q4. How to handle duplicates in python ? View Answers (1)
- Q5. Methods of migrating Hive metdatastore to unity catalog in Databricks ? View Answers (1)
- Q6. Read a CSV file from ADLS path ? View Answers (1)
- Q7. There was a table provided on coding screen and asked to write different programs and SQL queries from the table and tell the approach you are taking ? Like age...read more Add Answer
- Q8. How many stages will create from the above code that I have written View Answers (1)
- Q9. Narrow vs Wide Transformation ? View Answers (1)
- Q10. What are action and transformation ? View Answers (1)
- Q11. What happens when we enforce the schema and when we manually define the schema in the code ? View Answers (1)
- Q12. What all the optimisation are possible to reduce the overhead of reducing the reading part of large datasets in spark ? View Answers (2)
- Q13. Write a sql query to find the name of person who logged in last within each country from Person Table ? View Answers (1)
- Q14. Difference between List and Tuple ? View Answers (1)
- Q15. Difference between Rank , Dense Rank and Row Number and when we are using each of them ? View Answers (1)
- Q16. What is List Comprehension ? View Answers (2)
- Q17. Tell me about the performance optimization done in your project ? Add Answer
- Q18. Difference between the interactive cluster and job cluster ? View Answers (1)
- Q19. How to add a column in dataframe ? How to rename the column in dataframe ? View Answers (1)
- Q20. Difference between Coalesce and Repartition and In which case we are using it ? View Answers (2)
Interview Preparation Tips
Topics to prepare for Accenture Data Engineer interview:
- Spark
- Databricks
- SQL
- Python
- ETL
Skills evaluated in this interview
Interview experience
Average
Difficulty level
Moderate
Duration
-
Result
Not Selected
I applied via Walk-in
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Difference between rank and dense_rank, Left vs Left anti join View Answers (1)
- Q2. Python list comprehension, SQL query Add Answer
2
Behavioral Round (1 Question)
- Q1. Project related questions Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - No response from HR, even after clearing technical and managerial rounds
Skills evaluated in this interview
JLL Technologies Interview FAQs
How many rounds are there in JLL Technologies Data Engineer interview?
JLL Technologies interview process usually has 2-3 rounds. The most common rounds in the JLL Technologies interview process are Technical, Resume Shortlist and One-on-one Round.
What are the top questions asked in JLL Technologies Data Engineer interview?
Tell us how to improve this page.
JLL Technologies Interviews By Designations
- JLL Technologies Data Engineer Interview Questions
- JLL Technologies Application Administrator Interview Questions
- JLL Technologies Application Developer Interview Questions
- JLL Technologies Data Engineer 1 Interview Questions
- JLL Technologies Engineering Manager Interview Questions
- JLL Technologies QA Lead Interview Questions
- JLL Technologies Sales Officer Interview Questions
- JLL Technologies SDE (Software Development Engineer) Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior 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 2 JLL Technologies interviews
Referral
50%
50% candidates got the interview through other sources.
Moderate
Confidence
?
Moderate Confidence means the data is based on a sufficient number of responses received from the candidates
Data Engineer Interview Questions from Similar Companies
31%
more
than the average Data Engineer Salary in India
View more details
JLL Technologies Data Engineer Reviews and Ratings
based on 1 review
Rating in categories
|
Software Engineer2
18
salaries
|  ₹20 L/yr - ₹23 L/yr |
|
Senior Data Engineer
12
salaries
| ₹23 L/yr - ₹46 L/yr |
|
Senior Software Engineer
12
salaries
| ₹15.6 L/yr - ₹44.8 L/yr |
|
Software Engineer
11
salaries
| ₹7.5 L/yr - ₹15 L/yr |
|
Data Quality Analyst
11
salaries
| ₹7.1 L/yr - ₹9 L/yr |
Explore more salaries
Compare JLL Technologies with
CBRE
Compare
Colliers India
Compare
Cushman & Wakefield
Compare
Knight Frank
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 >
- JLL Technologies Interview Questions >
- JLL Technologies Data Engineer Interview Questions
Share an Interview