Yokesh

Snowflake Data Engineer

Designed and developed ETL/ELT pipelines in Snowflake to process loan origination and servicing data, handling [1.5+ TB/day] of records from core banking systems.. Implemented dbt to structure transformations into staging, intermediate, and mart models, adding tests and documentation to improve data quality and maintainability.. Used dbt models to standardize business logic for the loan domain, reducing duplicate SQL and simplifying downstream reporting for [10+ business teams].. Configured Snowpipe, Streams, and Tasks to automate near-real-time ingestion and CDC from Oracle source systems, cutting manual load effort by [30%].. Led Oracle-to-Snowflake migration and reconciliation for loan and customer datasets, ensuring zero data loss across [15+ tables].. Built dimensional models (fact and dimension tables) for loan disbursement, repayment, and delinquency reporting to support risk and compliance analytics.. Applied RBAC, dynamic masking policies, and resource monitors to enforce data security and cost governance in line with BFSI compliance requirements.. Tuned query performance using clustering keys and materialized views, reducing average report runtime by [25%].. Provided production support and troubleshooting for pipeline failures, maintaining [99%+] SLA adherence for daily loan data loads.