Ayush Chaplot

Developed and maintained robust data products (CTEs, Procedures, Views, Tables, Tasks, Streamlit dashboard) in Snowflake, ensuring efficient and cost-effective solutions. Built and optimized data transformation pipelines using Snowflake’s native SQL capabilities CTEs and performance-tuned transformations. Leveraged Snowflake’s advanced features, such as Time Travel, Zero-Copy Cloning, and Data Sharing to ensure data consistency and scalability. Utilized DBT (Data Build Tool) for data modeling, transformation, and orchestration in Snowflake improving efficiency and maintainability of SQL-based transformations. Automated processes to streamline operations and reduce manual intervention using python scripts to prepare SQL Scripts using column mappings documents. Troubleshot and resolved SQL performance issues and data sync errors to maintain system reliability. Automated data ingestion processes from Amazon S3 to Snowflake and optimized workflows, resulting in a 20% reduction in processing time. Improved team onboarding efficiency by 50% by documenting ETL processes creating DBT documentation and conducting KT sessions on data transformation techniques for 10+ team members.

Completed hands-on training on Big Data tools, including Informatica PowerCenter, Linux, SQL, and Python. Successfully demonstrated a team project on Big Data analytics, receiving positive feedback from Leads.