HomeInterview QuestionsWhat data normalization techniques do you use for …

What data normalization techniques do you use for JSON data, and how do you balance real‑time performance with data quality?

🟡 Medium Conceptual Mid level
1Times asked
Sep 2026Last seen
Sep 2026First seen

💡 Model Answer

For JSON, I flatten nested objects into a star schema, use a schema registry to enforce versioning, and apply type casting during ingestion. To keep real‑time performance, I process the JSON in micro‑batches with Spark Structured Streaming, applying schema evolution rules to avoid full re‑processing. I also use a two‑stage approach: first write raw JSON to a raw layer, then transform to normalized form in a separate job. This decouples ingestion speed from downstream quality checks, allowing near‑real‑time loads while still ensuring data integrity.

This answer was generated by AI for study purposes. Use it as a starting point — personalize it with your own experience.

🎤 Get questions like this answered in real-time

Assisting AI listens to your interview, captures questions live, and gives you instant AI-powered answers on a discreet on-screen overlay.

Get Assisting AI — Starts at ₹500