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.
Domande di colloquio [1]
Domanda 1
What is the maximum storage size for an S3 bucket?
What is the timeout limit for a Lambda function
Ho presentato la mia candidatura tramite un'altra fonte. Ho sostenuto un colloquio presso Deloitte (Poona) nel mese di mar 2026
Colloquio
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.
Domande di colloquio [1]
Domanda 1
Redshift architecture, comparison with Snowflake, Snowpipe
Program to load data from Redshift to S3, transformations and back to Redshift
Ho presentato la mia candidatura tramite segnalazione di un dipendente. La procedura ha richiesto 3 settimane. Ho sostenuto un colloquio presso Deloitte nel mese di gen 2025
Colloquio
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
