Role & responsibilities

Key Skills & Expertise

- 8+ years of overall IT experience with strong 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.
- Robust 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.
- Strong 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 environments, 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 (Hyderabad)
🏢 Innova Solutions
📍 Hyderabad