DEV Community

De' Clerke profile picture

De' Clerke

Zetech IT graduate specializing in Kenyan data systems and automation. Expert in building efficient information pipelines with 55+ successful projects delivered using modern programming tools.

Location Nairobi, Kenya Joined Joined on  Personal website https://ian-mwendwa.vercel.app/

Education

Zetech University

Pronouns

He

Work

Intern

FastAPI for Data Engineers: Building, Testing, and Debugging APIs That Don't Lie to You
de_clerke profile

FastAPI for Data Engineers: Building, Testing, and Debugging APIs That Don't Lie to You

#fastapi #dataengineering #testing #api
1
Comments
14 min read
The Data Engineering Take-Home Assessment: How to Turn a 4-Hour Test Into a Job Offer
de_clerke profile

The Data Engineering Take-Home Assessment: How to Turn a 4-Hour Test Into a Job Offer

#dataengineering #career #sql #beginners
1
Comments
14 min read
Data Engineering Interviews with No Industry Experience: A Playbook That Actually Works
de_clerke profile

Data Engineering Interviews with No Industry Experience: A Playbook That Actually Works

#dataengineering #career #interview #python
1
Comments
22 min read
SQL Interview Problems for Data Engineers: 30 Patterns That Actually Get Asked
de_clerke profile

SQL Interview Problems for Data Engineers: 30 Patterns That Actually Get Asked

#sql #dataengineering #career #interview
1
Comments
15 min read
Terraform for Data Engineers: Provisioning GCS, BigQuery, S3, and Lambda Without Clicking Through Consoles
de_clerke profile

Terraform for Data Engineers: Provisioning GCS, BigQuery, S3, and Lambda Without Clicking Through Consoles

#devops #dataengineering #terraform #aws
1
Comments
11 min read
Snowflake for Data Engineers: The Mental Model Shifts That Actually Matter
de_clerke profile

Snowflake for Data Engineers: The Mental Model Shifts That Actually Matter

#snowflake #dataengineering #datawarehouse #database
1
Comments
9 min read
PostgreSQL for Data Engineers: Indexes, Bulk Loads, and the Patterns That Actually Matter
de_clerke profile

PostgreSQL for Data Engineers: Indexes, Bulk Loads, and the Patterns That Actually Matter

#postgres #database #sql #psycopg2
1
Comments
13 min read
Web Scraping Kenyan Data Sources: What's Available, What Fights Back, and the Patterns That Keep Pipelines Running
de_clerke profile

Web Scraping Kenyan Data Sources: What's Available, What Fights Back, and the Patterns That Keep Pipelines Running

#webscraping #beautifulsoup #playwright #requests
1
Comments
12 min read
GitHub Actions for Data Pipelines: The Setup I Use Across All My Projects
de_clerke profile

GitHub Actions for Data Pipelines: The Setup I Use Across All My Projects

#cicd #githubactions #dataengineering #datapipelines
1
Comments
9 min read
Python for Data Engineers: The Patterns I Use in Every Pipeline
de_clerke profile

Python for Data Engineers: The Patterns I Use in Every Pipeline

#dataengineering #python #softwareengineering #tutorial
1
Comments
12 min read
Kafka for Data Engineers: Core Concepts, KRaft, and the Patterns That Actually Work
de_clerke profile

Kafka for Data Engineers: Core Concepts, KRaft, and the Patterns That Actually Work

#dataengineering #kafka #airflow #streaming
1
Comments
13 min read
Linux for Data Engineers: From Zero to Production
de_clerke profile

Linux for Data Engineers: From Zero to Production

#dataengineering #linux #beginners #wsl
1
Comments
22 min read
# dbt in Production: 5 Gotchas That Broke My Pipelines
de_clerke profile

# dbt in Production: 5 Gotchas That Broke My Pipelines

#dbt #dataengineering #elt #etl
1
Comments
7 min read
5 Docker Compose Mistakes That Broke My Airflow 3 Setup 𖣘
de_clerke profile

5 Docker Compose Mistakes That Broke My Airflow 3 Setup 𖣘

#apacheairflow #dataengineering #orchestration #airflow3
1
Comments
5 min read
Apache Airflow 2 vs 3: A Deep Technical Comparison for Data Engineers
de_clerke profile

Apache Airflow 2 vs 3: A Deep Technical Comparison for Data Engineers

#airflow #dataengineering #python #docker
5
Comments
15 min read
⚡ High-Performance Warehousing: Partitioning & Clustering
de_clerke profile

⚡ High-Performance Warehousing: Partitioning & Clustering

#partitioning #clustering #datawarehouse #database
1
Comments
4 min read
⭐ Star vs. ❄️ Snowflake: Designing the Data Warehouse
de_clerke profile

⭐ Star vs. ❄️ Snowflake: Designing the Data Warehouse

#datamodeling #starchema #snowflakeschema #dimensionalmodeling
1
Comments
3 min read
🏦 OLTP vs. OLAP: Why One Database Isn't Enough
de_clerke profile

🏦 OLTP vs. OLAP: Why One Database Isn't Enough

#datawarehouse #oltp #olap #database
1
Comments
3 min read
🔄 ETL vs. ELT: The Evolution of Data Integration
de_clerke profile

🔄 ETL vs. ELT: The Evolution of Data Integration

#dataengineering #database #etl #elt
1
Comments
4 min read
Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML
de_clerke profile

Understanding Databases: SQL, NoSQL, Schemas,DDL, and DML

#database #backend #beginners #sql
1
Comments
4 min read
loading...