Summary
Overview
Work History
Education
Skills
Certification
Recognitions
Timeline
Generic

Sona Bhandary

Data Engineer
Udupi

Summary

Data Engineer with 9+ years of experience in designing, developing, and optimizing data pipelines, ETL workflows, and data warehouse solutions. Built 100+ end-to-end pipelines using Snowflake, Python, PySpark, Matillion, SQL, Scala, AWS EMR and Oracle Data Integrator (ODI), Oracle GoldenGate and Informatica PowerCenter. Expertise in cloud data platforms, big data processing, data migration, and performance tuning, delivering innovative, high-quality solutions that enhance analytics, reporting, and business intelligence capabilities.

Overview

10
10
years of professional experience
5
5
years of post-secondary education
4
4
Certifications

Work History

Senior Software Engineer

UNIFYCX
05.2020 - Current
  • Cloud Data Automation – Developed 100+ ELT jobs in Matillion/Python and 50+ Snowflake stored procedures to streamline data lake ingestion processes. Automated BigQuery-to-GCS exports using Cloud Run, reducing manual intervention by 60% .
  • Real-Time Event Processing – Leveraged Snowflake Streams to handle continuous ingestion of financial and marketing event data, ensuring timely availability of insights for retention and growth strategies.
  • Multi-Source Data Consolidation – Integrated and harmonized data from 10+ heterogeneous sources (Netezza, DB2, MySQL, Google Analytics, BigQuery, Meta API, Chargebee, Workday) into Snowflake for a unified, self-serve data platform.
  • Self-Serve Data Engineering Enablement – Developed reusable ETL templates, parameterized workflows, and modular stored procedures to allow analysts and teams to onboard new datasets with minimal engineering intervention.
  • Data Lake Enablement & EMR Optimization – Migrated and enhanced 10+ Scala, Spark, Hadoop, Hive, and Oozie workflows from EMR 5.2 to 7.7, improving scalability, processing speed, and reliability for data lake pipelines handling billions of records.
  • Google Analytics GA4 Migration – Designed and implemented a high-performance ETL pipeline to ingest and process millions of event-driven records into the enterprise data lake, ensuring 100% data integrity and meeting tight delivery deadlines.
  • Financial Growth & Retention Models – Built scalable ETL workflows in Snowflake for financial datasets, enabling revenue forecasting, retention trend analysis, and marketing ROI modeling for strategic growth initiatives.
  • Tableau Dashboard Optimization – Refactored SQL queries powering enterprise dashboards, improving performance by 83% and enabling near real-time analytics for stakeholders.
  • Process Automation – Created PowerShell and Python-based automation for scheduled data processing, optimizing operational efficiency and freeing up engineering bandwidth for innovation.
  • Version Control Automation – Automated GitHub script updates from Snowflake, ensuring better version tracking, governance, and collaboration across engineering teams.
  • AWS RDS Upgrade (MySQL 5.7 → 8.0) – Led blue/green deployment achieving 99.9% uptime; optimized schema and indexing for faster query performance, enabling uninterrupted data ingestion into analytics systems.

Data Engineer

Infosys Technologies
12.2015 - 05.2020
  • Designed and implemented 30+ end-to-end ETL pipelines using Oracle Data Integrator (ODI) and Informatica PowerCenter, streamlining enterprise data integration, improving automation, and reducing manual effort.
  • Led ODI upgrade from version 11 to 12, successfully migrating 50+ workflows within a 14-day window with zero production downtime.
  • Administered and optimized large-scale Oracle Database environments, performing performance tuning, capacity planning, and ensuring high availability for mission-critical workloads.
  • Automated stored procedure evaluation using Java, achieving a 70% automation rate, enhancing productivity, and accelerating delivery timelines.
  • Implemented and upgraded Oracle Business Intelligence (OBIEE), improving analytics and reporting capabilities across the organization.
  • Delivered large-scale technical training to 10,000+ trainees on Oracle products, Python programming, and BI tools, consistently earning 4.8–5.0/5 feedback ratings.
  • Managed and mentored 300+ trainees during foundation programs, leading 10+ internship projects from design to delivery.
  • Authored and contributed to learning resources, creating 3 courses and assisting with 5 others to enhance organizational knowledge-sharing.
  • Developed internal applications to automate processes and improve operational efficiency for data teams.

Education

Bachelor's - Electronics and Communication

Visvesvaraya Technological University
01.2011 - 01.2015

P.G. Diploma - Computer Applications

Fortune Institute of Technology
01.2010 - 01.2011

Skills

Python

undefined

Certification

Google Data Analyst Certificate, Coursera

Recognitions

  • Employee of the Month, 4, 1.5 years
  • Insta Award, 2, For excellence in execution
  • Most Valuable Player (MVP), 2019, For exceptional dedication and impact

Timeline

SQL (Advanced) Certificate, HackerRank
11-2024
Google Data Analyst Certificate, Coursera
05-2023
Google Finance Data Analyst Professional Certificate, Coursera
05-2023
Snowflake Hands-on Essentials - Data Warehouse, Snowflake
08-2022

Senior Software Engineer

UNIFYCX
05.2020 - Current

Data Engineer

Infosys Technologies
12.2015 - 05.2020

Bachelor's - Electronics and Communication

Visvesvaraya Technological University
01.2011 - 01.2015

P.G. Diploma - Computer Applications

Fortune Institute of Technology
01.2010 - 01.2011

Similar Profiles

CREATE PROFILE
Sona BhandaryData Engineer