SAI CHARAN PANJA
Sr Analyst/Software Engineer
Hyderabad
Summary
Experienced Snowflake Developer and Data Engineer with 4+ years of experience in designing, developing, and maintaining enterprise data warehouse solutions. Specialized in building scalable data pipelines and cloud-based analytics platforms using Snowflake, dbt, Apache Airflow, Python, SQL, and PySpark.
Hands-on experience working with Amazon Web Services (S3) and Microsoft Azure (Azure Blob Storage) for building modern data platforms. Strong background in data modeling, ETL/ELT pipeline development, data migration, performance optimization, Snowpipe implementation, Streams and Tasks automation, and data governance.
Proven ability to design high-performance Snowflake architectures, implement secure data access using policies, and build business intelligence dashboards using Power BI. Experienced in migrating large-scale enterprise datasets from Oracle and Teradata to Snowflake and optimizing queries for analytical workloads.
Overview
4
4
years of professional experience
Work History
Snowflake developer
Capgemini Technology Services India Limited
06.2024 - Current
- Designed and implemented scalable Snowflake data warehouse architecture to support enterprise reporting and analytics.
- Performed large-scale data migration from Teradata to Snowflake, including schemas, tables, views, stored procedures, and data pipelines.
- Developed robust ETL/ELT pipelines using Snowflake SQL and Python to process and transform large datasets.
- Integrated Snowflake with Azure Blob Storage for efficient data ingestion and processing
- Implemented Snowflake Streams and Tasks for automated incremental data processing.
- Designed optimized data models including fact and dimension tables to support analytical workloads.
- Performed query optimization and performance tuning using clustering techniques and efficient SQL queries.
- Implemented data validation and reconciliation checks to ensure data integrity during migration.
- Monitored Snowflake Virtual Warehouses and optimized compute resource usage to improve query performance.
- Developed documentation and provided training to team members on Snowflake architecture and best practices.
Snowflake developer
Capgemini Technology Services India Limited
03.2023 - 05.2024
- Designed and developed modern data pipelines using Snowflake, dbt, and PySpark for enterprise data transformation.
- Migrated legacy Teradata data warehouse workloads to Snowflake cloud data platform
- Developed reusable dbt models for data transformations and analytical datasets.
- Implemented Apache Airflow DAGs to automate scheduling and monitoring of ETL pipelines.
- Optimized Snowflake queries using query profiling, clustering keys, and efficient SQL transformations.
- Developed Python scripts for data validation, data reconciliation, and automation of ETL processes.
- Implemented secure data access using role-based access control and data governance policies.
- Worked with business teams to translate requirements into data models and reporting datasets.
Snowflake developer
Capgemini Technology Services India Limited
01.2022 - 02.2023
- Developed ETL workflows to ingest data from Oracle databases and Azure Blob Storage into Snowflake.
- Implemented Snowpipe for continuous and automated data ingestion from cloud storage.
- Designed data warehouse schemas and dimensional models for reporting and analytics.
- Built complex SQL transformations for business reporting and data analytics.
- Performed data cleansing, transformation, and validation to ensure high data quality.
- Implemented data quality checks and error handling mechanisms within ETL pipelines.
- Monitored Snowflake workloads and optimized query performance for reporting applications.
Education
Bachelor of Technology - IT
Jawaharlal Nehru Technological University
Hyderabad08-2021
Skills
Databases: SNOWFLAKE, Oracle
ETL Tools: DBT, Informatica
Languages: Python, PySpark, SQL
Clouds: AWS (Amazon S3), Azure (Azure Blob Storage)
Reporting Tool: Power BI
Schedule: Apache Airflow
Timeline
Snowflake developer
Capgemini Technology Services India Limited
06.2024 - Current
Snowflake developer
Capgemini Technology Services India Limited
03.2023 - 05.2024
Snowflake developer
Capgemini Technology Services India Limited
01.2022 - 02.2023
Bachelor of Technology - IT
Jawaharlal Nehru Technological University