Sometimes you need to use data from more than one table. This article will explore different types of joins with simple examples

SQL is a very popular query language used by almost everyone has to work with data.

Every business relies on data analytics and its so common that the…


Hey There! I would like to share my personal experience and process of converting India driving license to Finnish license.

First a little background

I moved to “Vantaa, Finland” from “Dubai, UAE” in Aug-2018. Before I moved here, I wanted check if its possible to use my India or UAE driving license here in…


The purpose of this template is to write technical design elements before on boarding a data feed or asset to data platform

Hey There! I work for an airline and I am part of “Data Solutions Development” team. …


I would like to share the process and code to parse multiple CSV files at the same time which contains JSON in some of the columns

Hey There!, I work for an airline and I am part of “Data Platform” team. …


The purpose of this article is to tell you, how to use external tables and materialized views to create an event-driven data pipeline

Hello Readers, I work for an airline and I am part of the “Data Solutions Development” team. …


The purpose of this article is to share a method of parsing JSON in a CSV file column using python pandas

Hello, I work for an airline company and I am part of data team. …


In this article, I like to share a template which we use in our data team to document each data asset or feed before we on board to the data platform

Its very important for data teams to have good documentation framework or practice in place. …


The purpose of this article is to know, how to use Snowflake Stream, Stage, View, Stored procedure, and Task to unload a CSV file to AWS S3 bucket

Hello Readers, I work for an airline and I am part of the “Data Solutions Development” team. We use Snowflake as a…


The purpose of this article is to find out snowflake best practices to reduce and control compute cost

Hello Folks, I work for an airline and i am part of “Data Solutions Development” team. …


The purpose of this article is to show you how the fixed width file look like and how to understand the file structure to parse it

I work for an airline company. The revenue accounting system here sends coupon sales information to the data platform in fixed width text file…

Venkata Gowri Sai Rakesh kumar Varanasi

Tech Lead, Data Engineering at Paulig

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store