Sandhya Samir Routh

About Sandhya Samir Routh

Over 9+ years of experience in SQL, Oracle PL/SQL and Snowflake Cloud Data Warehouse development with strong expertise in data engineering and ETL pipelines. • 4+ years of experience working with Snowflake, including data ingestion, transformation, and performance optimization in cloud data warehouse environments. • Strong experience in designing and developing ETL/ELT pipelines using Snowflake features such as Snowpipe, Streams, Tasks, Stages and COPY command. • Experience in loading structured and semi-structured data (JSON, CSV, Parquet) from AWS S3 into Snowflake using internal and external stages. • Implemented Change Data Capture (CDC) pipelines using Snowflake Streams and Tasks for incremental data processing and real-time data updates. • Strong expertise in Snowflake performance tuning, warehouse optimization, query optimization, and cost-efficient architecture design. • Proficient in creating and managing Snowflake database objects such as tables, views, stages, file formats, tasks, procedures and streams. • Hands-on experience with Time Travel, Fail-safe, Data Cloning, and Snowflake metadata views for monitoring and auditing. • Extensive experience in Oracle SQL and PL/SQL programming including procedures, packages, functions, triggers, cursors and exception handling. • Developed dynamic SQL scripts in PL/SQL to generate queries dynamically at runtime based on business requirements. • Strong expertise in writing complex SQL queries using joins, subqueries, analytical functions and set operators (UNION, UNION ALL, INTERSECT, MINUS). • Experience in performance tuning using indexes (B-Tree, Bitmap, Function-based indexes) and query optimization techniques. • Hands-on experience in bulk data processing using PL/SQL collections, bulk collect, and FORALL operations to improve performance. • Experience in loading large volumes of data using SQL Loader, External Tables and batch processing techniques. • Worked on data warehouse migration projects from Oracle to Snowflake cloud platform. • Experience working in Banking and Insurance domains, understanding financial data processing and reporting requirements. • Familiar with Agile development methodology, version control tools (Git), and project tracking tools such as Jira.

Experience

1. Snowflake Developer

   Bandhan Bank

   Jul 2024 — Present · Kolkata, IN

Education

• College of Engineering and Management, Kolaghat (CEMK)

  Bachelor of Technology (B.Tech.), ELECTRICAL ENGINEERING

  2012 — 2016