Yazhini Selvam

Domain: Investment Banking

Role: Snowflake Developer

Client: Nordea Bank Abp, Finland

Environment: oracle, AWS s3, Snowflake DB

Designed Snowflake data models to accommodate both structured and semi-structured data types.

Directed the migration of data from Oracle and AWS S3 to Snowflake, prioritizing data integrity, consistency, and efficiency.

Created automated processes to extract, transform, and load data into Snowflake using its features and additional tools.

Implementing data pipelines to automate the transfer of data from Oracle, AWS S3, and other sources into Snowflake.

Assess existing data models, schemas, and ETL workflows in Oracle databases and AWS S3 buckets.

Possess hands-on experience with loading unstructured data into Snowflake using VARIANT, Flatten, Parquet, etc. Created external tables to access data from files when S3 access is limited.

Optimize SQL queries, data pipelines, and Snowflake warehouse configurations to enhance performance and reduce resource consumption.

Our project management approach is based on Agile methodologies.

Provided regular updates on daily activities and progress during Scrum meetings.

Domain: Investment Banking

Role: Snowflake Developer

Client: Capital Land, Singapore

Environment: Oracle, AWS s3, Snowflake DB

Utilizes joins, group, and analytical functions to ensure data transformations are correct.

Analyzed record counts to identify data discrepancies between Oracle and Snowflake.

Leveraged analytical functions, joins, and operators to extract relevant information from the database.

Created and maintained test reports, defect lists, and test results to track project progress.

Used SQL to examine application data and develop SQL queries and stored procedures to support quality assurance and analysis of ETL processes.

Identified issues in the testing environment were documented in JIRA along with supporting evidence.