Summary
Overview
Work History
Education
Skills
Affiliations
Timeline
Generic

Abishake AB

Chennai

Summary

  • I have around 6 Years of experience in snowflake data warehousing and development.
  • Proficient in Snowflake's SQL and snowflake object development including tables, views, stages, file formats, and tasks.
  • Proficient in implementing data warehousing solutions, ETL workflows and performance optimization.
  • Strong foundation in data warehousing concepts such as star schema, snowflake schema, dimension modeling,Fact and dimension tables.
  • Experienced in building snowflake streams to track changes on base tables using DML operations.
  • Hands on writing complex SQL queries using aggregate functions, window functions, set operators, and single row functions.
  • Having knowledge on time travel, and retention period to access historical data.
  • Skilled in working with joins, subqueries.
  • Implemented snow pipe to automate continuous data ingestion from AWS S3 into snowflake.

Overview

7
7
years of professional experience

Work History

__________________________________________________

Amazon Development Center
Chennai
08.2020 - Current

Recent Project:

Domain: BFSI Client: Bank of America Duration:3 years

  • Processed trading application data in CSV, JSON, and Parquet formats.
  • Our upstream team loads files into AWS S3 bucket.
  • Set up Snowflake Snowpipe for automated ingestion, copied ARN from Snowpipe properties, and mapped notification channel to SQS queue in S3 event notification settings.
  • Wrote Python script to split large files and load data into Snowflake.
  • Used dbt to transform data for SCD Type 1 with incremental model and merge strategy, built reusable macros, loaded small CSV files with seeds, and implemented SCD Type 2 with snapshots.
  • Ran validation through singular tests and custom tests.
  • Scheduled jobs with Apache Airflow, processed PDF files with Cortex AI functions such as AI Complete, Summarize, Sentiment, and Parse Document, applied RBAC and RLS for security and compliance.
  • Collaborated with business analyst team and client.

Previous Project:

Domain: Healthcare Client: United Health Group Duration:2.5 years

  • Migrated data from Oracle and SQL Server into Snowflake.
  • Used Talend ETL tool to move data directly into target platform.
  • Applied transformation logic and business rules in Snowflake through procedures and functions.
  • Used Streams and Tasks for scheduling and CDC data capture.
  • Used Time Travel to retrieve data and review historical records.
  • Used Zero Copy Cloning during unit testing.
  • Applied RBAC and Dynamic Data Masking for security and compliance.

__________________________________________________

Sutherland
Chennai
08.2019 - 10.2019
  • Answered calls, emails, and chat messages
  • Processed orders, returns, and account updates
  • Documented customer issues in service systems
  • Escalated complex complaints to supervisors

Education

Bachelor of Engineering - Electronics And Instrumentation

Sri Sairam Engineering College
Chennai
05-2019

Skills

  • Snowflake development
  • SQL
  • Oracle
  • Data Warehousing
  • Dbt modeling
  • ETL/ELT concepts
  • Python scripting

Affiliations

  • DBT
  • JIRA
  • Oracle
  • SQL Server
  • Talend

Timeline

__________________________________________________

Amazon Development Center
08.2020 - Current

__________________________________________________

Sutherland
08.2019 - 10.2019

Bachelor of Engineering - Electronics And Instrumentation

Sri Sairam Engineering College
Abishake AB