Gowtham Potureddi - DEV Community

Gowtham Potureddi

Oct 19

Caching strategies for system design interviews, explained

#interview #designsystem #dataengineering #walkin

15 min read

Gowtham Potureddi

Oct 19

SQL vs NoSQL: how to actually choose in a system design interview

#interview #walkin #designsystem #dataengineering

15 min read

Gowtham Potureddi

Oct 19

Database sharding and partitioning: the scaling move an interviewer makes you justify

#interview #walkin #designsystem #dataengineering

14 min read

Gowtham Potureddi

Oct 19

CAP theorem explained: the system design interview concept, done precisely

#interview #dataengineering #walkin #designsystem

13 min read

Gowtham Potureddi

Oct 19

Consistent hashing explained: the trick that keeps a cluster calm when a node joins or dies

#interview #walkin #dataengineering #designsystem

14 min read

Gowtham Potureddi

Oct 19

Design Yelp: the proximity-search system design walkthrough

#interview #dataengineering #walkin #designsystem

20 min read

Gowtham Potureddi

Oct 19

Design Dropbox: the file storage and sync system design walkthrough

#interview #walkin #dataengineering #designsystem

19 min read

Gowtham Potureddi

Oct 19

Design a real-time analytics system: the stream-processing walkthrough

#interview #dataengineering #walkin #designsystem

19 min read

Gowtham Potureddi

Oct 19

Design a web search engine: the system design interview walkthrough

#interview #walkin #dataengineering #designsystem

18 min read

Gowtham Potureddi

Oct 19

Design a CDN: the content delivery network system design walkthrough

#designsystem #interview #dataengineering #walkin

19 min read

Gowtham Potureddi

Oct 18

Design an ad click aggregator: the system design interview walkthrough

#designsystem #interview #dataengineering #sql

19 min read

Gowtham Potureddi

Oct 18

Design Pastebin: the beginner-friendly system design interview walkthrough

#designsystem #interview #dataengineering #sql

17 min read

Gowtham Potureddi

Oct 16

Design Google Docs: the collaborative editing system design walkthrough

#designsystem #interview #dataengineering #python

19 min read

Gowtham Potureddi

Oct 16

Design an online auction system: the system design interview walkthrough

#interview #walkin #designsystem #dataengineering

19 min read

Gowtham Potureddi

Oct 16

Design a stock trading app: the system design interview walkthrough

#designsystem #walkin #interview #dataengineering

19 min read

Gowtham Potureddi

Oct 16

Design a hotel booking system: the system design interview walkthrough

#interview #dataengineering #walkin #designsystem

20 min read

Gowtham Potureddi

Oct 16

Design a food delivery app: the system design interview walkthrough

#designsystem #interview #walkin #dataengineering

18 min read

Gowtham Potureddi

Oct 16

Design Ticketmaster: the system design interview walkthrough

#designsyetem #walkin #interview #python

17 min read

Gowtham Potureddi

Oct 16

Design a leaderboard and top-K: the system design interview walkthrough

#designsystem #python #walkin #interview

18 min read

Gowtham Potureddi

Oct 16

Design Google Maps: the system design interview walkthrough

#designsystem #python #interview #walkin

17 min read

Gowtham Potureddi

Oct 15

Design a recommendation system: the ML system design interview walkthrough

#designsystem #interview #dataengineering #sql

17 min read

Gowtham Potureddi

Oct 15

Design object storage (Amazon S3): the system design interview walkthrough

#designsystem #interview #dataengineering #sql

17 min read

Gowtham Potureddi

Oct 15

Design a distributed job scheduler: the system design interview walkthrough

#designsystem #sql #interview #dataengineering

17 min read

Gowtham Potureddi

Oct 13

Design a key-value store: the system design interview walkthrough

#python #sql #interview #dataengineering

17 min read

Gowtham Potureddi

Oct 13

Design a distributed message queue: the system design interview walkthrough

#python #sql #interview #dataengineering

15 min read

Gowtham Potureddi

Oct 13

Design a distributed cache: the system design interview guide

#python #sql #interview #dataengineering

1

16 min read

Gowtham Potureddi

Oct 13

Design a web crawler: the system design interview walkthrough

#python #sql #interview #dataengineering

15 min read

Gowtham Potureddi

Oct 13

Design search autocomplete (typeahead): the system design interview walkthrough

#python #sql #interview #dataengineering

1

16 min read

Gowtham Potureddi

Oct 13

Design a news feed: the social media feed design interview walkthrough

#python #sql #interview #dataengineering

15 min read

Gowtham Potureddi

Oct 13

Design a notification system: the system design interview walkthrough

#python #sql #interview #dataengineering

1

15 min read

Gowtham Potureddi

Oct 13

Design Uber: the ride-sharing system design interview walkthrough

#python #sql #interview #dataengineering

16 min read

Gowtham Potureddi

Oct 13

Design Netflix: the video streaming system design interview walkthrough

#python #sql #interview #dataengineering

