Ganapathyraman R

Domain: Investment Banking

Client: BNY Mellon

Role: Snowflake developer

Tools: Snowflake, Informatics-IICS, ORACLE

Roles and Resposibilities

• Created a Snowflake database, organized it into schemas, and established tables to align with business requirements
• Designed, developed and maintained high performance snowflake database and datawarehouse in data processing efficiency
• Used the COPY command to efficiently transfer large amounts of data from an external stage on AWS S3 to the table on Snowflake
• Skilled in handling roles and migrating structured data in Snowflake, which involves configuring data staging areas, using the COPY command for data loading, and executing required transformations
• Implemented Snowpipe to continuously import data from AWS S3 into Snowflake DB, enabling smooth and continuous data integration between Oracle and Snowflake databases
• Developed Snow Tasks to create a reliable backup mechanism for Snow Stream data, safeguarding against data loss during DML operations within the Snowflake database
• Configured an external table to access and retrieve data from files when direct access in AWS S3 is restricted
• Designed and implemented procedures, functions, and user-defined table functions in Snowflake to enhance and simplify data validation processes
• Applied Snowflake's cloning capability to back up tables and took advantage of its time travel feature to quickly access and restore historical data
• Participated in daily Scrum meetings to provide updates on ongoing activities and project progress

Domain: Investment Banking

Client: Fiserv

Role: Snowflake developer

Tools: Snowflake, IICs, AWS S3, ORACLE

Roles and Responsibilities

• Familiarity with data migration strategies to snowflake from other databases or Datawarehouse and knowledge of ETL processes and IICS tool to integrate with snowflake .
• Fine-tuned Snowflake schemas, tables, and views to significantly enhance the performance of data retrieval and reporting processes.
• Develop database elements including Snowflake tables, file formats, sequences, and internal and external stages.
• Utilized secure views and materialized views to effectively provide data to partner applications, fulfilling their specific data requests and ensuring secure and efficient data access.
• Participated in the development of Snowpipes to connect and integrate AWS cloud data into Snowflake.
• Demonstrated expertise in building and optimizing data solutions within Snowflake.
• Created unique primary keys utilizing sequences. Proficient in SQL and SnowSQL for data manipulation, querying, and performance optimization in Snowflake.
• Assisted in designing Snowstream for data auditing and backup purposes.