Samba Siva Rao Gandu

• Bulk Data Migrations (Tables,views,streams,Procedures & Functions) from different source environments to Target Databases using snowsql.

• Used COPY, LIST, PUT and GET commands for validating the internal stage files.

• Experience in writing, troubleshooting, optimizing complex SQL, performance tuning and developing stored procedures, Time traveling, Restoring and Cloning data.

• Bulk loading from the external stage (AWS S3), internal stage to snowflake cloud using the COPY command.

• Perform troubleshooting analysis and resolution of critical issues on Snowflake query logging, Critical P3,P2,P1 Incidents , Maintaining (RBAC) privilege's to users and access issues.

• Used SNOW PIPE for continuous data ingestion from the S3 bucket.

• Developed snowflake procedures for executing branching and looping Created clone objects to maintain zero-copy cloning.

• Data validations have been done through information_schema.

• Performed data quality issue analysis using Snow SQL by building analytical warehouses on Snowflake

• Experience with AWS cloud services: EC2, S3, EMR, RDS, Athena, and Glue

• Cloned Production data for code modifications and testing and also through data shares.

• Expertise in identifying and analyzing the business need of the end-users and building the project plan to translate the functional requirements into the technical task that guide the execution of the project.