UST Data Analyst Interview Questions
The questions to prepare for a UST Data Analyst interview. Questions from real interview reports rank first. Updated weekly.
Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.
USTExplain how PostgreSQL aggregate functions treat NULL values and when to use COALESCE to control results.
USTExplain INNER, LEFT, RIGHT, FULL OUTER, CROSS, and SELF JOINs with examples and when to use each.
USTExplain how to tune a slow PostgreSQL query that joins several large transaction tables using indexes, join strategy, and partitioning.
USTTests your understanding of Power BI modeling concepts and when to use each.
USTIdentify repeated UST QA test executions using a CTE, GROUP BY, HAVING, and a project join.
UST GlobalUSTFind every employee earning the second-highest distinct salary using a CTE, DENSE_RANK, and a department join.
USTTests ownership of an end-to-end analytics project, including cross-functional collaboration, technical judgment, and measurable business impact.
USTTests ability to design rigorous data quality controls for high-stakes financial reporting.
USTTests pipeline design for automation and secure reporting to external stakeholders.
USTSign up to see every question
Create a free account to unlock this list and practice real interview questions.