Summary
Overview
Work History
Education
Skills
Disclaimer
Languages
Personal Information
Timeline
Generic

Adharsh Selva Keerthan

COIMBATORE

Summary

With over 5 years of experience in development of Data Warehouses in Snowflake and ETL Concepts. Actively involved in constructing Snowpipe to get continuous data loading between the Snowflake database and the AWS cloud for streamlined data integration. Worked in Failsafe - time travel functionality, and data exchange capabilities across Snowflake accounts. Implemented data sequence number generation for primary key serials using sequences to ensure efficient and reliable assignment of unique identifiers to data records. Involved in creation of Snowflake stream objects to automatically capture changes made to fundamental tables, enabling efficient backup of audit table data whenever DML operations are performed. Used Snowflake's cloning feature to create data backups, ensuring integrity and accessibility for testing and analysis purposes.

Overview

5
5
years of professional experience

Work History

Snowflake developer

TCS
08.2019 - Current
  • The data migration process involves transferring data from an Oracle database to Snowflake, utilizing flat files stored in Amazon S3 for application migration to Snowflake
  • Knowledge of the features of the Snowflake object development environment, familiar with managing and optimizing repositories, projects, databases, tables, views, pipelines, components, policies, and work
  • Proficient in loading unstructured data into Snowflake using various efficient methods, including the VARIANT datatype for semi-structured data, the FLATTEN function for nested data, and the Parquet format for optimized storage and query performance
  • Developed Snowflake Procedures, Functions, UDTFs, and transformation logic in various ways can significantly enhance the flexibility and functionality of your data processing and manipulation capabilities
  • Developed an external table to facilitate the retrieval of data from the files in the event that file access is denied in AWS S3

Snowflake developer

TCS
08.2019 - 06.2021
  • Developed PL/SQL packages, procedures, functions, triggers, and exception handling mechanisms to proficiently handle complex data sets, encompassing retrieval, manipulation, validation, and migration tasks
  • Query optimization and performance tuning are achieved through indexing, partitioning, query tracing, and the utilization of collections, ensuring efficient data retrieval and processing in database environments
  • Business requirements were meticulously translated into intricate SQL queries and subqueries, leveraging advanced analytical functions, joins, and operators to meet technical objectives effectively
  • The utilization of bulk collections significantly enhanced data retrieval processes, ensuring smoother performance and optimized efficiency
  • UNIX commands such as grep, awk, and sed were harnessed proficiently to manage files and directories with precision and flexibility
  • Exception handling mechanisms were robustly implemented to enable seamless debugging and furnish informative error messages, thereby enhancing application reliability and user experience

Education

B.Tech - IT

Skills

  • Snowflake DB
  • AWS S3
  • ETL concepts
  • Python
  • ORACLE
  • SQL
  • PL/SQL
  • SQL developer
  • IICS
  • Control M
  • Jenkins
  • GitHub Desktop
  • JIRA

Disclaimer

I hereby declare that all the above statements are true to the best of my knowledge.

Languages

  • Tamil
  • English
  • Hindi

Personal Information

  • Father's Name: A.K.Nagarajan
  • Date of Birth: 06/20/90
  • Marital Status: Married

Timeline

Snowflake developer

TCS
08.2019 - Current

Snowflake developer

TCS
08.2019 - 06.2021

B.Tech - IT

Similar Profiles

CREATE PROFILE
Adharsh Selva Keerthan