Chitransh Ayush

About Chitransh Ayush

Results-driven Snowflake Developer with 2+ years of hands-on cloud data warehousing experience and 6 years of total IT experience, including 4 years as an Angular Developer. Proficient in designing scalable ELT pipelines, Snowflake data modeling (Bronze/Silver/Gold), Snowpipe, Streams & Tasks, Time Travel, Zero-Copy Cloning, dbt, Snowpark, and RBAC.Experienced in integrating Snowflake with cloud platforms (AWS S3, Azure Blob Storage). Full-stack background enables seamless cross-team collaboration, ensuring end-to-end data visibility across applications.

Experience

1. Snowflake Developer

   Tata Consultancy Services

   Dec 2024 — Present · New Delhi, IN

   E2E Sales Analytics Data Warehouse (Goodyear).• Built a cloud-based data warehouse on Snowflake to centralize and analyze retail sales data from multiple sources including CSV files and REST APIs, processing 5M+ records daily.• Designed and implemented multi-layer architecture (Bronze, Silver, Gold) using Snowflake Stages, Snowpipe for automated continuous data ingestion, and Streams & Tasks for incremental data processing.• Created optimized data models using Snowflake clustering keys and materialized views to improve query performance by 40%, utilizing Query Profiling and Execution Plans to identify bottlenecks.• Leveraged Zero-Copy Cloning to create instant dev/test/staging environments, significantly reducing infrastructure overhead and costs.• Utilized Snowflake Time Travel and Fail-safe features for data recovery, auditing, and point-in-time restoration of historical data.• Monitored and optimized Snowflake Virtual Warehouses by configuring auto-suspend and auto-resume policies to control compute costs effectively.• Developed ELT pipelines integrating data from AWS S3 and Azure Blob Storage into Snowflake and automated orchestration using Apache Airflow for daily pipeline refresh.• Built transformation layers using dbt (Data Build Tool) with modular, tested, and documented SQL models across Bronze/Silver/Gold architecture.• Used Snowpark (Python) for in-warehouse data transformation and ML preprocessing directly on Snowflake compute.• Implemented Dynamic Data Masking and Column-Level Security for PII fields and developed RBAC policies to enforce data governance across multiple data domains.• Integrated Snowflake with Power BI for real-time sales dashboards, delivering actionable insights to business stakeholders.

Education

• International school patna

  12th

• Graphic Era Deemed to be University

  BTech - Bachelor of Technology, Computer Science

  2015 — 2019

• St. Karen's High School

  10th