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 daily.
Conceptual pipeline question on Delta Lake and how it differs from plain Parquet files in data engineering workflows.
Berkshire Hathaway Specialty InsuranceDesign a Databricks lakehouse pipeline and defend choosing Delta Lake over Iceberg and Hudi for mixed batch and streaming workloads.
Berkshire Hathaway Specialty InsuranceDesign an AWS data lake architecture handling 12 TB/day batch data and 80K events/sec with governed bronze, silver, and gold layers.
Berkshire Hathaway Specialty InsuranceApproach for detecting and mitigating skew in PySpark pipelines using partitioning, join strategies, and runtime monitoring.
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 how CTEs make complex PostgreSQL queries easier to read, debug, and maintain in reporting workflows.
Berkshire Hathaway Specialty InsuranceExplain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.
Berkshire Hathaway Specialty InsuranceExplain how UNION and UNION ALL combine operational data from multiple sources and when each should be used.
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.
ADPFilter invalid game events and normalize event names using PostgreSQL string and null handling.
Quantium
Scopely
CarvanaSign up to see every question
Create a free account to unlock this list and practice real interview questions.