I have 5+ year of work experience working in the field of IT and am looking forward to an exciting and challenging career with an organization that provides an excellent working environment and opportunities.
Certified SnowPro Core.
Having a better understanding of Snowflake architecture and processing.
Good exposure to implementing Snowflake stored procedures and automation functionalities such as streams and tasks.
Hands-on experience in bulk loading and unloading data into Snowflake tables.
Knowledge on implementing SnowPipe for continuous data ingestion.
I extensively used SnowSQL for data loading and had sound knowledge of stages.
Experience with the Snowflake cloud data warehouse and the AWS S3/AAZURE bucket for integrating data from multiple source systems. Experience in building SnowPipe.
I worked on the AWS data pipeline to configure data loads from S3 data.
Writing advanced SQL scripts as per the business plan to transform the data.
I used Time Travel and Fail Safe for data recovery. In-depth understanding of Snowflake multi-clusterware housing, multi-cluster size, and credit usage.
Experience working with various data formats like XML, JSON, TSV, and TXT files.
Supervise ETL jobs and workflows to guarantee their successful and timely execution, including data extraction, transformation, and loading processes.
Swiftly investigate and rectify any failures or errors that occur during ETL job processing, particularly during data transformations.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Snowflake Developer / Data Engineer
VIZAG AMOGH PROJECT MANAGEMENT PVT LTD
Visakhapatnam
12.2020 - 12.2023
Worked on SnowSQL and Snowpipe
Converted Talend Joblets to support the snowflake functionality
Creating Transformer Pipelines and Data Collector Pipelines
Test, Validate and Deploy the Pipelines
Created Snowpipe for continuous data load
Used COPY to bulk load the data
Created data sharing between two snowflake accounts
Created internal and external stage and transformed data during load
Redesigned the Views in snowflake to increase the performance
Created Talend Mappings to populate the data into dimensions and fact tables
Consulting on Snowflake Data Platform Solution Architecture, Design, Development and deployment focused to bring the data driven culture across the enterprises
Building solutions once for all with no Band-Aid approach
Implemented Change Data Capture technology in Informatica in order to load deltas to a Data Warehouse.
Support Engineer
SYMBIOSYS TECHNOLOGIES
12.2019 - 11.2020
Responsible for Level 1 Troubleshooting of Cisco Devices for delivering uninterrupted service to the clients on data network
Also, the various alerts being raised with proper solution, by troubleshooting, by forwarding it to the higher level for further diagnosis, by remote access or contacting the field engineer and thereby solving the issue
Management of customer networks and providing a rapid response to customer raised incidents and problems
Monitoring and Management of the network at various remote locations using the monitoring tool Solar winds
Perform analysis and diagnosis on complex networking problems, identify issues, and resolve faults
Responsible for basic troubleshooting network routers to isolate the trouble and take appropriate action to resolve
Provides supports to the clients for delivering uninterrupted services
Working with vendors and onsite Field Engineers to troubleshoot issues and coordinate dispatches
Liaise with Upstream Service providers, Peers and Internet Exchanges to ensure efficient operation of IP network
Communicate with other Network Operation Centre’s and escalate where necessary both internally and externally in order to meet SLAs
Handle escalations and be a focal point to all IP service-related queries
Maintain proper documentation, case history in service tickets
Ensure timely follow up with customers via e-mails or phone calls.
PRODUCTION SUPPORT
HMI ENGINEERING SERVICES
10.2018 - 11.2019
Supervise ETL jobs and workflows to guarantee their successful and timely execution, including data extraction, transformation, and loading processes
Swiftly investigate and rectify any failures or errors that occur during ETL job processing, particularly during data transformations
Conduct in-depth root cause analyses for ETL issues, with a focus on transformation-related problems, and apply corrective measures as needed
Apply industry best practices for designing, optimizing, and fine-tuning ETL job transformations to enhance data quality and performance
Collaborate closely with developers to improve and sustain ETL processes, with an emphasis on refining data transformation logic
Maintain comprehensive documentation of ETL processes, configurations, and transformation rules
Execute data validation and quality assessments, including transformation result validations, to ensure data accuracy, completeness, and conformity with business rules and requirements.
Education
B-Tech - Electronics Communication and Engineering
JNTUH
01.2018
Diploma - Electronics Communication and Engineering
SBTET
01.2014
Skills
Snowflake
MSSQL
AWS S3
AWS IAM
Python
Data build tool (dbt)
Certification
SnowPro Core Certification
Timeline
Snowflake Developer / Data Engineer
VIZAG AMOGH PROJECT MANAGEMENT PVT LTD
12.2020 - 12.2023
Support Engineer
SYMBIOSYS TECHNOLOGIES
12.2019 - 11.2020
PRODUCTION SUPPORT
HMI ENGINEERING SERVICES
10.2018 - 11.2019
B-Tech - Electronics Communication and Engineering
JNTUH
Diploma - Electronics Communication and Engineering
Assignment Manager at International Trimmings And Labels (Vizag) India Pvt LtdAssignment Manager at International Trimmings And Labels (Vizag) India Pvt Ltd
Data Engineer – Snowflake & PL/SQL Developer at Carelon Global Solutions IndiaData Engineer – Snowflake & PL/SQL Developer at Carelon Global Solutions India