Upload Button Icon Add office photos

ANZ Banking Group

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

ANZ Banking Group Data Engineer Interview Questions and Answers

Updated 19 Dec 2024

ANZ Banking Group Data Engineer Interview Experiences

3 interviews found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 19 Dec 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Load 60 GB of csv file and perform transformation.
  • Ans. 

    Use distributed computing framework like Apache Spark to efficiently load and transform the large CSV file.

    • Use Apache Spark to distribute the workload across multiple nodes for faster processing.

    • Utilize Spark's DataFrame API to read the CSV file and apply transformations.

    • Consider partitioning the data to optimize performance.

    • Use Spark SQL for complex transformations and aggregations.

    • Leverage in-memory processing capabi

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 3 interview rounds.

Round 1 - Case Study 

They gave a regular problem like using sqllite in the code and using it to get data from a csv file and parse it. I was allowed to use google. They wanted to see how I approach a problem.

Round 2 - Technical 

(1 Question)

  • Q1. General questions on work experience, some technical basic questions
Round 3 - Be 

(2 Questions)

  • Q1. Asked a lot of situational questions, seemed satisfied with the answers
  • Q2. Why should we hire you? what was the one time you felt like a failure?

Interview Preparation Tips

Interview preparation tips for other job seekers - They dint get back immediately, but the consultancy informed me that they were looking at other candidates and it was a 50-50 situation with my profile.

Data Engineer Interview Questions Asked at Other Companies

asked in Cisco
Q1. Optimal Strategy for a Coin Game You are playing a coin game with ... read more
asked in Sigmoid
Q2. Next Greater Element Problem Statement You are given an array arr ... read more
asked in Sigmoid
Q3. Problem: Search In Rotated Sorted Array Given a sorted array that ... read more
asked in Cisco
Q4. Covid Vaccination Distribution Problem As the Government ramps up ... read more
asked in LTIMindtree
Q5. 1) If you are given a card with 1-1000 numbers and there are 4 bo ... read more

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 13 Oct 2023

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Sep 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Aptitude Test 

General Aptitude and behaviour test

Round 3 - Coding Test 

Data wrangling and processing using python data structures

Round 4 - Group Discussion 

Presentation test, describe previous work and motivation

Interview questions from similar companies

Interview Questionnaire 

1 Question

  • Q1. Explain about self introduction

I applied via Recruitment Consulltant and was interviewed before Nov 2021. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • 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
  • 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...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. What is your expected salary

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice SQL in detail. Practice scenario based SQL questions. Read all the data warehousing concepts in detail.

Skills evaluated in this interview

I applied via Walk-in and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. About your self

Interview Preparation Tips

Interview preparation tips for other job seekers - please select my profile
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. 1. Introduction
  • 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
  • Q3. Basics for spark and scala

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare your current project thoroughly.
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Not Selected
Round 1 - Coding Test 

Python, sql was asked

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare well for interviews as they go in deep

I applied via Approached by Company and was interviewed in Sep 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all Resume tips
Round 2 - Aptitude Test 
Round 3 - Technical 

(2 Questions)

  • Q1. Basic Machine Learning Question
  • Q2. Ask about Previous work or project

Interview Preparation Tips

Interview preparation tips for other job seekers - Level of aptitude exam is difficult
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Jan 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Questions on pyspark coding, windowing function and all
  • Q2. Questions on hive and yarn

Interview Preparation Tips

Topics to prepare for Axis Bank Data Engineer interview:
  • pyspark
  • hive
  • sql
  • yarn
Contribute & help others!
anonymous
You can choose to be anonymous

ANZ Banking Group Interview FAQs

How many rounds are there in ANZ Banking Group Data Engineer interview?
ANZ Banking Group interview process usually has 2-3 rounds. The most common rounds in the ANZ Banking Group interview process are Technical, Group Discussion and Case Study.
How to prepare for ANZ Banking Group Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at ANZ Banking Group. The most common topics and skills that interviewers at ANZ Banking Group expect are Python, SQL, Data Processing, Teradata and Recruitment.
What are the top questions asked in ANZ Banking Group Data Engineer interview?

Some of the top questions asked at the ANZ Banking Group Data Engineer interview -

  1. Load 60 GB of csv file and perform transformati...read more
  2. Asked a lot of situational questions, seemed satisfied with the answ...read more

Recently Viewed

SALARIES

ANZ Banking Group

INTERVIEWS

Empower Retirement

No Interviews

SALARIES

Empower Retirement

INTERVIEWS

Empower Retirement

20 top interview questions

INTERVIEWS

ANZ Banking Group

30 top interview questions

INTERVIEWS

Abzooba India Infotech

No Interviews

INTERVIEWS

ANZ Banking Group

No Interviews

SALARIES

Step2gen Technologies

INTERVIEWS

Step2gen Technologies

No Interviews

DESIGNATION

Tell us how to improve this page.

ANZ Banking Group Data Engineer Interview Process

based on 3 interviews

Interview experience

4.3
  
Good
View more
ANZ Banking Group Data Engineer Salary
based on 82 salaries
₹9 L/yr - ₹37.8 L/yr
111% more than the average Data Engineer Salary in India
View more details

ANZ Banking Group Data Engineer Reviews and Ratings

based on 6 reviews

3.9/5

Rating in categories

4.0

Skill development

4.2

Work-life balance

3.7

Salary

4.1

Job security

3.9

Company culture

3.4

Promotions

3.9

Work satisfaction

Explore 6 Reviews and Ratings
Senior Analyst
555 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Credit Assessment Officer
527 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Analyst
417 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Credit Assessment Officer
271 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Engineer
167 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ANZ Banking Group with

HDFC Bank

3.9
Compare

ICICI Bank

4.0
Compare

State Bank of India

3.8
Compare

Axis Bank

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview