KABILAN K

Experienced Snowflake Developer with six years of hands-on experience in designing, developing, and maintaining data solutions. Skilled in Snowflake architecture, ETL processes, data modeling, and optimization strategies, seeking opportunities to contribute to innovative data projects.

CURRENT PROJECT
Domain : BFSI
Role : Snowflake developer
Client : KCB Bank
Environment : Oracle, AWS S3, Snowflake DB

ROLES AND RESPONSILIBITIES 

• Experience in Snowflakes Object Development such as warehouses, Schemas, Database, Tables, Views, Pipes, Stages.
• Have hands on Experience on Loading Unstructured data on minimal load using VARIANT Datatype, Flatten, Parquet, etc.
• Created External table to access the data from the files, when the file access is denied in AWS S3.
• Monitoring Snowflake usage, resource utilization, and query performance to identify issues, optimize workloads, and ensure smooth operation.
• Data Migration from Oracle Database to Snowflakes using Flat files for application Migration from Oracle DB to Snowflake.
• Transforming raw data into a usable format for analysis and reporting, including data cleansing, aggregation, enrichment, and applying business rules to ensure data quality and consistency.

PREVIOUS PROJECT
Domain : BFSI
Role : Snowflake developer
Client : Saudi Arab Bank
Environment : Oracle, AWS S3, Snowflake DB

ROLES AND RESPONSILIBITIES 

• Designed and implemented ETL processes using Snowflake features such as Snowpipe, tasks, and streams to ingest and process data from various sources.
• Converted the business need into technical complex SQL queries and subqueries using analytical functions, joins, operators.
• Created Snow Pipe to read the data from the AWS S3 ,AZURE and loaded the data to Snowflake DB to ensure the continuous data integration between the oracle and snowflake DB.
• Optimize query and performance tuning using indexing, partitioning, tracing query, collections in oracle PLSQL.
• Created snow tasks as task tree to read the data from the snow stream objects which are created on the base table, to maintain the backup of data
  while happening DML operation in the target snowflake DB.
  
  

I hereby declare that the above-mentioned information is correct to my knowledge, and I bear the responsibility for the correctness of the above-mentioned particulars.

Yours Sincerely,

Kabilan.K