Summary
Overview
Work History
Education
Skills
Disclaimer
Timeline
Generic
Tejesh Naramsetti

Tejesh Naramsetti

Chennai

Summary

  • Professional with around 8.9 years of experience in Snowflake DB development, Snow SQL, and data engineering, with skills in Snowpipe, stream, task, Oracle DB development, and Informatica IICS for data loading.
  • Used AWS, S3, IAM, and storage integrations for migration.
  • Implemented database and application security, created design documents, and solved several use cases in a complex application.
  • Hands-on experience in all stages of system development efforts, including requirement analysis, design, testing, and implementation.
  • Interacted with the business users, collected the requirements, analyzed the requirements, designed, and recommended solutions.
  • Involved the creation of the snow pipe to integrate the data between the AWS cloud and the Snowflake DB. Experience in analyzing existing SQL queries for performance improvements and suggesting new queries.
  • Having knowledge of time travel, failsafe, and also data sharing between the Snowflake accounts.
  • Used sequences to generate the data sequence number for the primary key, serial of data.
  • Involved the creation of the snow stream object to create the audit table data backup of the data whenever the DML is happening on base tables.
  • I used the Clone technique in the Snowflake database to take a backup of the data whenever needed.
  • Coordinate with the team onsite for a smooth deployment, any change management, or production issues. Knowledge in Oracle advanced SQL programming using analytical functions, subqueries, joins, and so on.
  • Having knowledge in incident management, problem management, and change management.

Overview

9
9
years of professional experience

Work History

Senior Snowflake Developer

Cognizant Technology solutions
Chennai
01.2022 - Current
  • Data migration from Oracle Database to Snowflake using flat files for application migration from Oracle DB to Snowflake.
  • Experience in Snowflake's object development, such as warehouses, schemas, databases, tables, views, pipes, stages, and scaling policies utilization, roles.
  • Data migration for structured data: by creating stage and copy, transforming data, copy on error, file format, and all copy options.
  • Have hands-on experience in loading unstructured data with minimal load using VARIANT datatype, Flatten, Parquet, etc.
  • Developed Snowflake procedures, functions, and UDTF (User Defined Table Function).
  • Created an external table to access the data from the files when file access was denied in AWS S3.
  • I participated in defect meetings with the Project Manager and Development Team, identified gaps, and suggested relevant solutions.
  • I worked with the Testing Team and created test cases for major product releases.
  • Supported technical teams in the execution of database objects by testing services at the unit, system, and integration levels.

Software Engineer

ICICI BANK PVT LTD
01.2019 - 12.2021
  • Created a Snow Pipe to read the data from AWS S3 and loaded the data to Snowflake DB to ensure the continuous data integration between Oracle and Snowflake DB.
  • Created snow tasks as a task tree to read the data from the snow stream objects that are created on the base table, to maintain the backup of data while DML operations in the target Snowflake DB.
  • Used secure views and materialized views to share the data with the partner application as per the data requests.
  • Implemented backup and recovery strategies, conducting regular backups, and automated recovery tests to ensure data availability and integrity.
  • Conducted performance tuning and optimization, analyzing SQL query execution plans, and database metrics to enhance system efficiency.
  • Troubleshot and resolved database issues, collaborating with cross-functional teams for swift resolution.

PL SQL Developer

ICICI BANK PVT LTD
08.2016 - 12.2018
  • 2+ years of software development experience, with expertise in Oracle SQL, PL/SQL, and banking domain experience.
  • Involved in new customization points by using Oracle procedures, packages, and collections.
  • Created PL/SQL packages, procedures, functions, triggers, and exception handling for retrieving, manipulating, checking, and migrating complex data sets.
  • Optimize query and performance tuning using indexing, partitioning, tracing queries, and collections in Oracle PL/SQL.
  • Involved in SQL query tuning and performance tuning using 'plan and index analysis.'
  • Converted the business need into technically complex SQL queries and subqueries using analytical functions, joins, and operators.
  • Maintained detailed documentation of database configurations and procedures, facilitating knowledge transfer and compliance.
  • Effectively communicated with team members and stakeholders, providing technical support and guidance on database matters.

Education

B.Tech - Mechanical engineering

Chaitanya Engineering College
Bhimavaram, Andhra Pradesh
01.2013

Skills

    Primary skills:

  • Snowflake
  • AWS S3
  • ETL concepts
  • Oracle SQL
  • PL/SQL
  • PYTHON
  • DBT
  • MYSQL
  • Data warehousing

    Operating systems

  • Windows
  • UNIX
  • Tools and utilities

  • SQL Developer
  • GIT
  • JIRA
  • Putty
  • ServiceNow
  • IICS

Disclaimer

I confirm that the information provided above is accurate to the best of my knowledge and belief

Timeline

Senior Snowflake Developer

Cognizant Technology solutions
01.2022 - Current

Software Engineer

ICICI BANK PVT LTD
01.2019 - 12.2021

PL SQL Developer

ICICI BANK PVT LTD
08.2016 - 12.2018

B.Tech - Mechanical engineering

Chaitanya Engineering College
Tejesh Naramsetti