Gayatri Gunjal
Summary
Data Engineer with expertise in building scalable pipelines, optimizing ETL workflows, and enabling analytics through Snowflake, Redshift, and AWS. Skilled in automation, data quality, and cloud-native solutions, delivering efficient and reliable data systems.
Overview
4
4
years of professional experience
1
1
Certification
Work History
Data Engineer I
CSG International
07.2024 - Current
- Designed and optimized ELT workflows processing 10M+ rows daily from S3 to Snowflake and Redshift, with layered architecture, modular pipelines, and CI/CD deployment via GitHub Actions, ensuring scalable and secure production environments.
- Migrated data architecture from Redshift to Snowflake for 5+ clients, implementing ingest, staging, and mart layers, data validation, deduplication, and improving query performance by 40%.
- Developed automated monitoring and error tracking systems analyzing 20M+ daily records, identifying anomalies (feed spikes, ingestion failures), integrating SNS/SQS alerts and OpsGenie logic, reducing load issues by 40% and enhancing stakeholder visibility.
- Built dynamic dashboards and performed storage audits leveraging Redshift and Domo to track IVR KPIs, evaluate S3 usage and retention, implement lifecycle policies, and deliver actionable insights for optimized customer engagement and cost savings.
Graduate Engineer Trainee
VOIS
08.2023 - 06.2024
- Improved ETL efficiency by 50% using Ab Initio and parallel processing.
- Automated recurring tasks with shell scripting and enhanced error handling.
- Collaborated with stakeholders to deliver faster and more accurate reporting.
Zensar ESD Trainee
ZENSAR TECHNOLOGIES
09.2021 - 01.2022
- Completed training in Python, SQL, Git, and Tableau, applying OOP to analyze datasets.
- Improved research efficiency by 40% through structured collaboration.
Education
Bachelor of Engineering - Electronics & Telecommunication Engineering
Savitribai Phule Pune University
05.2023
Skills
- Programming & Scripting: Python, PySpark, SQL, Unix Shell Scripting
- Data Engineering & Workflow: ETL/ELT, Airflow, Snowflake, Redshift, Glue, Domo (Cards, Beast Modes, Dataflows, Dashboards), Tableau, Ab Initio
- Databases: MySQL, Oracle, MongoDB
- Cloud & Big Data: AWS (S3, Lambda, EC2, Redshift, SES, SNS, SQS, API Gateway, EventBridge, DLQ, Glue, CloudWatch), Terraform
- Version Control & CI/CD: Git, GitHub, Azure DevOps, CI/CD pipelines
- Machine Learning & Analytics: Machine Learning, Statistical Modeling, Scikit-learn
Certification
- AWS Pilot Training(Link)
- IBM Data Analysis Using Python(Link)
- Data Analytics Course By Coding Ninja(Link)
Projects
· Automated Data Ingestion Framework (AWS + Redshift + Python)
Built ingestion system for CSV/Parquet/JSON in S3 → Redshift with schema validation and deduplication, improving delivery speed by 60% and ensuring consistent downstream analytics.
Designed end-to-end alerting pipeline with automated email delivery and tracking (sent, bounced, delivered), reducing manual monitoring and improving responsiveness. · Scalable ETL Framework (Snowflake, Redshift, MongoDB, Python)
Developed ingestion & transformation logic with schema consistency, data lineage, and error handling. Enabled near real-time analytics with 30%lower latency and automated validation via SNS.
Timeline
Data Engineer I
CSG International
07.2024 - Current
Graduate Engineer Trainee
VOIS
08.2023 - 06.2024
Zensar ESD Trainee
ZENSAR TECHNOLOGIES
09.2021 - 01.2022
Bachelor of Engineering - Electronics & Telecommunication Engineering
Savitribai Phule Pune University