Nivedita K

5+ years of overall experience in the IT industry with strong expertise in Data Warehousing and Database Development. 4+ years of hands-on experience in Snowflake, specializing in cloud data warehousing, data integration, and ETL processes. Designed and implemented scalable Snowflake data models optimized for analytics and business intelligence reporting. Developed modular and reusable DBT models following data warehousing best practices.

Implemented DBT unit testing, documentation, and CI/CD pipelines using Git, ensuring automated and production-ready deployments. Built automated data ingestion pipelines using Snowpipe, Streams, and Tasks for near real-time data processing. Delivered significant performance improvements using Clustering Keys, Micro-partitioning, Caching, and SQL performance tuning on large datasets.

Leveraged Time

Travel, Zero-Copy Cloning, and Materialized Views for versioning, faster analytics, and environment management.

Integrated

Snowflake with AWS S3 using External Stages and automated data loading frameworks. Implemented strong security controls including RBAC, Row-Level Security (RLS), and Dynamic Data Masking to protect sensitive data. Hands-on exposure to Snowpark (Python) for building scalable data transformation pipelines within Snowflake.

Worked in Agile/Scrum methodology, contributing to sprint planning, backlog grooming, and incremental delivery. Translated complex business requirements into scalable, high-performance, and secure data solutions.

Snowflake Developer at VSM Infotech Pvt ltd (2024-02 – 2026-05)

• Performed bulk data loading from both external stages (AWS S3) and internal stages into Snowflake using the COPY INTO command.
• Utilized Snow SQL to manage data loads and automate ingestion from internal stages into Snowflake tables.
• Developed and scheduled Apache Airflow DAGs to automate and monitor data ingestion and transformation workflows from AWS S3 to Snowflake.
• Implemented Snowpipe to enable real-time, continuous data ingestion from AWS S3, automating the loading process with event-based triggers.
• Created and managed Snowflake Streams on base tables to track changes and maintain backup during DML operations.
• Developed Snowflake stored procedures using JavaScript to handle looping, branching, and conditional logic for advanced transformations.
• Applied FLATTEN table function to normalize and extract elements from semi-structured data (e.g., VARIANT, ARRAY, OBJECT).
• Leveraged zero-copy cloning to clone schemas and tables for testing, code validation, and parallel development without affecting production.
• Integrated CI/CD pipelines using dbt Cloud and GitHub Actions to automate deployment of dbt models into Snowflake, ensuring version control and seamless collaboration across environments.
• Built and tested modular, version-controlled data models using dbt, enabling transformation as code and ensuring model lineage and testability.

Snowflake Developer at VSM Infotech (2022-04 – 2023-12)

ATOM Bank Project

• Designed scalable Snowflake data models and optimized query performance using clustering keys, micro-partitions, and materialized views.
• Automated real-time and batch data pipelines using Snowpipe, Streams, Tasks, and external/cloud stages.
• Developed DBT staging, intermediate, and mart models with modular design, documentation, and reusable macros.
• Implemented DBT unit testing and CI/CD integration with Git for reliable and production-ready deployments.
• Created stored procedures, views, and complex SQL transformations to support analytics and reporting.
• Ensured strong data security and governance using RBAC, Row-Level Security, and Dynamic Data Masking in Snowflake.

Application Engineer at VSM Infotech (2021-02 – 2022-03)

UBS Group Project

• Developed and maintained efficient SQL and PL/SQL programs to support large-scale data processing, transformation, and reporting requirements.
• Designed and implemented robust Oracle database solutions, ensuring performance, scalability, and data consistency.
• Tuned SQL queries and PL/SQL procedures to improve performance, reduce execution time, and optimize resource utilization.
• Created PL/SQL procedures, functions, and packages to automate recurring processes and streamline overall data operations.
• Built and optimized scripts for data validation, reconciliation, and integrity checks, ensuring clean and accurate data across systems.
• Developed complex PL/SQL logic to implement business rules, support reporting needs, and perform data transformations.
• Created and maintained triggers, views, and materialized views to support automation, enforce data integrity, and improve system responsiveness.
• Managed large datasets effectively using PL/SQL, enhancing data retrieval and processing for analytical and operational requirements.
• Collaborated with cross-functional teams to understand requirements, design solutions, and deliver high-quality database components.
• Participated in code reviews, unit testing, and performance tuning to ensure maintainability and reliability of database code.

Bachelor of Science in BSc – Karnataka University Dharwad (2015 – 2018)