UBS Data Engineer Interview Questions

Evaluate when a pipeline should use stream processing versus scheduled batch based on latency, cost, complexity, and data quality needs.

Stream ProcessingBatch ProcessingDependenciesUBS

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

schema evolutionData ModelingQualityUBS

Tests ownership in diagnosing and fixing a slow data pipeline, with emphasis on root-cause analysis, communication, and measurable impact.

data pipelinesOwnershipPrioritizationUBS

Tests core Python data structure knowledge and practical selection reasoning.

basicsData StructurespythonUBS

Tests root-cause analysis and durable prevention strategies for duplicate data in reporting pipelines.

root causeReconciliationdata integrityUBS

Calculate daily and cumulative Quadrint product revenue using aggregation, a CTE, and a partitioned window function.

Window FunctionsRunning TotalsAggregationsUBS