Berkshire Hathaway Specialty Insurance Data Engineer Interview Questions
The questions to prepare for a Berkshire Hathaway Specialty Insurance Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Explain how UNION and UNION ALL combine operational data from multiple sources and when each should be used.
Berkshire Hathaway Specialty InsuranceExplain how UNION and UNION ALL combine similarly structured datasets, and when to use each for reporting or consolidation.
Berkshire Hathaway Specialty InsuranceExplain how LAG and LEAD compare current rows to previous or next periods in time-series SQL analysis.
Berkshire Hathaway Specialty InsuranceExplain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.
Berkshire Hathaway Specialty InsuranceAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreCompute daily agent call KPIs and SLA using joins, aggregations, and window ranking in a contact center model.
ADPUse joins, CTEs, and CASE logic to flag and fill missing financial fields for Qlik planning records.
QlikConceptual pipeline question on Delta Lake and how it differs from plain Parquet files in data engineering workflows.
Berkshire Hathaway Specialty InsuranceApproach for safely backfilling missing data while preserving correctness, idempotency, and data quality.
Berkshire Hathaway Specialty InsuranceApproach for detecting and mitigating skew in PySpark pipelines using partitioning, join strategies, and runtime monitoring.
Berkshire Hathaway Specialty InsuranceCompare batch and stream processing across latency, complexity, cost, and data quality in a modern analytics pipeline.
Berkshire Hathaway Specialty InsuranceSign up to see every question
Create a free account to unlock this list and practice real interview questions.