15 min read

Gowtham Potureddi

Oct 12

Design a Payment System: the system design interview walkthrough

#python #sql #interview #dataengineering

14 min read

Gowtham Potureddi

Oct 12

Design WhatsApp: the chat system design interview walkthrough

#python #sql #interview #dataengineering

14 min read

Gowtham Potureddi

Oct 12

Design a Rate Limiter: the system design interview walkthrough

#python #sql #interview #dataengineering

1

14 min read

Gowtham Potureddi

Oct 12

Design a URL Shortener: the system design interview walkthrough

#python #sql #interview #dataengineering

14 min read

Gowtham Potureddi

Oct 12

Amazon Coding Interview Questions: what the 2026 loop really tests

#python #sql #interview #dataengineering

12 min read

Gowtham Potureddi

Oct 12

Behavioral Interview Questions: the Top 25 that actually repeat

#interview #dataengineering #python #sql

16 min read

Gowtham Potureddi

Oct 12

SQL Interview Questions: the 2026 shortlist for data engineers

#sql #interview #dataengineering #python

14 min read

Gowtham Potureddi

Oct 12

System Design Interview Questions: the 2026 shortlist

#python #sql #interview #dataengineering

10 min read

Gowtham Potureddi

Sep 27

Prophecy: Visual, Git-Backed Low-Code Spark & SQL Pipelines for the Enterprise

#python #sql #interview #dataengineering

26 min read

Gowtham Potureddi

Sep 27

Bruin: SQL + Python Pipelines in One Framework With Built-In Quality Checks

#python #sql #interview #dataengineering

27 min read

Gowtham Potureddi

Sep 27

A Local Lakehouse on Your Laptop: DuckDB + Iceberg + Trino for Zero-Cloud Dev

#python #sql #interview #dataengineering

28 min read

Gowtham Potureddi

Sep 27

Data Residency & Sovereignty: Multi-Region Architectures for Compliant Data Platforms

#python #sql #interview #dataengineering

32 min read

Gowtham Potureddi

Sep 25

GDPR vs CCPA vs India DPDP: Building Multi-Jurisdiction Privacy Pipelines

#python #sql #interview #dataengineering

29 min read

Gowtham Potureddi

Sep 25

SOC 2 for Data Engineering: Controls, Audit Logs & Evidence-Collection Pipelines

#python #sql #interview #dataengineering

29 min read

Gowtham Potureddi

Sep 25

Marimo: The Reactive Python Notebook for Reproducible Data Work

#python #sql #interview #dataengineering

26 min read

Gowtham Potureddi

Sep 24

Papermill & Notebook Pipelines: Parametrized, Scheduled, Version-Controlled Notebooks

#python #sql #interview #dataengineering

25 min read

Gowtham Potureddi

Sep 24

Streamlit for Data Engineers: Internal Data Apps & Pipeline Dashboards

#python #sql #interview #dataengineering

29 min read

Gowtham Potureddi

Sep 24

Factless Fact Tables: Modeling Events, Coverage & Eligibility Without Measures

#python #sql #interview #dataengineering

28 min read

Gowtham Potureddi

Sep 23

Bridge Tables & Many-to-Many Dimensions: Modeling Hierarchies and Multi-Valued Attributes

#python #sql #interview #dataengineering

31 min read

Gowtham Potureddi

Sep 23

Special Dimensions: Junk, Degenerate, Role-Playing & Conformed Dimensions

#python #sql #interview #dataengineering

29 min read

Gowtham Potureddi

Sep 23

Fact Table Patterns: Transaction, Periodic Snapshot & Accumulating Snapshot Facts

#python #sql #interview #dataengineering

29 min read

Gowtham Potureddi

Sep 22

Iceberg Table Maintenance: Compaction, Expire Snapshots, Rewrite Manifests & Orphan Files

#python #sql #interview #dataengineering

30 min read

Gowtham Potureddi

Sep 22

Apache Amoro (was Arctic): Self-Optimizing Lakehouse Management for Iceberg & Paimon

#python #sql #interview #dataengineering

28 min read

Gowtham Potureddi

Sep 22

Apache Paimon: The Streaming Lakehouse Table Format for Flink & Spark

#python #sql #interview #dataengineering

29 min read

Gowtham Potureddi

Sep 21

Databricks SQL Warehouses & Serverless Compute: Sizing, Photon & Cost Control

#python #sql #interview #dataengineering

28 min read

Gowtham Potureddi

Sep 21

Google Cloud Composer: Managed Airflow on GCP — Sizing, Tuning & Gotchas

#python #sql #interview #dataengineering

29 min read

Gowtham Potureddi

Sep 21

Google Cloud Dataproc & Dataproc Serverless: Managed Spark on GCP

#python #sql #interview #dataengineering

27 min read

Gowtham Potureddi

Sep 20

Amazon EMR Deep Dive: Cluster Types, Spot Fleets, EMR Serverless & Iceberg

#python #sql #interview #dataengineering

30 min read