Experience: 3+ Years
Location: BLR/BBSR/PUNE/Noida/Gurgaon/Hyd/Kochi
Notice Period: Immediate to 90 Days
JD:
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