I applied through other source. I interviewed at Deloitte (Pune) in Mar 2026
Interview
There were 2 technical rounds. First one included questions based on SQL, DBMS, Python and PySpark optimizations. Second round was about project related questions, architecture of Redshift, Snowflake, SQL queries, AWS Lambda.
Interview questions [1]
Question 1
Redshift architecture, comparison with Snowflake, Snowpipe
Program to load data from Redshift to S3, transformations and back to Redshift
I was contacted by the recruiter through naukri.com. I gave the first round of the interview. It was mostly around AWS and its services. Apart from that a little bit of Python and SQL.
Interview questions [1]
Question 1
What is the maximum storage size for an S3 bucket?
What is the timeout limit for a Lambda function
I applied through an employee referral. The process took 3 weeks. I interviewed at Deloitte in Jan 2025
Interview
1st Round included an assessment on python, pyspark, SQL and AWS concepts. 2nd round was L1 interview where basic qs on SQL, Pyspark and AWS services were asked. 3rd Round was L2 where AWS services were asked in depth. 4th round was managerial with Associate director