Ivan Shamaev
Community@ivanshamaev · Yerevan
Senior DWH Developer / Ex-BI Team Lead 🔖 BI Solutions, DWH Tools, Data Tools
Agent Skills by Ivan Shamaev
Showing 159 vetted skills indexed across 1 GitHub repositories.
ivanshamaevdbt-core
Design dbt Core project structures with sources, refs, materializations, and snapshots.
ivanshamaevrag-data-pipeline
Build RAG ingestion and query pipelines with hybrid retrieval and reranking.
ivanshamaevdelta-lake
Generate Delta Lake DDL, DML, and operational commands for transactional storage.
ivanshamaevvertica_query_optimization
Diagnose Vertica 11.x EXPLAIN plans and tune projections for query performance.
ivanshamaevmlflow-data-pipelines
Configure MLflow tracking and Model Registry for ETL and training runs.
ivanshamaevprefect-workflows
Orchestrate Python ETL workflows with Prefect 3 flows and deployments.
ivanshamaevsqlmesh
Plans and applies DAT (actually SQLMesh-supported model changes with automatic backfill awareness.
ivanshamaevdbt_trino
Configure dbt profiles and incremental models for Trino and Starburst.
ivanshamaevsqlfluff
Filters and routes S3 events to multiple destinations with customizable workflows and triggers.
ivanshamaevpyspark_etl
Optimize and harden production PySpark ETL pipelines with explicit schemas and explain-based diagnostics.
ivanshamaevpostgresql-data-engineering
Design PostgreSQL partitioning, indexing, bulk load, and query diagnostics for data engineering.
ivanshamaevspark_sql
Optimize and debug production Spark SQL for Hive, lakehouse, and HDFS tables.
ivanshamaevde-architecture-decision
Generate Data Engineering Architecture Decision Records with weighted trade-off scoring.
ivanshamaevdocker-data-environments
Create Docker build patterns and local compose environments for data engineering tools.
ivanshamaevmage-ai-pipelines
Design Mage AI pipelines with block-level composition for ETL and streaming workflows.
ivanshamaevapache-kafka
Configure Apache Kafka topics, producers, consumers, connectors, and monitoring.
ivanshamaevkubernetes-data-platform
Deploy Kubernetes-based data platforms for Spark and Airflow workloads.
ivanshamaevdata_vault_2
Construct Data Vault 2.0 hubs, links, satellites, and PIT tables.
ivanshamaevairflow_dag_factory
Generate Apache Airflow DAGs declaratively from YAML using dag-factory.
ivanshamaevde-postmortem-writer
Generate blameless data engineering postmortems with timelines, impact, and root-cause chains.
ivanshamaevde-cost-optimization
Analyze data engineering cloud spend across query, compute, storage, and egress drivers.
ivanshamaevclickhouse-olap
Design ClickHouse OLAP table engines and query patterns for analytics.
ivanshamaevredpanda
Deploy and tune Redpanda clusters with rpk, Schema Registry, and tiered storage.
ivanshamaevpyspark-structured-streaming
Build PySpark Structured Streaming pipelines for Kafka, file, and rate sources.