L1l2 rounds 1 rounds asked about GCP Big Query Partition clustering and How do u handle large data For Backup In Coldline and Nearline storage with code and GCP Console code to tranfer big file with backup options

It was smooth, Got a call for first round, started with intro and project I've worked on, as it was technical focused more on pyspark and sql. Data Engineering principles and processes.

The interview was all based upon python, spark and sql. Questions were easy to moderate level. Mostly from python and sql. Questions like : a table consists of some positive and some negative integers. Write a query to create a new table and to separate positive integers in positive _numbers column and negative integers in negative_numbers column