ANZ Banking Group Data Engineer Interview Questions and Answers

Q1. What are the windows functions in sql
Ans. 
Window functions in SQL are used to perform calculations across a set of rows that are related to the current row.
• Window functions are used to calculate running totals, moving averages, and rank values.

• They are applied to a set of rows defined by an OVER clause.

• Examples of window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE.
Answered by AI
Add your answer
Q2. Explain CTE in detail
Ans. 
CTE stands for Common Table Expression, a temporary named result set that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.
• CTE is defined using the WITH keyword followed by a name and a SELECT statement.

• It can be used to simplify complex queries, improve readability, and reduce code duplication.

• CTE can also be recursive, allowing for hierarchical queries.

• Example: WITH sales AS (SELECT * FROM order...read more
Answered by AI
Add your answer

Q1. What is your expected salary
Add your answer

Q1. 1. Introduction
Add your answer
Q2. 2. Project description
Ans. 
Developed a predictive model to forecast sales based on historical data
• Used machine learning algorithms to analyze sales trends

• Incorporated external factors like seasonality and promotions into the model

• Validated the model using cross-validation techniques
Answered by AI
View 1 more answer
Q3. Basics for spark and scala
Add your answer

Python, sql was asked

Q1. Basic Machine Learning Question
Add your answer
Q2. Ask about Previous work or project
Add your answer

Q1. Questions on pyspark coding, windowing function and all
Add your answer
Q2. Questions on hive and yarn
Add your answer