Experience with SQL test at Atlassian?
Has anyone taken it? Any tips?
I’m well-versed in querying via joins, subqueries, etc but don’t know a lot regarding table creation / data engineering. Wondering what I should brush up on ahead of time.
Discussion · Interview
Has anyone taken it? Any tips?
I’m well-versed in querying via joins, subqueries, etc but don’t know a lot regarding table creation / data engineering. Wondering what I should brush up on ahead of time.
It's essentially designing a few related tables and knowing the ins and our of keys/indexes. Last time I checked all Atlassian interview problems were on Glassdoor.
Follow up if anyone needs info in future. This was for analytics job (non-SWE). Test was basic. Aggregations in select statements, simple joins, a couple sub queries. Nothing on table management or keys. If you regularly query SQL databases you will be fine.
Not certain, haven’t received feedback yet. Few other opportunities in the works. Did you apply to them?