Top 21
Prep plan
Updated weekly · Last refresh Aug 30

Jones Lang LaSalle Data Engineer Interview Questions

The questions to prepare for a Jones Lang LaSalle Data Engineer interview. Questions from real interview reports rank first. Updated weekly.

21questions
~3htotal time
Track your progressSign up free to work through all 21 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 6 questions · ~54 min
Maximum Sum Contiguous SubarrayEasy
Practice

Use Kadane's algorithm to find the contiguous subarray with the largest sum in linear time.

Dynamic ProgrammingArraysGreedyJones Lang LaSalle
Lists, Tuples, and SetsEasy

Tests Python data-structure knowledge and ability to choose efficient structures for data tasks.

Hash TablesData StructurespythonJones Lang LaSalle
More Coding questions with a free account
2
Pipelines5 questions · ~45 min
Handling a Production Pipeline FailureEasy

Describe a real production pipeline failure, how you diagnosed and fixed it, and what changes you made around orchestration, quality, and reruns.

InfrastructureIdempotencyQualityJones Lang LaSalle
ETL vs ELT Trade-offsEasy

Compare ETL and ELT, and explain when ELT is the better pipeline pattern.

ETLELTData ModelingJones Lang LaSalle
Data Quality and Schema EvolutionMedium

Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.

schema evolutionData ModelingQualityJones Lang LaSalle
More Pipelines questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
SQL & Data Manipulation4 questions + 3 drills · ~66 min
Clustered vs Non-Clustered IndexesMedium

Explain how clustered and non-clustered indexes differ in storage, lookup behavior, and query performance.

JoinsData WranglingJones Lang LaSalle
Schema for Historical ValuationsHard

Tests data modeling tradeoffs for time-series history and write performance in a real estate context.

performancedimensionsData ModelingJones Lang LaSalle
Running Total with Window FunctionsMedium

Tests understanding and application of SQL window functions for time-ordered financial metrics.

Window FunctionsDate FunctionsRunning TotalsJones Lang LaSalle
SQL for Recent HiresEasy
Practice
Practice drill

Use a date-range CTE and office join to find Jones Lang LaSalle employees hired in the last six months.

Date FunctionssqlJones Lang LaSalle
Monthly Sales Trends by CategoryMedium
Practice
Practice drill

Aggregate monthly sales by product category and use LAG to calculate month-over-month changes.

InfrastructureToolsData WranglingTotal Wine & MoreInc.Benjamin Moore
Contact Center Agent Performance MetricsHard
Practice
Practice drill

Compute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.

ETLAggregationsData ModelingADP
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership6 questions · ~54 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 21 questions plus 3 hands-on drills to finish this plan.