Pradeesh Amasa
Bangalore
Summary
Dynamic Technical Consultant with a proven track record at Ascendion Engineering, excelling in Snowflake data solutions and complex SQL queries. Adept at optimizing data pipelines and enhancing performance, I bring strong analytical skills and a passion for innovation to drive impactful results in cloud data warehousing.
Overview
3
3
years of professional experience
Work History
Technical Consultant
Ascendion Engineering Pvt Ltd
Bangalore
11.2023 - Current
- Designed and developed Snowflake objects including databases, schemas, tables, stages, sequences, views, file formats, and stored procedures using SnowSQL and the Snowflake Web UI.
- Loaded data from external stages (Amazon S3) into target Snowflake tables using the COPY command, and queried data warehouse layers for analytics and reporting.
- Demonstrated expertise in writing complex SQL queries, including advanced subqueries, multi-table JOINs, and optimized views for performance and maintainability.
- Performed schema and object cloning from QA to Production environments using Snowflake’s Zero-Copy Cloning to support seamless deployments.
- Utilized core Snowflake features such as Time Travel, Data Cloning, Secure Views, Data Sharing, and Clustering Keys to build efficient, secure, and scalable data solutions.
- Developed SnowSQL scripts to automate the data loading process from flat files into Snowflake tables.
- Implemented Slowly Changing Dimensions (SCD) using Snowflake Streams, Snowpipe, and other Snowflake-native utilities for near real-time data processing.
- Optimized storage usage by leveraging transient tables and defining effective clustering columns to improve query performance and reduce costs.
- Ensured zero-defect deployments and timely delivery of all components through rigorous testing, peer reviews, and adherence to best practices.
- Documented all deliverables, workflows, and deployment procedures to support smooth transition and maintenance by the Production Support team.
Software Engineer
SanVan Technologies Pvt Ltd
Bangalore
11.2022 - 11.2023
- Designed and implemented Snowflake data pipelines for automated data ingestion from AWS S3 into Snowflake tables using external stages and COPY commands.
- Developed and maintained multiple layers in the Enterprise Data Warehouse (EDW), including Landing, Staging, and Downstream layers.
- Extracted data from upstream sources such as file systems and Oracle databases, and loaded it into Snowflake for processing.
- Performed data transformation, cleaning (removal of nulls and duplicates), and quality checks before loading into the Staging layer.
- Managed Snowflake infrastructure components such as virtual warehouses, roles, schemas, databases, and resource monitors.
- Implemented Delta Loads for continuous data transfer from the Staging layer to the Operational Data Store (ODS) layer.
- Created and managed file formats, external stages, and Snowpipe configurations for real-time data ingestion.
- Developed complex SQL and PL/SQL scripts, including stored procedures, to handle Insert, Update, and Delete (Merge) operations.
- Utilized SFTP-based file systems for secure data exchange using IBM DataStage.
- Executed data cleaning and manipulation tasks by writing optimized and complex SQL queries.
- Worked with advanced Snowflake features such as Zero-Copy Cloning, Time Travel, and Fail-Safe for robust data management.
- Actively collaborated with clients to gather, baseline, and analyze requirements, including assessing impacts on downstream applications.
- Designed and implemented ETL logic involving data transformation and integration using complex joins across multiple source tables.
- Supported the QA team by preparing accurate and representative test data sets.
- Developed detailed test plans, test cases, and test scripts based on business requirements, functional specifications, and user stories.
- Conducted various levels of testing including regression, user acceptance testing (UAT), and performance testing to ensure system quality and reliability in telecom environments.
Software Engineer
Harman Connected Services
Bangalore
01.2022 - 09.2022
- Led end-to-end data migration from traditional RDBMS to Snowflake Cloud Data Warehouse, ensuring seamless transition and performance optimization.
- Performed bulk data loading from AWS S3 external stages to Snowflake internal stages using the COPY command for efficient ingestion of large datasets.
- Developed views and materialized views to support business analytics and reporting, enhancing data accessibility and insights.
- Designed and implemented ETL workflows for large-scale Snowflake data warehouse environments, ensuring high performance, accuracy, and scalability.
- Administered and supported the full lifecycle of ETL processes, from development and deployment to production support, across various Snowflake projects.
- Built automated task flows to orchestrate data loading and unloading between Snowflake and AWS S3, improving process reliability and reducing manual intervention.
- Created and managed internal and external stages, applying transformations during data load to ensure clean and structured data ingestion.
- Developed and maintained Snowflake objects such as file formats, user-defined functions (UDFs), and secure views for robust data management.
- Utilized Zero-Copy Cloning to create Dev and QA environments from production data, enabling rapid testing and minimizing storage usage.
- Implemented Snowflake Streams and Change Data Capture (CDC) mechanisms to efficiently process incremental data and maintain real-time data freshness.· Worked on Snowflake streams to process incremental records and for CDC.
Education
Bachelor of Civil Engineering - Civil Engineering
Vemu Institute Of Technology
P.Kothakota, Chittoor05-2020
Skills
- SQL
- Python
- Microsoft SQL Server
- Snowflake
- Oracle
- AWS IAM
- S3
- Athena
- RDS
- EC2
- Matillion
- AZURE DATA FACTORY
- Dbt
- Airflow
- Control M
Languages
Telugu
First Language
English
Advanced (C1)
C1
Hindi
Advanced (C1)
C1
Kannada
Upper Intermediate (B2)
B2
Personal Data
- Full Name: Pradeesh Amasa
- Father’s Name: A. Radhakrishnaiah
- Date of Birth: 20/08/1998
- Gender: Male
- Nationality: Indian
- Languages Known: English, Telugu, Hindi, Kannada
- Marital Status: Single
Decleration
I hereby declare that the above-mentioned information is true and correct to the best of my knowledge and belief. I take full responsibility for the accuracy of the particulars provided in this resume.
.
Place:
Date:
Signature:
Name:
Timeline
Technical Consultant
Ascendion Engineering Pvt Ltd
11.2023 - Current
Software Engineer
SanVan Technologies Pvt Ltd
11.2022 - 11.2023
Software Engineer
Harman Connected Services
01.2022 - 09.2022
Bachelor of Civil Engineering - Civil Engineering
Vemu Institute Of Technology
Similar Profiles
Aftab KhanAftab Khan
Financial Analyst at Ascendion Engineering Pvt Ltd.Financial Analyst at Ascendion Engineering Pvt Ltd.
Swathi MurthySwathi Murthy
Associate Manager - Talent Aquisition at Ascendion Engineering Pvt LtdAssociate Manager - Talent Aquisition at Ascendion Engineering Pvt Ltd
Prashanth KumbamPrashanth Kumbam
Senior Quality Analyst at Ascendion Engineering Pvt LtdSenior Quality Analyst at Ascendion Engineering Pvt Ltd
Sowmya V BalasubramaniamSowmya V Balasubramaniam
Recruitment Manager at IBM India Private LimitedRecruitment Manager at IBM India Private Limited
Bharath Kumar SBharath Kumar S
Manager, Client Support Engineer at EpsilonManager, Client Support Engineer at Epsilon