How do I approach Data Manipulation (SQL/Python) interview questions?

Data Manipulation (SQL/Python) questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master data manipulation (sql/python) interviews.

What difficulty level is this interview question?

This is a medium difficulty Data Manipulation (SQL/Python) question, commonly asked during Technical Screen rounds at EY.

What role is this question designed for?

This question is commonly asked for Data Scientist candidates at EY during technical interviews.

Architect cloud data ingestion patterns

Last updated: Jul 17, 2026

Quick Overview

This question evaluates a candidate's ability to design end-to-end cloud data ingestion and serving architectures, including streaming and batch patterns, CDC/event sourcing/micro-batch trade-offs, partitioning and compaction strategies, idempotency, schema evolution, PII tokenization, cost controls, and incident simulation for chaos testing.

|Home/Data Manipulation (SQL/Python)/EY

Architect cloud data ingestion patterns

Oct 13, 2025, 9:49 PM

mediumData ScientistTechnical ScreenData Manipulation (SQL/Python)

Propose a cloud data ingestion and serving pattern for streaming and batch on your preferred cloud (AWS/Azure/GCP). Choose between CDC, event sourcing, or micro‑batch for upstream systems, justify partitioning/compaction, and show how you ensure idempotency, schema evolution (e.g., optional fields), and PII tokenization. Include cost controls (storage tiering, TTL, file size targets) and an incident you would simulate in chaos testing.

Loading comments...

Browse More Questions

More Data Manipulation (SQL/Python)•More EY•More Data Scientist•EY Data Scientist•EY Data Manipulation (SQL/Python)•Data Scientist Data Manipulation (SQL/Python)