Soorya Mithra
Senior Snowflake Developer
Salem
Summary
Senior Data Engineer with total 6.5 years experience. Skilled in Snowflake development (4 years of experience in Snowflake Data Engineering, SnowSQL ETL concepts, Oracle PL/SQL, and AWS S3 integrations. Specialized in building scalable data pipelines, Snowpipe automation, Streams & Tasks orchestration, secure data sharing, and performance-tuned SQL solutions. Proven ability to design, optimize, and support high-availability data platforms and cloud migration projects.
Overview
16
16
years of professional experience
Work History
SQL Developer – Banking Domain
HCL Technologies Limited
Chennai
- Executed SQL tuning, production issue troubleshooting, and cross-team defect resolution.
- Expert in SQL development for banking applications and data management.
- Designed complex queries to support financial reporting and analysis.
Senior Snowflake Developer
AP Softwares
Chitradurga, Karnataka
10.2019 - 03.2026
- Contributed to customer analytics platform development, migrating to Snowflake cloud data warehouse for investment banking operations with improved data accessibility and reporting efficiency.
- Designed star schema data models with multiple fact and dimension tables, implementing slowly changing dimensions to track historical data and meet compliance reporting needs.
- Developed data transformation processes using Snowpark Python for banking operations, contributing to improved data processing efficiency and validation accuracy, and downstream reporting reliability.
- Built end-to-end data pipelines using Snowpipe/AWS S3 for transaction data ingestion and Power BI integration, supporting real-time banking operations and business reporting with optimized refresh schedules.
- Optimized Snowflake performance through query tuning and clustering strategies, contributing to enhanced system efficiency and reduced processing costs.
Associate Software Engineer
HCL Technologies Limited
Chennai
07.2010 - 01.2013
- Performed database improvement, Incident & problem management, partitioning, plan analysis, and workflows.
- Monitor system performance and maintained operational documentation, including runbooks and standard operating procedures, and respond to alerts/issues.
Education
B.E - Electronics & Communication
Easwari Engineering College
Chennai, India01-2009
School - Sacred Heart Convent
Yercaud, India 04.2001 -
Skills
Snowflake database management
Proficient in AWS S3, SQS, and IAM
Snowpipe & Real-Time Ingestion
Software development tools: JIRA, confluence
Attention to detail
Project coordination
Analytical thinking
Critical thinking
Written communication
Time management
Timeline
Senior Snowflake Developer
AP Softwares
10.2019 - 03.2026
Associate Software Engineer
HCL Technologies Limited
07.2010 - 01.2013
School - Sacred Heart Convent
04.2001 -
SQL Developer – Banking Domain
HCL Technologies Limited
B.E - Electronics & Communication
Easwari Engineering College