Ravi Korlam
Data Engineer
Visakhapatnam,AP
Summary
Data Engineer with 8 years of experience seeking a challenging position which provides job satisfaction, self-development and help achieve organizational as well as personal goals.
Overview
8
8
years of professional experience
4
4
years of post-secondary education
2
2
Certifications
Professional Summary
- Demonstrated knowledge in designing and developing optimum ETL solutions using Abinitio and Informatica.
- Experience in designing and developing ELT solutions using Snowflake and BigQuery.
- Well versed in SQL, Python, Unix shell scripting and data warehousing concepts.
- Snowflake cloud Data warehouse certified.
- Implemented Bulk and micro-batch load from GCS to Snowflake using PubSub, Storage integration, Notification Integration and Snowpipe.
- Implemented CDC, SCD Type 1 and 2 in Snowflake using Pipes, Streams, Tasks and Stored procedures.
- Strong knowledge of Snowflake zero-copy cloning, time travel, clustering, data masking, data shares, replication, snowsql, resource monitors and RBAC/DAC.
- Worked on Google Cloud using GCS as Data lake, BiqQuery as DWH, PubSub for messaging, Building pipelines using Dataflow & DataFusion, Triggers using CloudFunctions, Workflows using Cloud Composer.
- Hands-on experience on Infrastructure as Code, Hashicorp Certified Terraform Associate.
- Migrated Oracle database to Amazon Aurora MySQL using AWS SCT and DMS.
- Implemented a serverless webapp using AWS Amplify, Cognito, API Gateway, Lambda and Dynamo DB.
Work History
Business Analyst (CITI Bank)
LTI
Bangalore, Karnataka
01.2021 - Current
- Worked on remediating Data Quality issues in Genesis datamart used for regulatory reporting.
- Profile data, analyze Datastage code and BTEQ scripts to identify data gaps, classify and document the issues
- Interacting with various external stakeholders such as data owners and data modelers to address source data issues.
- Implemented multiple POCs for legacy to cloud migration using Snowflake and GCP.
ETL Operations Lead (BT)
Torry Harris Business Solutions
Bangalore, Karnataka
09.2020 - 01.2021
- Led ETL operations along with outbound and inbound campaign operations, total team size of 10 in running day to day jobs, releases and maintaining stability.
ETL Designer (BT)
Torry Harris Business Solutions
Bristol, UK
12.2018 - 08.2020
- Consulted with clients to identify design requirements and create architecture and technical design documents to communicate solutions that will be implemented by development team.
- Performed impact analysis and created high level designs and estimates for number of projects.
Senior ETL Developer (BT)
Torry Harris Business Solutions
Bangalore, Karnataka
11.2017 - 11.2018
- Worked extensively with Ab Initio GDE Database components, Partitioning, De-partitioning, Sort, Transform components, Graphs, Psets and Plans.
- Perform code reviews and other quality assurance steps as requested.
ETL Developer (Suntrust Bank)
Infosys
Mysore, Karnataka
04.2014 - 10.2017
- Develop and test Abinitio ETL jobs with all functionalities as per requirement.
- Created Design checklist, TDD, artifact list, tag list and implementation plan.
Education
P.G. - Cloud Computing
Great Lakes
Chennai 05.2021 - 12.2021
B.E. - E.C.E.
Anil Neerukonda Institute of Technology And Scienc
Visakhapatnam 10.2010 - 04.2014
Skills
Snowflake
Abinitio
RDBMS
Unix shell scripting
GCP Data Services
Terraform
Python
Certification
Snowflake Snowpro Core
Accomplishments
- Earned a Davinci Partnership award from British Telecom for my contributions as ETL designer.
- Earned a Spot award from THBS for standout performance.
- Earned multiple Infosys Insta awards for delivering code with zero defects.
Timeline
HashiCorp Certified Terraform Associate
10-2021
P.G. - Cloud Computing
Great Lakes
05.2021 - 12.2021
Business Analyst (CITI Bank)
LTI
01.2021 - Current
Snowflake Snowpro Core
01-2021
ETL Operations Lead (BT)
Torry Harris Business Solutions
09.2020 - 01.2021
ETL Designer (BT)
Torry Harris Business Solutions
12.2018 - 08.2020
Senior ETL Developer (BT)
Torry Harris Business Solutions
11.2017 - 11.2018
ETL Developer (Suntrust Bank)
Infosys
04.2014 - 10.2017
B.E. - E.C.E.
Anil Neerukonda Institute of Technology And Scienc
10.2010 - 04.2014