Ho sostenuto un colloquio presso Cargill (Geneva, Geneva)
Colloquio
Generally 3-4 rounds. First round is HR screen (1 hr) to understand interests, past work, salary expectations. Second round is with Engineering managers to know about the role and your pay experience and tech stack. Third is a 1 hour technical and behavioural round to know your past experience with snowflake and AWS followed by two small SQL questions.
Domande di colloquio [1]
Domanda 1
When do you spin up additional clusters for snowflake? When do you use AWS Glue and Kinesis Kafka? How do u optimize PySpark code or diagnose slow jobs? What is difference between Hadoop/Hive and Snowflake?
Given three relational SQL tables, provide the SQL code to find the user with the highest X amount of something. Follow up question is using Window Functions but cal also solve with CTEs.
Ho sostenuto un colloquio presso Cargill (Bengaluru)
Colloquio
Third party/Vendor call for intial details > HR screening round with more on background details > Tech Level 1 round (coding)> Tech Level 2 round > Manager round ( Techincal and behavioral)> HR round
Domande di colloquio [1]
Domanda 1
There is car table (brand, model,version,year of manufacturing,performace catogery) ,in a file( csv) there is details of performace of each brand in a given year .Find out 3 top performing car in a given year