Sivaprakasam R

Data Engineer with over 5 years of experience in Snowflake and AWS, specializing in ETL processes and data pipeline automation. Successfully designed and implemented data pipelines using Snow pipe and Streams, developed scalable Snowflake data models, and integrated Snowflake with AWS S3 for external data ingestion. Proficient in creating stored procedures and handling complex data retrieval tasks. Experienced in collaborating with cross-functional teams to troubleshoot and resolve database issues, ensuring data integrity during migration processes.

Designed and implemented data pipelines using Snow pipe and Streams for real-time data ingestion. Developed scalable Snowflake data models to support analytical reporting. Created stored procedures and scheduled the tasks for data transformation and processing. Integrated snowflake with AWS S3 for external data ingestion and storage. Experience in Snowflakes Object Development such as warehouses, Schemas, Database, Tables, Views, Pipes, Stages, and Scaling Policies Utilization, Roles. Participated in defect meetings with the Project Manager and Development Team, identified gaps and suggested relevant solutions. Developed procedure, functions and exceptions handling mechanisms to handle complex data retrieval, manipulation, checking and migration tasks.

Experienced in designing and optimizing Snowflake data solutions, leveraging strong information technology fundamentals in data engineering, cloud architecture, and SQL development to deliver scalable, high-performance analytics environments.