#etl

Questions tagged etl · medium

All easy (50+)medium (10+)hard (60+)

How would you read data from a web API? What steps would you follow after reading the data?

General/Othermediumetlpartition0.7 min read

AltimetrikInfosys

→

What is normalization and denormalization? When would you use each?

SQLmediumetljoin0.4 min read

PresidioSwiggy

→

Describe Amazon Athena and how it interacts with S3.

Cloud/Toolsmedium

Explain using AWS Glue for ETL. What challenges might you face with large datasets?

Cloud/Toolsmedium

Lambda vs. Glue: Discuss use cases for both services.

Cloud/Toolsmedium

Reverse operation for splitting values back to original format

General/Othermedium

Compare OLTP and OLAP systems in the context of financial transactions.

SQLmedium

How would you handle duplicate or corrupted data in a batch ETL job?

SQLmedium

How would you prevent small file problems in S3 when loading data into Redshift?

SQLmedium

Write a query to identify unique user sessions.

SQLmedium

+8 More Questions with Expert Answers

Unlock all 1,800+ expert answers, AI mock interviews, resume analyzer, SQL playground, and personalized progress tracking.

Unlock Full Access Try AI Coach Free

Other Tags

#join #partition #python #spark #optimization #sql #window #airflow #bigquery #snowflake #lakehouse

#etl

Questions tagged etl · medium

All easy (50+)medium (10+)hard (60+)

How would you read data from a web API? What steps would you follow after reading the data?

General/Othermediumetlpartition0.7 min read

AltimetrikInfosys

→

What is normalization and denormalization? When would you use each?

SQLmediumetljoin0.4 min read

PresidioSwiggy

→

Describe Amazon Athena and how it interacts with S3.

Cloud/Toolsmedium

Explain using AWS Glue for ETL. What challenges might you face with large datasets?

Cloud/Toolsmedium

Lambda vs. Glue: Discuss use cases for both services.

Cloud/Toolsmedium

Reverse operation for splitting values back to original format

General/Othermedium

Compare OLTP and OLAP systems in the context of financial transactions.

SQLmedium

How would you handle duplicate or corrupted data in a batch ETL job?

SQLmedium

How would you prevent small file problems in S3 when loading data into Redshift?

SQLmedium

Write a query to identify unique user sessions.

SQLmedium

+8 More Questions with Expert Answers

Unlock all 1,800+ expert answers, AI mock interviews, resume analyzer, SQL playground, and personalized progress tracking.

Unlock Full Access Try AI Coach Free

Other Tags

#join #partition #python #spark #optimization #sql #window #airflow #bigquery #snowflake #lakehouse