SAM CHINNARAJAN
Chennai
Summary
Data Warehousing professional with 3+ years of experience in SQL programming and development. Expertise in automating data workflows, enhancing data transformation processes, and optimizing data loading. Proficient in configuring Snow pipe for seamless integration between AWS cloud and Snowflake DB. Utilized Snowflake utilities, including Snow pipe, for efficient data processing and management. Skilled in solving complex data problems through analytical thinking and implementing effective solutions. Demonstrated proficiency in leveraging Snowflake's native support for semi-structured data formats like JSON. Collaborated effectively within Agile delivery processes, contributing to iterative and incremental development cycles.
Overview
3
3
years of professional experience
Work History
Snowflake Developer
Fineline India Id Solutions
03.2023 - 10.2024
- Utilized advanced skills to create and optimize intricate SQL queries, enabling powerful data analysis and guiding strategic business decisions effectively
- Managed the smooth transfer of data from Oracle Database to Snowflake, utilizing flat files and refining application migration workflows
- Built and optimized data models using Star Schema and Snowflake Schema to enhance the analytical capabilities of the data warehouse
- Implemented Snowflake Streams and Tasks to automate incremental data loads, significantly reducing manual effort and increasing system efficiency
- Worked closely with the business intelligence team to integrate Snowflake with Tableau and Power BI, enabling real-time data visualization and reporting
- Conducted regular performance tuning of SQL queries, stored procedures, and tasks, achieving a 30% improvement in query execution time
- Assumed responsibility for the development of Snowflake procedures, functions, and User Defined Table Functions (UDTF), automating operations and improving capabilities for streamlined data manipulation
Snowflake Developer
Accenture
04.2022 - 01.2023
- Contributed to the migration of database objects from Oracle to Snowflake, ensuring accuracy and efficiency throughout the process
- Worked with AWS admin to setup the IAM (Identity and Access Management) Roles and Policies for the project to access specific bucket
- Worked on create AWS S3 LifeCycle Management on the objects in buckets
- Developed cost-efficient Snowflake storage integrations, along with named stages and procedures to execute COPY INTO commands, and automated the process using scheduled tasks
- Experience in Loading CSV files, parsing semi structured data like JSON & Parquet, receiving from third party vendors
- Skilled in creating and executing Snowflake stored procedures and user-defined functions for deploying code to higher environments
Associate Data Engineer
CSS CORP
09.2021 - 03.2022
- Contributed to the migration of database objects from Oracle to Snowflake, ensuring accuracy and efficiency throughout the process.
- Worked with AWS admin to setup the IAM (Identity and Access Management) Roles and Policies for the project to access specific bucket.
- Worked on create AWS S3 Life Cycle Management on the objects in buckets.
- Developed cost-efficient Snowflake storage integrations, along with named stages and procedures to execute COPY INTO commands, and automated the process using scheduled tasks.
- Experience in Loading CSV files, parsing semi structured data like JSON & Parquet, receiving from third party vendors.
Skills
- Snowflake DB
- AWS S3
- ETL Concepts
- Oracle SQL
- Snow SQL
Tools
- JENKINS
- IICS
- JIRA
- GITHUB DESKTOP
Languages
English
Advanced (C1)
Tamil
Upper intermediate (B2)
Declaration
I hereby declare that all the above statements are true to the Best of my knowledge.
Timeline
Snowflake Developer
Fineline India Id Solutions
03.2023 - 10.2024
Snowflake Developer
Accenture
04.2022 - 01.2023
Associate Data Engineer
CSS CORP
09.2021 - 03.2022
Similar Profiles
Abe GestetnerAbe Gestetner
Sales Development Manager at ID Tech SolutionsSales Development Manager at ID Tech Solutions
Rajan BhargavaRajan Bhargava
Deputy Manager of Finance at Perfect ID India Private LimitedDeputy Manager of Finance at Perfect ID India Private Limited
VISHNU KUMARVISHNU KUMAR
Executive Finance at ID Fresh Food India Pvt LtdExecutive Finance at ID Fresh Food India Pvt Ltd