Top 21
Prep plan
Updated weekly · Last refresh Aug 30

The Lasalle Network Data Engineer Interview Questions

The questions to prepare for a The Lasalle Network 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. 5 questions · ~48 min
Two Sum with TargetEasy
Practice

Use a hash map to find two array elements that sum to a target in O(n) time.

Hash TablesArraysStringsThe Lasalle Network
Flatten Nested JSON to TablesMedium

Tests ability to transform semi-structured data into tabular datasets for downstream analytics.

json parsingData WranglingpythonThe Lasalle Network
More Coding questions with a free account
2
SQL & Data Manipulation5 questions + 2 drills · ~68 min
Second Highest Salary at NovaTechEasy
Practice

Find the second highest distinct employee salary from a single table, returning NULL if it does not exist.

SubqueriesRankingAggregationsThe Lasalle Network
Normalization for Transactional vs AnalyticalMedium

Tests understanding of schema design tradeoffs across transactional and analytical environments.

snowflake schemastar schemadata integrityThe Lasalle Network
Window Functions for Running TotalsMedium

Tests ability to apply window functions for analytics-style calculations in SQL.

Window FunctionsRunning TotalsAggregationsThe Lasalle Network
SQL Last Six Months JoinsEasy
Practice
Practice drill

Find employees hired in the last six months using PostgreSQL date filtering and a department join.

sql queryThe Lasalle Network
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

Sign up to see every question

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

Get my prep plan
3
Pipelines6 questions · ~58 min
Data Quality and Schema EvolutionMedium

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

schema evolutionData ModelingQualityThe Lasalle Network
ETL vs ELT Trade-offsEasy

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

ETLELTData ModelingThe Lasalle Network
Production ETL Logging and ExceptionsMedium

Tests reliability practices for production pipelines, including error handling and observability.

monitoringETLpythonThe Lasalle Network
More Pipelines questions with a free account
4
Behavioral & Leadership5 questions · ~48 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 21 questions plus 2 hands-on drills to finish this plan.