Data Engineering Command Center

RAMKUMAR G

Data Engineer
Snowflake Developer
ELT Pipeline Builder

Building scalable cloud data platforms using Snowflake, HVR, Fivetran, AWS, Informatica IICS and Power BI. Focused on CDC, ELT automation, Snowflake cost optimization and real-time analytics.

3

Production Projects

30+

Snowflake Concepts

100+

SQL Queries

2026

Graduate

Ramkumar G profile photo
❄ Snowflake
⚡ HVR
🔄 Fivetran
☁ AWS
📊 Power BI
Architecture Showcase

Real-Time Replication Lab

A clean recruiter-friendly view of how I move data from operational systems into Snowflake and make it analytics-ready.

🗄️

MySQL

Source Database

HVR CDC

Log-Based Replication

❄️

Snowflake

Cloud Data Warehouse

📊

Power BI

Live Dashboard

Featured Projects

What I Built

Every project is designed like a real data engineering workflow, not a basic student demo.

Project 01

Real-Time CDC Pipeline

MySQL → HVR → Snowflake → Power BI

Built a replication workflow focused on moving operational data into Snowflake using HVR-style CDC and preparing it for analytics dashboards.

✓ CDC Replication
✓ Incremental Loads
✓ Snowflake Target
✓ Power BI Reporting
MySQL Source 01
HVR Replication 02
Snowflake RAW/STG 03
Power BI Dashboard 04
Project 02

Modern Data Stack Pipeline

AWS RDS → Fivetran → Snowflake → Power BI

End-to-end ELT pipeline using RAW, STAGING and ANALYTICS layers with star schema modeling and live DirectQuery reporting.

✓ Fivetran Sync
✓ Star Schema
✓ Streams & Tasks
✓ DirectQuery
AWS RDS MySQL 01
Fivetran ELT 02
Snowflake Warehouse 03
Power BI Analytics 04
Project 03

Enterprise Analytics Platform

Oracle + AWS S3 → Informatica IICS → Snowflake → Power BI

Multi-source ELT pipeline combining relational and file-based data, modeled into fact and dimension views inside Snowflake.

✓ Multi-Source
✓ IICS Mapping
✓ Fact & Dimension Views
✓ Live Dashboard
Oracle + S3 01
Informatica IICS 02
Snowflake Views 03
Power BI Report 04
Snowflake Expertise

Advanced Snowflake Knowledge

Hands-on concepts I practiced through labs, projects, SQL exercises and LinkedIn learning posts.

Time Travel

Recovery, retention, dropped objects and fail-safe basics.

Streams & Tasks

CDC tracking and scheduled automation pipelines.

RBAC

Roles, privileges, ownership and secure access design.

Data Sharing

Secure sharing, inbound/outbound shares and marketplace basics.

Query Tuning

Query profile, pruning, clustering and performance analysis.

Cost Optimization

Warehouse sizing, auto-suspend and resource monitors.

Snowpipe

External stages, S3 integration and auto-ingest concepts.

Dynamic Tables

Target lag, refresh behavior and transformation pipelines.

My Toolbox

Data Engineering Stack

Snowflake
95%
SQL
90%
Fivetran
85%
HVR
80%
Informatica IICS
80%
AWS
75%
Power BI
75%
Learning Timeline

My Journey

01

SQL

02

Snowflake

03

AWS

04

Fivetran

05

Power BI

06

IICS

07

HVR

LET'S BUILD
DATA PLATFORMS

Open to fresher / trainee roles: Snowflake Developer, Data Engineer, ETL Developer and Cloud Data Engineer.