Yazhini Selvam

Bring to the table a wealth of handson experience, accumulated over a span of approximately 6.5 years in
the domain of Snowflake data warehouse.
Played a vital role in developing Snowpipes to enable seamless data integration between AWS cloud
and Snowflake databases.
Has deep knowledge of building and optimizing data solutions using Snowflake's cloud technology.
Used sequences to ensure the uniqueness of primary key identifiers.
Proficient in using SQL and SnowSQL to efficiently manage and analyze data on the Snowflake
platform.
Assisted in developing Snowstream features for auditing and backing up base table data.
Used cloning to create data backups in Snowflake, enhancing data security and resilience.

• Snowflake DB
• Azure Devops
• DBT
• JIRA
• Git Bash
• Jenkins
• VS Code
• Snowpipe

Current Project
Domain: Manpower
Client: MPG(Manpower Groups)
Environment: Snowflake, SQL server, DBT, Cortex AI
Roles and Responsibilities
Developed and supported a Snowflake-based ingestion framework to load data from source systems into Snowflake.
Leveraged Snowflake Cortex AI to analyze ingested data and validate AI-generated summaries and insights.
Developed and validated dbt models for transforming raw data into business-ready tables.
Tested incremental loading using dbt Incremental materialization.
Validated dbt Snapshots to capture Slowly Changing Dimension (SCD) changes.
Performed source-to-target reconciliation between SQL Server and Snowflake.
Executed data quality validation using dbt generic tests and custom SQL queries.
Collaborated with cross-functional teams to troubleshoot ingestion failures and ensure timely data availability.

Previous Project
Domain: Investment Banking
Client: Nordea bank Abp, Finland
Environment: Snowflake,  AWS S3, SQL developer
Roles and Responsibilities
Proficient in both traditional ETL (Extract, Transform, Load) and modern ELT (Extract, Load, Transform) processes, with a focus on Snowflake’s capabilities such as Snowpipe for real-time data ingestion and Streams for continuous data integration.
Developed a data ingestion framework in Snowflake to handle both batch and real-time data from various file formats, including JSON, Parquet, and CSV.
Proficient in handling roles and migrating structured data in Snowflake, including setting up data staging areas, using the COPY command for loading, and applying transformations.
Implemented Snow Tasks to create a backup mechanism for Snow Stream data, effectively protecting against data loss during DML operations in the Snowflake database.
Built and deployed procedures, functions, and user-defined table functions in Snowflake to improve and automate data validation tasks.
Used Snowflake’s cloning capability to back up tables and took advantage of its time travel feature to quickly retrieve historical data.