Mohamed Hussain S

Exploring OLAP DBs like ClickHouse & building data infra with Airflow, Docker & PostgreSQL.

Chennai, India Joined on May 31, 2025 https://my-portfolio-mohamed-hussain-ss-projects.vercel.app/

Work

Associate Data Engineer @ Quantrail Data Chennai, India

Cover image for When Synthetic Data Lies: A Hidden Correlation Problem I Didn’t Expect

Mohamed Hussain S

Mar 26

When Synthetic Data Lies: A Hidden Correlation Problem I Didn’t Expect

#dataengineering #clickhouse #analytics #debugging

3 min read

Want to connect with Mohamed Hussain S?

Create an account to connect with Mohamed Hussain S. You can also sign in below to proceed if you already have an account.

Create Account

Already have an account? Sign in

Cover image for How ClickHouse + Superset Work Together for Analytics (And What Actually Matters)

Mohamed Hussain S

Mar 25

How ClickHouse + Superset Work Together for Analytics (And What Actually Matters)

#clickhouse #superset #analytics #database

4 min read

Cover image for Managing Large PostgreSQL Tables with Native Partitioning and pg_partman

Mohamed Hussain S

Mar 16

Managing Large PostgreSQL Tables with Native Partitioning and pg_partman

#postgres #database #backend #devops

3 min read

Cover image for PostgreSQL Backups and Point-in-Time Recovery with pgBackRest

Mohamed Hussain S

Mar 13

PostgreSQL Backups and Point-in-Time Recovery with pgBackRest

#postgres #database #devops #opensource

4 min read

Cover image for How Debezium Uses PostgreSQL WAL for Change Data Capture

Mohamed Hussain S

Mar 11

How Debezium Uses PostgreSQL WAL for Change Data Capture

#postgres #backend #database #devops

4 min read

Cover image for How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

Mohamed Hussain S

Mar 9

How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

#postgres #database #backend #devops

4 min read

Cover image for Why 'FINAL' in ClickHouse Is Usually a Design Smell

Mohamed Hussain S

Mar 3

Why 'FINAL' in ClickHouse Is Usually a Design Smell

#clickhouse #performance #backend #dataengineering

3 min read

Cover image for Two ClickHouse Internals That Change How You Write Queries

Mohamed Hussain S

Feb 17

Two ClickHouse Internals That Change How You Write Queries

#clickhouse #database #backend #performance

4 min read

Cover image for Understanding Change Data Capture with Debezium

Mohamed Hussain S

Feb 3

Understanding Change Data Capture with Debezium

#cdc #datapipelines #debezium #kafka

4 min read

Cover image for Apache Iceberg Explained: From Data Lakes to Metadata, Snapshots, and Real-World Usage

Mohamed Hussain S

Jan 21

Apache Iceberg Explained: From Data Lakes to Metadata, Snapshots, and Real-World Usage

#datalake #apacheiceberg #dataengineering #bigdata

4 min read

Cover image for Analyzing and Optimizing a Parquet ClickHouse Ingestion Pipeline

Mohamed Hussain S

Dec 13 '25

Analyzing and Optimizing a Parquet ClickHouse Ingestion Pipeline

#dataengineering #etl #clickhouse #python

3 min read

Cover image for Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

Mohamed Hussain S

Dec 2 '25

Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

#dataengineering #python #go #sql

3 min read

Cover image for Why Parquet Is Everywhere - And What Makes It Actually Fast?

Mohamed Hussain S

Nov 15 '25

Why Parquet Is Everywhere - And What Makes It Actually Fast?

#dataengineering #parquet #bigdata #dataarchitecture

3 min read

Cover image for 🐝 Why Hive Exists - And Why Its Complexity Is Actually Necessary

Mohamed Hussain S

Oct 20 '25

🐝 Why Hive Exists - And Why Its Complexity Is Actually Necessary

#architecture #bigdata #dataengineering #hive

3 min read

Cover image for Polyglot Data Engineering: Python + Go in the Same Pipeline

Mohamed Hussain S

Sep 19 '25

Polyglot Data Engineering: Python + Go in the Same Pipeline

#dataengineering #python #go #clickhouse

2 min read

Cover image for Scaling Databases with ClickHouse Sharding (Hands-On Simulation)

Mohamed Hussain S

Sep 9 '25

Scaling Databases with ClickHouse Sharding (Hands-On Simulation)

