Barclays Data Engineer Interview Questions
The questions to prepare for a Barclays Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Approach for handling late-arriving records in a batch ETL pipeline without breaking correctness or forcing full reloads.
BarclaysApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
BarclaysTests your strategy for migrating legacy data systems to cloud while managing risk, data integrity, and cutover.
BarclaysTests your approach to building reliable ETL/ELT pipelines from source systems into Barclays data platforms.
BarclaysTests your understanding of modeling tradeoffs affecting performance, maintainability, and analytics.
BarclaysTests your SQL craftsmanship for correctness and performance across tricky data scenarios.
BarclaysTests your ability to interpret plans and apply targeted optimizations to speed up queries.
BarclaysAggregate active portfolio exposure by counterparty using LEFT JOINs, conditional filters, and GROUP BY.
BarclaysCalculate calendar-day rolling exposure averages for active UK counterparties using CTEs, aggregation, and window functions.
BarclaysUse a CTE, join, and dense ranking to return each client's second-highest distinct transaction amount.
The Ameriprise
Tata Consultancy Services (North America)
Wells FargoSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests prioritization under pressure in a data engineering context, including stakeholder management, trade-off decisions, and ownership of outcomes.
Barclays