Job description
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
Location: Hyderabad, BBSR, Pune, Bangalore, Noida

Tata Consultancy Services is an Indian multinational information technology services and consulting company headquartered in Mumbai, Maharashtra, India with its largest campus located in Chennai, Tamil Nadu, India. As of February 2021, TCS is the largest IT services company in the world by market ca...