3. Data, Science & AI

Provides command-line utilities for dbt operations including model selection, Jinja macro usage, and debugging in data transformation workflows.

Creates and refactors dbt models with proper CTE patterns, SQL structure, and layered data transformation (staging, intermediate, mart).

Executes SQL, manages Snowflake objects, deploys applications, and orchestrates data pipelines via Snowflake CLI for data engineering automation.

Converts DDL from multiple databases to Snowflake-compatible dbt models, generating schema.yml with tests and documentation.

Converts Teradata DDL to dbt models for Snowflake, generating schema.yml files with tests and documentation while following dbt best practices.

Manages Snowflake connections for CLI, Streamlit, dbt, and Snowpark with multiple auth methods and environment overrides.

Provides structured dbt project organization using medallion architecture (bronze/silver/gold layers) for data transformation and model dependencies.

Converts Vertica DDL to dbt-compatible models for Snowflake, generating schema.yml files with tests and documentation while following dbt best practices.

Step-by-step guide for configuring dbt projects on Snowflake, including prerequisites, Git integration, event tables, and scheduling for data pipelines.

Enables native deployment, management, execution, and monitoring of dbt data transformation projects within Snowflake, supporting team collaboration and automated scheduling.

Develops, tests, and deploys interactive data applications using Streamlit on Snowflake, including local setup and testing with pytest.

Converts Sybase IQ DDL to dbt models for Snowflake, generating schema.yml with tests and documentation following dbt best practices.

Optimizes dbt model performance and Snowflake query efficiency through materialization, clustering, and warehouse sizing.

Assists in selecting and implementing dbt materializations for data transformation, including incremental models and SCD Type 2 snapshots.

Monitors dbt execution, tracks model/test history, and provides programmatic access to metadata for data quality analysis.

Converts Oracle DDL to dbt models for Snowflake, generating schema.yml files with tests and documentation for data pipelines.

Enables data quality testing in dbt with constraints, custom tests, and layer-specific validation for bronze/silver/gold data layers.

Converts Microsoft SQL Server/Azure Synapse T-SQL DDL to dbt models for Snowflake, generating schema.yml files with tests and documentation.

Converts BigQuery DDL to dbt models for Snowflake, generating schema.yml with tests and documentation while following dbt best practices.

Converts Hive, Spark, and Databricks DDL to dbt models for Snowflake, generating schema.yml with tests and documentation.

Converts PostgreSQL, Greenplum, and Netezza DDL to dbt models for Snowflake, generating schema.yml with tests and documentation.

Migrates DB2 DDL to dbt models for Snowflake, producing schema.yml with tests and documentation following dbt best practices.

Converts Amazon Redshift DDL to dbt models compatible with Snowflake, generating schema.yml files with tests and documentation.

Converts Snowflake DDL to dbt models, generating schema.yml files with tests and documentation for data transformation.