Top 50 json parsing Interview Questions
The most frequently asked json parsing questions across all roles and companies, ranked by real interview frequency. Updated daily.
Flatten nested JSON objects into dot-notated CSV rows while preserving array positions and consistent columns.
Quest Global
Pave
Alten Calsoft LabsExtract error codes from log lines, count frequencies with a hash table, and return a sorted formatted summary.
Apple
GoogleUse recursive traversal to flatten nested JSON objects and arrays into path-based key-value pairs.
McKinsey &Flatten nested Patreon metadata into dot-separated keys using iterative depth-first traversal.
Patreon
ZscalerRecursively extract and normalize nested TetraScience assay measurements while preserving inherited experiment and sample context.
TetraScience
Bridgestone AmericasRecursively flatten nested JSON logs and group normalized records by a partition field for Delta ingestion.
DatabricksRecursively flatten nested JSON logs into consistently shaped tabular rows with deterministic columns.
Amazon Web ServicesParse ticket inventory JSON and aggregate available seat counts by section.
AxsCount 0 and 1 sensor readings by Bosch building using a CTE, LEFT JOIN, and conditional aggregation.
Bosch Building TechnologiesSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Use a CTE, join, and conditional aggregation to summarize valid monthly user activity.
AdobeIdentify missing and corrupted measurement records across distributed sources using PostgreSQL joins and conditional validation.
Accenture