This is part three of the data engineer interview series. If you have not already, I highly recommend you to read the introduction section of Part one to build an understanding of my career background.

In this blog, I will discuss two questions on each topics Python, Spark, and SQL.

Python

Q. What is polymorphism and how do you implement it in Python?

…

This is part two of the data engineer interview series. If you have not already, I highly recommend you to read the introduction section of Part one to build an understanding of my career background.

In this blog, I will discuss two questions on each topics Python, Spark, and SQL.

Python

Q. What is self in Python?

• …

I am a data engineering with 2.4 Years of experience. During the last 4 months, I have attended 75 interview sessions for the role of data engineering with 26 different companies.

Amazon, ANZ, Apisero, Aviyel, Amagi, Busigence, BCG, BitClass, couture.ai, Fractal, Flipkart, Indeed, Healthplix, Lead School, Lumiq, Moveworks, Nagarro, Novo…

In this blog, we will see examples of how to do a full query of a dynamo DB table. We will also dig into the concepts of applying filters and conditions to obtain only desirable records.

Why?

The question is why do we need to scan the DB if we can…

In this blog, we will see how to extract all the keys of an s3 bucket at the subfolder level and keys with specific extension. Along with this, we will also cover different examples with the boto3 client and resource. …

There is nothing more to understand than looking at the two images below.

SQS is a message queueing service by AWS which accepts messages from one service(say S3) and passes them to another service(AWS lambda in this case). …

In this blog, we will see how to set up an ODBC connection to Redshift Database and use this connection to query the table from PowerBI. …