Verisk Analytics Data Engineer Interview Questions
The questions to prepare for a Verisk Analytics Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Design and implement SCD Type 1 and Type 2 dimensions with history tracking, idempotent loads, and data quality controls.
Verisk AnalyticsTests streaming ingestion design and warehouse loading patterns at scale.
Verisk AnalyticsTests cost-aware data engineering decisions for large-scale cloud storage.
Verisk AnalyticsExplain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.
Verisk AnalyticsCompare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
Verisk AnalyticsTests ability to design performant schemas and query strategies for large analytic datasets.
Verisk AnalyticsJoin policy and ISO ClaimSearch claim data to aggregate claim counts and incurred losses by state and policy type.
Demandbase
Align TechnologyVerisk AnalyticsFind the second highest salary in each department without using aggregate functions.
Credit Genie
Devoteam
Cisco Restaurant + BarRank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.
WaymoSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Tests practical Python data parsing and transformation skills for ingestion into structured systems.
Verisk AnalyticsTests Python performance intuition and memory tradeoffs for data processing.
Verisk Analytics