KARTHIK RAVIKUMAR
Snowflake Developer
Karthikravikumar606@[Link] | 88382-43296 | Chennai, Tamil Nadu
SKILLS
PROFESSIONAL SUMMARY
Snowflake DB
ELT Pipelines Accomplished IT professional with over 9+ years of experience, including 5 years of specialized
Oracle DB expertise in Snowflake Data Warehouse. Adept in end-to-end SDLC practices with a solid grounding in
Python (Basics) data warehousing concepts such as star and snowflake schemas, fact and dimension modeling. Highly
skilled in SQL and PL/SQL for complex data transformations, with proven success in architecting
scalable ETL/ELT pipelines that integrate AWS cloud and Snowflake. Experienced in leveraging
advanced Snowflake capabilities—Snowpipe, Streams, Tasks, Stored Procedures, UDFs, Time Travel,
Tools Fail Safe, and Cloning—to deliver resilient and efficient data solutions. Proficient in DBT for modular
transformations, Snowflake Cortex AI for AI-driven data insights, IICS for enterprise ELT, Airflow for
Snow SQL orchestration, and ADF for cloud-native data integration, with a strong focus on query optimization,
DBT core (Data Build governance, and security. Recognized for delivering high-performance, compliant, and business-
Tool) aligned data platforms within Agile environments.
Snowflake Cortex AI
IICS
Oracle SQL Developer
GitHub
Jenkins / Jira DETAILED EXPERIENCE
AWS S3
Apache Airflow
Azure Data Factory
(ADF) PROJECT 1
CLIENT - First Citizens Bank
WORK EXPERIENCE Domain- Banking and financial services
ENVIROMENT- Snowflake. DBT. Apache Airflow
Fidelity Investments
Developer
Sep 2021 – Mar 2026 Migrated raw data into Snowflake and transformed it into clean, business-friendly models using
DBT.
Wipro Private Limited Organized pipelines into staging, intermediate, and marts layers for modular transformations.
Developer Applied DBT tests (not null, unique, relationships) to ensure accuracy and integrity.
Feb 2018 – Feb 2021 Documented tables and columns for analysts, enabling transparency and lineage tracking.
Orchestrated workflows with Apache Airflow, building DAGs to automate daily and near-real-time
Accenture Pvt Ltd processes.
Support Eng. Handled SCD Type 1 and Type 2 scenarios using DBT snapshots and merge strategies.
May 2016 – Jan 2018 Enhanced reporting accuracy by reducing manual intervention, enabling faster delivery of
payment insights to stakeholders.
Collaborated with cross-functional teams to ensure smooth migration and adoption of DBT across
the enterprise.
EDUCATION Leveraged Snowflake Cortex AI functions for intelligent data enrichment and analytics, enhancing
DBT-driven transformation workflows.
[Link].
Madras Christian College
PROJECT - 2
CLIENT - Citigroup
Domain- Global banking and financial services
ENVIROMENT- Snowflake. ADF. PL/SQL
Designed and implemented Snowflake objects including warehouses, schemas, tables, views, pipes,
and stages.
Built scalable ELT pipelines with ADF and PL/SQL to ingest API and transactional data into
Snowflake.
Configured Snowpipe for continuous data load integration from AWS S3 into transaction tables.
Applied copy options for error handling and optimized ingestion performance.
Conducted validation checks (count and content) to reconcile source and production data,
analyzing mismatches and resolving root causes.
Supported ongoing improvements and maintenance of Snowflake DB applications.
Strengthened fraud detection by enabling near real-time ingestion and monitoring of suspicious
transactions.
Improved compliance reporting by ensuring validated, accurate data was consistently available for
audits.
PROJECT - 3
CLIENT - Union Capital Group
Domain- Anti-Money Laundering (AML) & Regulatory Compliance
ENVIROMENT-Snowflake, IICS
Designed and implemented Snowflake objects including file formats, stages, tables, views, pipes,
tasks, and stored procedures to support AML monitoring.
Loaded large volumes of structured and semi-structured data (CSV, JSON, Parquet) from AWS
S3 into Snowflake using COPY INTO.
Developed complex ETL mappings, mapplets, and reusable transformations for daily data
loads using IICS.
Applied robust error handling and validation to ensure data quality, compliance, and
reliability.
Collaborated with production support teams to resolve issues promptly and consistently meet
SLA commitments.
Participated in defect resolution during sprints, ensuring zero-defect releases and smooth
deployments.
Enabled faster detection of money-laundering patterns by integrating diverse data sources
into Snowflake.
Reduced operational downtime by streamlining ETL workflows and strengthening error
recovery mechanisms.