I applied through a recruiter. I interviewed at United Airlines (Bengaluru) in Jul 2025
Interview
The recruiter reached out and shared a job description for a Snowflake Administrator position, and the discussions before the interview were aligned with Snowflake responsibilities. However, during the actual interview, the panel mentioned they were looking for a Redshift DBA instead.
The panelists were professional, but the role expectations seemed misaligned with the information shared beforehand. Clearer communication about the exact role requirements would help candidates prepare better and have a more focused interview experience.
Interview questions [1]
Question 1
1. Performance capacity report
2. Lock /block and long running session
3. SQL – Joins, Union
4. Unix commands – shell scripting
5. Redshift security features – IAM ,VPC etc
6. Vaccum , analyze for better query performance
7. Data Share
8. Query Planning (EXPLAIN Plan)
9. Roles and User management
10. Concurrency scaling
11. Indexing
12. DRR – Disatster recovery planning
13. Serverless Amazon