Ravi Korlam

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.

• 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.

Snowflake Snowpro Core

• 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.