Sr Data Analyst Interview Questions

2,955 sr data analyst interview questions shared by candidates

Three SQL questions: 1. Query involved window functions (SUM/COUNT), CTE, and date filtering using DATEADD 2. Worked with nested CTEs and GROUP BY. Had a good discussion about choosing LEFT JOIN over INNER JOIN - explained how it helps catch missing or incomplete data 3. Discussion about comparing data between tables using EXCEPT/INTERSECT and checksums Cultural fit: STAR stories about leading a project, requirement gathering etc.
avatar

Sr Data Analyst

Interviewed at Walmart

3.4
Jan 20, 2025

Three SQL questions: 1. Query involved window functions (SUM/COUNT), CTE, and date filtering using DATEADD 2. Worked with nested CTEs and GROUP BY. Had a good discussion about choosing LEFT JOIN over INNER JOIN - explained how it helps catch missing or incomplete data 3. Discussion about comparing data between tables using EXCEPT/INTERSECT and checksums Cultural fit: STAR stories about leading a project, requirement gathering etc.

Viewing 2451 - 2460 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 2,955 interview questions and reports from Sr data analyst interviews. Prepare for your interview. Get hired. Love your job.