Dataford
Dataford
Top 29
Prep plan
Updated weekly · Last refresh Oct 17

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 daily.

29questions
~4htotal time
Track your progressSign up free to work through all 29 questions and resume where you left off.
Start practicing free →
1
PipelinesStart here. 3 questions · ~24 min
Design SCD Type 1 and 2Medium

Design and implement SCD Type 1 and Type 2 dimensions with history tracking, idempotent loads, and data quality controls.

slowly changing dimensionsData ModelingBackfillingVerisk Analytics
Stream Ingest to Warehouse on AWSHard

Tests streaming ingestion design and warehouse loading patterns at scale.

data integrationStream ProcessingawsVerisk Analytics
More Pipelines questions with a free account
2
SQL & Data Manipulation9 questions + 3 drills · ~103 min
Explain SQL Join TypesEasy

Explain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.

JoinsData WranglingGroup ByVerisk Analytics
Star vs Snowflake for Sales AnalyticsMedium

Compare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.

JoinsData WranglingGroup ByVerisk Analytics
SQL Joins and AggregationsMedium
Practice
Practice drill

Join policy and ISO ClaimSearch claim data to aggregate claim counts and incurred losses by state and policy type.

JoinsGroup ByAggregationsVerisk AnalyticsMarshBroadridge Financial Solutions
SQL Duplicate RemovalMedium
Practice
Recently asked
Practice drill

Identify duplicate risk records, retain the lowest record ID, and remove the remaining rows safely.

data cleaningData ManipulationsqlVerisk Analytics
Second Highest Without AggregatesHard
Practice
Practice drill

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsCredit GenieDevoteamCisco Restaurant + Bar
More SQL & Data Manipulation questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership13 questions · ~106 min
More Behavioral & Leadership questions with a free account
4
More topics4 questions · ~33 min
Parse Nested JSON with PythonMedium

Tests practical Python data parsing and transformation skills for ingestion into structured systems.

json parsingData WranglingpythonVerisk Analytics
Python Memory Management for Large DataMedium

Tests ability to design memory-efficient processing strategies for large data in Python.

memory leakpython servicetechnical experienceVerisk Analytics
Snowflake Architecture and BenefitsMedium

Tests understanding of Snowflake internals and how to leverage them for scalable analytics.

technical experiencecloud platformsVerisk Analytics
Python Comprehensions vs LoopsMedium

Tests Python performance intuition and memory tradeoffs for data processing.

loopspython basicsperformance analysisVerisk Analytics
The finish line: interview-readyComplete all 29 questions plus 3 hands-on drills to finish this plan.