Collection11 items

altimateai/data-engineering-skills

View on GitHub
49stars

🎯Skills10

🎯optimizing-query-by-id🎯Skill

Streamlines database query performance by implementing efficient ID-based retrieval strategies and indexing techniques for faster data access.

optimizing-query-by-id
🎯developing-incremental-models🎯Skill

Builds scalable machine learning models using incremental learning techniques to adapt and improve performance with streaming or evolving datasets.

developing-incremental-models
🎯creating-dbt-models🎯Skill

Streamlines dbt model development with best practices, generating efficient, modular SQL transformations for data warehouses and analytics workflows.

creating-dbt-models
🎯migrating-sql-to-dbt🎯Skill

Transforms legacy SQL scripts into modular, version-controlled dbt models with automated testing and documentation best practices.

migrating-sql-to-dbt
🎯refactoring-dbt-models🎯Skill

Automates dbt model restructuring, optimizing SQL transformations, reducing complexity, and improving data pipeline performance and readability.

refactoring-dbt-models
🎯testing-dbt-models🎯Skill

Validates dbt models with comprehensive test suites, ensuring data quality, model integrity, and reliable transformation workflows

testing-dbt-models
🎯optimizing-query-text🎯Skill

Streamlines text query performance by applying advanced NLP techniques, reducing computational complexity, and improving search relevance and speed.

optimizing-query-text
🎯documenting-dbt-models🎯Skill

Automatically generates comprehensive documentation for dbt models, including descriptions, column-level metadata, and lineage information to improve data team collaboration.

documenting-dbt-models
🎯finding-expensive-queries🎯Skill

Identifies and analyzes slow-running database queries to optimize performance, reduce resource consumption, and improve overall system efficiency.

finding-expensive-queries
🎯debugging-dbt-errors🎯Skill

Quickly diagnose and resolve common dbt model compilation, runtime, and SQL errors with targeted troubleshooting strategies and best practices.

debugging-dbt-errors

πŸͺMarketplaces1