MUST HAVEs
Basic SQL
- Select, Filter (WHERE), group Joins
- Aggregate, Qualify, Roll-up and Drill-down
- SQl to extract report by joining facts and dimension data
Advance SQL
- Query Otimisation
- stored procedures,
- user-defined functions
- window functions for complex data manipulation
- Row_number, Rank,. Dense_Rank
- LEAD, LAG
Snowflake features
- Snowflake Architecture
- Cloud Computing and Infrastructure (cloud platforms like AWS, Azure, and GCP, where Snowflake can be deployed.)
- Data Modeling
- Database Security and Access Control
- Metadata Management
- Time-travel
- Zero copy cloning
- Data Pipeline Automation Snowpipe
GOOD TO HAVEs:
Python programming and scripting
Tableau reporting understanding

Keyskills: Snowflake Advance Sql Basic Sql Python
\n\nMavlers is a full-service digital marketing agency that has propelled growth for over 7,000 brands and agencies worldwide. As Google, Mailchimp, WP VIP, Microsoft, Salesforce, and HubSpot partners, we possess the expertise to deliver high-impact projects and campaigns tailored to our clients uni...