Data Modeller
TCS
4 - 6 years
Chennai
Posted: 3/15/2025
Job Description
- Advanced SQL
Understand the impact of joins (inner, outer, cross joins)
Understand execution plans, and how to optimize a query
Understand the impact of different types of aggregation. (e.g. distinct counts, semi additive measure, row level calcutions)
- Much of performance troubleshooting that relates to modelling are analyzing the SQL queries that are submitted to the source system
- Strong understanding of OLAP concepts
- Strong understanding of Star/Snowflake schema methodologies
- Strong understanding of BI tools ( this one relates more your own infrastructure. e.g. Excel, Tableau, etc.)
- It would be good t
- o understand how the different tools submit requests
- Intermediate knowledge of MDX
About Company
Tata Consultancy Services (TCS) is one of the largest multinational IT services and consulting companies in the world, headquartered in Mumbai, India. It operates in over 50 countries and is a part of the Tata Group, India's largest business conglomerate. TCS offers a wide range of services including software development, consulting, digital transformation, and business solutions, serving industries such as finance, healthcare, retail, and telecommunications. Known for its global reach, technological expertise, and innovation, TCS is consistently ranked among the top IT services companies globally.
Services you might be interested in
One-Shot Campaign
Reach out to ideal employees in one shot!
The intelligent campaign for reaching out to the ideal audience to whom you can ask for help (guidance or referral).