Top 30
Prep plan
Updated weekly · Last refresh Oct 17

UST Global Data Engineer Interview Questions

The questions to prepare for a UST Global Data Engineer interview. Questions from real interview reports rank first. Updated daily.

30questions
~5htotal time
Track your progressSign up free to work through all 30 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 9 questions · ~90 min
Maximum Subarray Using KadaneEasy
Practice

Compute the maximum contiguous subarray sum in O(n) time using Kadane's Algorithm.

Basic AlgorithmsDynamic ProgrammingArraysUST Global
BFS vs DFS Traversal ChoiceMedium

Compare BFS and DFS for graph traversal, including when shortest-path guarantees make BFS strictly preferable.

dfsbfstraversalUST Global
Abstract Classes vs InterfacesEasy

Compare Java abstract classes and interfaces, including inheritance rules, shared behavior, and when each is the better design choice.

javaabstractionoopUST Global
More Coding questions with a free account
2
Pipelines3 questions · ~30 min
Design SCD Type 1 and 2Medium

Design and implement SCD Type 1 and Type 2 dimensions with history tracking, idempotent loads, and data quality controls.

slowly changing dimensionsData ModelingBackfillingUST Global
Capturing Data at TeslaMedium

Evaluates your ability to reason about end-to-end data ingestion architecture for a real-world client scenario.

Use CasesUST Global
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 · ~70 min
Star vs Snowflake for Sales AnalyticsMedium

Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.

JoinsData WranglingGroup ByUST Global
SQL and Spark Window FunctionsMedium

Evaluates practical understanding of Spark SQL windowing and performance tuning via repartitioning and bucketing.

Window FunctionssparkUST Global
Second Highest Trader SalaryEasy
Practice
Recently asked
Practice drill

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingeClinicalWorksNNeenOpal CanadaInformatica
7-Day Rolling Average ExportsMedium
Practice
Practice drill

Calculate a 7-day rolling average of Adobe Acrobat document exports using a window function.

Data AnalysisAggregationsAbbottAdobeOOura Ring
SQL Duplicate RecordsEasy
Practice
Practice drill

Identify repeated UST QA test executions using a CTE, GROUP BY, HAVING, and a project join.

sqlUSTKpmg UsAllstate
More SQL & Data Manipulation questions with a free account
4
Behavioral & Leadership13 questions · ~130 min
More Behavioral & Leadership questions with a free account
5
More topics1 question · ~10 min
Exception Handling and Memory ManagementMedium

Tests practical engineering judgment for reliability and resource management in data pipelines.

best practicesmemory leaktechnical experienceUST Global
The finish line: interview-readyComplete all 30 questions plus 3 hands-on drills to finish this plan.