- In summary, my preference would be a candidate with approximately 4-5 years of experience Base location- Pune, Job type- remote(anywhere in India) who has solid potential for future growth and hands-on experience not only with Microsoft SQL Server, but also with open-source database technologies like MySQL and Python. Also experience with various BI tools.

- Exp. in Microsoft SQL server, MySQL, Python & various BI tools

Can you explain the difference between a JOIN and a UNION in SQL

- JOIN combines columns from different tables horizontally based on a related column. UNION combines rows from different queries vertically into a single result set. The queries in a UNION must have the same number of columns and compatible data types

- Need basic sql skills from their point of view. Mainly reporting job but decent database query skills. They say basic but really mid level data base skills

Difference between a Clustered and a Non-Clustered index in SQL Server

- A Clustered index determines the physical order of data rows in a table (only one allowed per table).



A Non-Clustered index is a separate structure from the data rows that contains pointers to the actual data rows (multiple allowed per table).

Difference between a Fact table and a Dimension table?

- Fact tables contain quantitative data, metrics, or measurements of a business process (e.g., Sales Amount, Quantity Sold). Dimension tables contain descriptive attributes or context about those metrics (e.g., Customer Name, Product Category, Store Location).

Difference between Star Schema and Snowflake Schema?

- : In a Star Schema, dimension tables are normalized and connect directly to the fact table. In a Snowflake Schema, dimension tables are partly or fully normalized into secondary tables, splitting them into a hierarchy that looks like a snowflake.

In Power BI or any reporting tool, what is the difference between Calculated Columns and Measures?

- Calculated Columns are computed row-by-row during data refresh and store data in the model (consuming memory). Measures are calculated on the fly using DAX formulas based on user filters or context during report viewing (consuming CPU, not memory).

📌 SQL - Data Engineer (Pune)
🏢 Teak Staffing
📍 Pune