Data Engineering | Python, SQL, ETL pipelines
Building data pipelines from real-world APIs and structuring relational data systems
- 🎓 Computer Science student
- 🐍 Building projects with Python, SQL, and data pipelines
- 📊 Focused on ETL pipelines, data modeling, and API data ingestion
- 🐧 Linux user
ETL pipeline that extracts data from a public API, transforms semi-structured JSON into normalized relational tables, and loads it into MySQL using batch operations.
Highlights:
- Batch inserts with executemany (performance-oriented)
- Data normalization (1:N and N:N relationships)
- Transaction handling (commit/rollback)
- Modular pipeline structure (extract → transform → load)
🔗 https://github.com/mxavier-dev/pokeapi-etl-pipeline