Role & responsibilities

Key Skills & Expertise
8+ years of overall IT experience with solid focus on Data Warehousing, ETL/ELT, and Cloud Data Platforms.
7+ years of hands-on experience with Snowflake, including architecture design, performance optimization, security, and administration.
5+ Extensive experience with DBT (Data Build Tool) for building, testing, documenting, and orchestrating scalable ELT pipelines in Snowflake.
Design and development of Snowflake database objects, including tables, views, materialized views, stored procedures, streams, tasks, and sequences.
Expertise in creating and maintaining DBT models, snapshots, seeds, macros, incremental loads, and automated testing frameworks.
Strong experience in implementing Medallion Architecture (Bronze, Silver, Gold Layers) and dimensional data models using fact and dimension tables.
Development of automated data ingestion and transformation pipelines for large-scale CSV, JSON, XML, and Parquet datasets from AWS S3 and other enterprise sources.
Performance tuning and optimization using Snowflake Query Profiler, clustering keys,



caching mechanisms, partitioning strategies, and warehouse sizing.
Experience with ELT pipeline orchestration using DBT, Snowflake Tasks, Airflow, and scheduling frameworks.
Hands-on experience with AWS services including S3, Lambda, Glue, IAM, and EventBridge integrated with Snowflake.
Solid understanding of Data Governance, RBAC, Data Masking, Row-Level Security, and Resource Monitors to ensure secure and compliant data access.
Expertise in implementing CI/CD pipelines for DBT and Snowflake deployments using Git, Azure DevOps, GitHub Actions, or Jenkins.
Experience supporting production settings, troubleshooting performance bottlenecks, resolving data quality issues, and implementing enhancements.
Collaboration with business stakeholders, data architects, analysts, and BI teams to deliver scalable reporting and analytics solutions.

Certifications
SnowPro Core Certification (Preferred)
DBT Fundamentals Certification (Preferred)

📌 Snowflake Developer Telangana
🏢 Innova Solutions
📍 Telangana