#clickhouse #olap #dataengineering #resources

2 min read

Cover image for From Python to ClickHouse: Parquet ETL with Go

Mohamed Hussain S

Aug 7 '25

From Python to ClickHouse: Parquet ETL with Go

#go #python #parquet #clickhouse

2 min read

Cover image for ⚡ 3 ClickHouse Query Optimization Lessons I Learned the Hard Way

Mohamed Hussain S

Jul 24 '25

⚡ 3 ClickHouse Query Optimization Lessons I Learned the Hard Way

#clickhouse #dataengineering #performance #sql

3 min read

Cover image for 🧠 From Hive and Elastic to ClickHouse: What Surprised Me

Mohamed Hussain S

Jul 8 '25

🧠 From Hive and Elastic to ClickHouse: What Surprised Me

#clickhouse #sql #hive #elasticsearch

3 min read

Cover image for ⚡ Kafka ClickHouse: Real-Time Data Pipeline for Beginners

Mohamed Hussain S

Jul 2 '25

⚡ Kafka ClickHouse: Real-Time Data Pipeline for Beginners

#dataengineering #kafka #clickhouse #docker

2 min read

Cover image for Extracting System Metrics from ClickHouse Using Airflow & Docker

Mohamed Hussain S

Jun 25 '25

Extracting System Metrics from ClickHouse Using Airflow & Docker

#clickhouse #airflow #docker #python

3 min read

Cover image for My First Data Pipeline Project Using Airflow, Docker & Postgres (COVID API Edition)

Mohamed Hussain S

Jun 13 '25

My First Data Pipeline Project Using Airflow, Docker & Postgres (COVID API Edition)

#dataengineering #postgres #airflow #docker

2 min read

Cover image for Why ClickHouse is a Game-Changer for OLAP: Speed, Architecture, Pros & Cons

Mohamed Hussain S

Jun 6 '25

Why ClickHouse is a Game-Changer for OLAP: Speed, Architecture, Pros & Cons

#database #clickhouse #analytics #bigdata

2 min read

Cover image for Building My First Real-Time Dashboard with ClickHouse and Streamlit: TrendLite Breakdown

Mohamed Hussain S

May 31 '25

Building My First Real-Time Dashboard with ClickHouse and Streamlit: TrendLite Breakdown

#clickhouse #dataengineering #python #streamlit

2 min read

Forem

Mohamed Hussain S

Badges

Writing Debut

GitHub Repositories

Currently learning

When Synthetic Data Lies: A Hidden Correlation Problem I Didn’t Expect

Want to connect with Mohamed Hussain S?

How ClickHouse + Superset Work Together for Analytics (And What Actually Matters)

Managing Large PostgreSQL Tables with Native Partitioning and pg_partman

PostgreSQL Backups and Point-in-Time Recovery with pgBackRest

How Debezium Uses PostgreSQL WAL for Change Data Capture

How PostgreSQL WAL Actually Works (And Why Everything Depends On It)

Why 'FINAL' in ClickHouse Is Usually a Design Smell

Two ClickHouse Internals That Change How You Write Queries

Understanding Change Data Capture with Debezium

Apache Iceberg Explained: From Data Lakes to Metadata, Snapshots, and Real-World Usage

Analyzing and Optimizing a Parquet ClickHouse Ingestion Pipeline

Clean Code in ETL:How Python, Go, and SQL Each Teach You to Think Differently

Why Parquet Is Everywhere - And What Makes It Actually Fast?

🐝 Why Hive Exists - And Why Its Complexity Is Actually Necessary

Polyglot Data Engineering: Python + Go in the Same Pipeline

Scaling Databases with ClickHouse Sharding (Hands-On Simulation)

From Python to ClickHouse: Parquet ETL with Go

⚡ 3 ClickHouse Query Optimization Lessons I Learned the Hard Way

🧠 From Hive and Elastic to ClickHouse: What Surprised Me

⚡ Kafka ClickHouse: Real-Time Data Pipeline for Beginners

Extracting System Metrics from ClickHouse Using Airflow & Docker

My First Data Pipeline Project Using Airflow, Docker & Postgres (COVID API Edition)

Why ClickHouse is a Game-Changer for OLAP: Speed, Architecture, Pros & Cons

Building My First Real-Time Dashboard with ClickHouse and Streamlit: TrendLite Breakdown