Summary
Overview
Work History
Education
Skills
Websites
Timeline
Generic
Gunasekhar Jasty

Gunasekhar Jasty

Houston

Summary

Accomplished Data Engineer with 4 years of experience specializing in Snowflake for cloudbased data warehousing and analytics, driving data-driven business solutions. Proficient in ETL processes, SQL, Python, data pipelines, AWS, and Apache Spark/Airflow, with a Masters in Computer and Information Sciences. Created and automated complex ETL workflows using Snow SQL, AWS Glue, and other tools to transform and load data from various sources. Improved query performance through partitioning, multi-cluster warehouses, and other optimization techniques in Snowflake. Skilled in designing and optimizing Snowflake data pipelines, ensuring efficient data ingestion, transformation, and storage for enterprise-scale analytics. Adept at writing complex SQL queries to extract actionable insights from Snowflake databases, enhancing decision-making processes. Experienced in leveraging Python for data processing, automation, and integration with AWS services like S3, Lambda, and Glue. Proficient in using Apache Spark for big data processing and Apache Airflow for orchestrating complex data workflows, improving pipeline reliability. Strong collaborator, working with cross-functional teams to deliver scalable data solutions that align with business objectives. Analyze and process large datasets from diverse sources like SQL Server tables, XML files, and flat files using Informatica, and load transformed data into target tables. Recognized for implementing cost-effective Snowflake solutions, optimizing query performance, and reducing operational costs. Committed to staying current with cloud and data technologies, ensuring innovative and efficient analytical solutions. Create dashboards and visualizations using Looker to enable real-time monitoring and effective decision-making for business users.

Overview

6
6
years of professional experience

Work History

Snowflake Data Engineer

DATATECH SYSTEMS LLC.
HOUSTON
01.2024 - Current
  • Designed and implemented Snowflake data pipelines using ETL processes and AWS services (S3, Glue), reducing data processing time by 30%.
  • Wrote advanced SQL queries in Snowflake to analyze customer behavior, resulting in a 20% increase in targeted campaign effectiveness.
  • Automated data workflows using Python and Apache Airflow, streamlining data ingestion and transformation for real-time analytics.
  • Optimized Snowflake query performance, leveraging Apache Spark for large-scale data processing, saving 15% in compute costs.
  • Implemented role-based access control (RBAC) in Snowflake to enhance data security and comply with internal audit policies.
  • Designed and enforced data retention policies using transient and temporary tables, optimizing storage costs and meeting compliance.
  • Created data masking policies for PII fields in Snowflake using dynamic data masking features to support secure analytics.
  • Built Python-based monitoring scripts to track Airflow DAG performance and alert for SLA violations.
  • Led weekly data pipeline review sessions with cross-functional stakeholders to prioritize and resolve data quality issues proactively.

Junior Data Engineer

Apex health care
hyd
12.2020 - 05.2022
  • Developed ETL processes to load data into Snowflake from multiple sources using Python and AWS Lambda, improving data availability by 25%.
  • Utilized SQL to create reports in Snowflake, enabling sales teams to identify market opportunities and achieve a 10% revenue increase.
  • Supported data pipeline orchestration with Apache Airflow, ensuring consistent data flow and reducing pipeline errors by 20%.
  • Assisted in integrating AWS S3 with Snowflake for efficient data storage and retrieval, enhancing data team productivity.
  • Conducted impact analysis before making changes to production SQL queries and data models to prevent breaking dependencies.
  • Created Snowflake share objects for secure and controlled data exchange with external partners and vendors.
  • Integrated SNS notifications in Airflow to send email alerts on data load failures and recovery completion.
  • Developed a Python-based CLI utility to automate manual data validation checks before data ingestion.
  • Created parameterized SQL scripts for reusability across multiple datasets, reducing development time for analysts.

Data Engineer Intern

GLINT SOFT
HYD
03.2019 - 11.2020
  • Executed SQL queries in Snowflake to support operational reporting, contributing to monthly performance reviews for leadership.
  • Design and implement efficient Snowflake stages for data loading, optimizing warehouses, and managing different table types.
  • Built initial ETL workflows using Python to prepare data for Snowflake, reducing data processing time by 15%.
  • Assisted in configuring AWS S3 buckets for data storage, enabling seamless data integration with Snowflake.
  • Supported data cleaning and validation using Python, ensuring high-quality datasets for analytical projects.
  • Wrote test cases and assertions in Python for validating ETL transformations during pipeline development.
  • Participated in data schema evolution discussions, ensuring historical data consistency during column additions or type changes.
  • Used AWS Athena and Glue Crawlers to profile raw datasets before integrating them into Snowflake.
  • Collaborated with DevOps to enable CI/CD for ETL workflows using GitHub Actions and Airflow deployment scripts.
  • Conducted a benchmarking analysis of different Snowflake virtual warehouse sizes to evaluate cost vs. performance trade-offs.

Education

Master of Science - Computer and Information Sciences

Western Illinois University
12.2023

Skills

  • SQL
  • Python
  • Pandas
  • NumPy
  • Matplotlib
  • Snowflake
  • Apache Spark
  • Apache Airflow
  • Oracle
  • AWS
  • S3
  • Lambda
  • Glue
  • ETL
  • Data Pipelines
  • Data Modeling
  • Database Management
  • Data Visualization
  • Statistical Analysis
  • Workflow Orchestration

Timeline

Snowflake Data Engineer

DATATECH SYSTEMS LLC.
01.2024 - Current

Junior Data Engineer

Apex health care
12.2020 - 05.2022

Data Engineer Intern

GLINT SOFT
03.2019 - 11.2020

Master of Science - Computer and Information Sciences

Western Illinois University

Similar Profiles

CREATE PROFILE
Gunasekhar Jasty