Core development tools used across any project — git, docker, make, CI/CD, linting, formatting, pre-commit hooks.
Guides warehouse data modeling with a Kimball/wide-table/Data Vault decision tree, medallion dbt layering, and fact table templates; use when designing a warehouse schema, choosing a modeling approach, or refactoring an existing model.
Provides dbt development patterns for materialization strategy, incremental models, and audit-column macros; use when building dbt models, writing macros, or configuring materializations.
Covers data lineage tracing in dbt, column-change impact assessment, and data catalog standards; use when tracing data origins, assessing the impact of schema changes, or managing the data catalog.
Provides Airflow DAG templates and idempotent task patterns for pipeline orchestration; use when designing DAGs, debugging pipeline failures, or configuring retries.
Defines a dbt test taxonomy and volume anomaly detection for data quality; use when adding tests to dbt models, implementing data validation, or investigating data quality incidents.
Applies SQL optimization patterns, window functions, and Snowflake-specific tuning; use when writing complex queries, optimizing slow queries, designing indexes, or reviewing query performance.
Provides Kafka producer and consumer best practices and dead letter queue patterns for streaming data; use when designing Kafka consumers or producers or implementing real-time pipelines.