Soumak Das

Data Engineering

Data loading from traditional Teradata/Oracle EDW to snowflake Data warehouse. • Using snowflake Serverless feature such as Snowpipe and Automatic clustering. • Have in-depth understanding of how to work in Multi-Cluster Warehouses, resource monitors, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel in snowflake. • Using AWS S3, Lambda, cloud-formation and IAM services for storage and role control. • Batch creation and scheduling with Autosys.

Efficiently handled end-to-end processes in SDLC - Agile & Iterative Waterfall Involved in client interaction for cost & effort estimations, project planning & documentation of development approach & test plans Performance tuning of SQL queries to reduce execution time & improve database performance Developed complex database objects like Stored Procedures, Functions, Packages & Triggers using SQL & PL/SQL Worked in an integrated environment where applications shared data through ETL using Informatica