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
About ALOIS (): We at Alois are a high-performance and focused staffing firm that is committed to producing results for our clients, candidates and employees. We are serving fortune 500 and Mid-Size Clients with high quality IT professionals to meet talent needs through staffing, permanent plac...