Rajasekhar

SnowPro+CORE certified professional with over 3.5 years of hands-on experience specializing in Snowflake cloud data warehousing. Possessing a solid foundation of 9 years in data warehousing, excels in ETL design and development, leveraging tools like DBT to create models for various domains such as conversations, segments, and customer analytics. Designed and implemented modular, reusable DBT models to transform raw data into clean, analytics-ready datasets using Snowflake as the warehouse. Developed and maintained DBT macros and Jinja templates to standardize logic across models, improving code reusability and reducing duplication. Implemented DBT tests (unique, not null, relationships, custom SQL) to enforce data quality and integrity across critical data pipelines. Implemented DBT snapshots to track slowly changing dimensions (SCD Type 2) and maintain historical data accuracy. Skilled in implementing dynamic data masking and optimizing SQL queries for performance efficiency. Adept at collaborating with clients and stakeholders to gather business requirements and ensure seamless documentation and deployment processes.

Snowpro core