Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Soumak Das

Soumak Das

Senior Consultant
Uttarpara,WB

Summary

Soumak is a passionate data engineer working in migrating on-premises DWHs to cloud DHWs solutions. Migrated Teradata to Snowflake, Veritca to Snowflake, MySQL to singlestore and MySQL to AWS. The vast experience in data migration helps to deliver the work accordingly. With 7 years of experience in this field have given the required mastery in various databases i.e., Oracle, Teradata, Vertica, Singlestore, Snowflake, MySQL. Expertises in ETL (informatica) and Data Orchestration tools (apache airflow) has allowed to deliver work on time and has proven patience and skills time and over again and is willing to explore the field further and deeper as and when opportunities arise.

Overview

6
6
years of professional experience
4
4
years of post-secondary education
5
5
Certifications
3
3
Languages

Work History

Senior Consultant

E&Y LLP
Kolkata
10.2022 - Current
  • Creating an automated Logging and Monitoring(L&M) framework using several Azure services such as Azure Logic Apps, log analytics, ADF, Synapse studio, Blob Storage, Power BI and azure functions using python scripting.
  • Moving on-premises data from Teradata to Azure Synapse Studio and then moving data into Snowflake DWH.
  • Creating PowerBI Dashboard to create reports for Log and Monitoring framework.
  • Managing the whole L&M using Agile methodology and maintain in Azure Boards.
  • Using azure repos to maintain code.
  • Lead of team of 3 members, managing team and creating Presentations and Doc related to client representation.
  • Direct Client interaction to help articulate issues and provide solution to them.

Technology Specialist

AT&T
Bangalore
03.2021 - 10.2022
  • Migration of on-premises Teradata DWH to ADLS Gen2 and then to Snowflake DWH.
  • Loading data into azure data lake storage and then through SnowPipe and snowflake CLI, moving data into snowflake in python framework environment.
  • Troubleshooting various problems related to data transfer and data curation.
  • Using GIT for version control.
  • Using Azure Data factory to move data into ADLSg2 containers and creating analytic dashboard on top of snowflake using power BI.
  • Helping Vendor Companies to understand and implement Snowflake.
  • Snowflake SME and Coach.

Technology Analyst

Infosys
Bangalore
10.2019 - 02.2021
  • Performed Data loading from traditional Teradata/Oracle EDW to snowflake Data warehouse.
  • Using snowflake Serverless feature such as Snowpipe and Automatic clustering.
  • Established 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 and Route-53 services for storage and role control.
  • Oracle 12C and Teradata PL-SQL language for checking and monitoring batches from backend.
  • Using Data Virtualisation tool Dremio to access data from amazon S3 and HDFS for dashboard creation in Tableau.
  • UNIX bash shell scripting to carry out day to day tasks for MacOS environment.
  • Using Singlestore to write views and DML operations.

Systems Engineer

TATA Consultancy Services
Kolkata
11.2016 - 10.2019
  • Used PLSQL Oracle 12c for writing procedures, triggers, packages, complex views.
  • Used Informatica Power Centre ETL tools for sending data to downstream applications.
  • Involved in end-to-end development of logics of leave system in TCS Ultimatix Global HR-Digitization Process (Internal) which processes data for more than 5.5lakh employees.
  • Written TDE/TCE codes for data encryption in tables and columns for implementation of GDPR into TCS.
  • Worked in Informatica for designing and developing mappings, from varied transformation logic.
  • Followed Agile Scrum methodology and participated in various scrum events for day-to-day activities.
  • Created CI/CD pipeline using Jenkins opensource and tortoise SVN repository to execute DEV/UAT codes.
  • Solving issues raised by support team within given SLA.

Education

B.Tech - Electronics and Communication Engineering

West Bengal University & Technology(WBUT)
Kolkata
07.2012 - 06.2016

Skills

Snowflake DWH

undefined

Certification

Snowflake Snow-Pro Core Certified

Timeline

Senior Consultant

E&Y LLP
10.2022 - Current

Technology Specialist

AT&T
03.2021 - 10.2022

Technology Analyst

Infosys
10.2019 - 02.2021

Systems Engineer

TATA Consultancy Services
11.2016 - 10.2019

B.Tech - Electronics and Communication Engineering

West Bengal University & Technology(WBUT)
07.2012 - 06.2016

Similar Profiles

CREATE PROFILE
Soumak DasSenior Consultant