Rohith Neppala
Hyderabad
Summary
Seasoned data engineer with a proven track record at CONCENTRIX, specializing in Snowflake and AWS technologies. Expert in automating data workflows and enhancing data warehouse performance, leveraging skills in DBT and Terraform. Demonstrates strong analytical abilities and a knack for optimizing data processes, significantly improving operational efficiency.
Overview
3
3
years of professional experience
Work History
SnowFlake
Training
Hyderabad
08.2024 - 02.2025
- Knowledge in relational, dimensional database modeling, and data warehousing.
- Knowledge in extraction, transformation, and loading of data from multiple sources into data warehousing.
- Having a good knowledge of the Informatica PowerCenter tool.
- Written and optimized SQL queries within DBT to enhance the data transformation process and improve overall performance.
- Knowledge of Snowflake migration using Informatica, AWS cloud provider.
- Very good knowledge of warehouses, roles, schemas, databases, and resource monitors.
- Created different tables in Snowflake development.
- Experience in using Snowflake features like Snow Pipe, Streams, Tasks, Stages, Clustering, Time Travel, and Fail Safe.
AWS
Training
Hyderabad
10.2023 - 03.2024
- Configure AWS Identity and Access Management (IAM) roles and policies for secure access control.
- Managed the development and implementation of infrastructure automation solutions using AWS technologies such as EC2, S3, ECS, EKS, Lambda.
- Automated infrastructure deployment using AWS CloudFormation and Terraform to enhance operational efficiency.
- Developed CI and CD pipelines using CodePipeline and CodeBuild which can be used by DevOps teams for automated deployment of application code changes.
- Created IAM policies for users and groups with proper access control levels according to organizational security requirements.
- Deployed and managed containerized applications using Amazon ECS and EKS, improving scalability and deployment processes.
Associate Engineer
CONCENTRIX
Bangalore
04.2022 - 08.2023
- Company Overview: Bangalore
- Replicating operational tables into staging area transform and load data into enterprise data warehouse tables using Informatica power center from their legacy systems by ETL process
- Responsible for all activities related to the development, implementation, administration and support for large scale Snowflake cloud data warehouse
- Modifying existing queries and Writing SNOWSQL queries
- Used import and export from internal stage (Snowflake) vs external stage (S3 Bucket)
- Performed data quality checks to improve the performance of loading and unloading
- Used COPY, LIST, PUT and GET commands for validating internal and external stage files
- Perform troubleshooting analysis and resolution of critical issues
- Worked on streams and tasks to identify Change Data Captures
- Gather requirements to do analysis, design, and development and testing
- Bulk loading from external stage (AWS S3) to internal stage (snowflake) using COPY command
- Written Python scripts to automate the batch loads
- Good experience in implementing Python modules as per the requirement
- Involved in data cleansing to maintain quality and better performance
- Created data base objects like Snowflake tables, file formats, sequences, internal and external stages
- Hands on experience with Snowflake utilities snowsql, Snow Pipe, Time Travel and Zero copy Clone, Copy command, Tasks
- Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL
- Enhanced it with creating exceptions for error handling
- Created data sharing between two snowflake accounts
- Bangalore
Education
Bachelor of Engineering (B.E) -
The Oxford College of Engineering | VTU
Belagavi01.2021
Skills
- Snowflake
- DBT
- AWS
- Terraform
- Java
- Windows
- Linux
- Docker
- YAML
- SQL
Timeline
SnowFlake
Training
08.2024 - 02.2025
AWS
Training
10.2023 - 03.2024
Associate Engineer
CONCENTRIX
04.2022 - 08.2023
Bachelor of Engineering (B.E) -
The Oxford College of Engineering | VTU
Similar Profiles
Nicolas VonaNicolas Vona
Security Guard at TrainingSecurity Guard at Training
LIKITH KUMAR PYARASANILIKITH KUMAR PYARASANI
Intern at trainingIntern at training
Karma NorbuKarma Norbu
Basic IT at TrainingBasic IT at Training