01
SQL & Data Modeling
Designed a normalized PostgreSQL schema from an ER diagram, with indexes and a data dictionary.
2 of 7 skills
Designed a normalized PostgreSQL schema from an ER diagram, with indexes and a data dictionary.
Structured a dbt project with staging and mart models, tests and documentation.
Orchestrated an ETL pipeline with Airflow: DAGs, sensors, alerts and a dbt run.
Built a streaming pipeline with a Python producer and a consumer writing to PostgreSQL.
| Airflow | BigQuery | dbt | Kafka | PostgreSQL | Python | SQL | |
|---|---|---|---|---|---|---|---|
| SQL & Data Modeling | |||||||
| dbt Transformation | |||||||
| Airflow Pipelines | |||||||
| Streaming with Kafka |