Upload Button Icon Add office photos

Filter interviews by

ANZ Operations & Technology Data Analyst Interview Questions and Answers

Updated 8 Nov 2024

ANZ Operations & Technology Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image PRITISAGAR SAHU

posted on 8 Nov 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. How you calculate the tdi and mdi of a customer in sql
  • Ans. 

    To calculate TDI and MDI of a customer in SQL, you need to aggregate and analyze the customer's transaction data.

    • Calculate Total Daily Income (TDI) by summing up the income of the customer for each day.

    • Calculate Monthly Daily Income (MDI) by averaging the TDI for each day in a month.

    • Use SQL functions like SUM, AVG, and GROUP BY to perform the calculations.

    • Example: SELECT SUM(income) AS TDI, AVG(income) AS MDI FROM tran

  • Answered by AI
Round 2 - Coding Test 

They asked about the sas,sql,and power bi

Skills evaluated in this interview

Interview questions from similar companies

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

I applied via Campus Placement and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

IT WAS Difficult and i gave up

Round 2 - Technical 

(2 Questions)

  • Q1. Linked list search binary
  • Q2. Array search and traverse
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(3 Questions)

  • Q1. Get the maximum salary of the employee from the employee and department table
  • Q2. Explain the data analysis process that you would follow for employee salary table
  • Ans. 

    The data analysis process for an employee salary table involves data cleaning, exploration, visualization, and modeling.

    • Start by cleaning the data to remove any duplicates, missing values, or outliers.

    • Explore the data by calculating basic statistics like mean, median, and standard deviation.

    • Visualize the data using histograms, box plots, or scatter plots to identify patterns or trends.

    • Perform statistical modeling to an...

  • Answered by AI
  • Q3. Explain the challenges you faced in your project
  • Ans. 

    I faced challenges in managing large datasets and ensuring data accuracy in my project.

    • Managing large volumes of data from multiple sources

    • Ensuring data accuracy and consistency

    • Dealing with missing or incomplete data

    • Handling data cleaning and preprocessing tasks

    • Addressing technical issues with data storage or processing tools

  • Answered by AI
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
-
Result
-

I was interviewed in Sep 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. Load data from hdfs using python
  • Ans. 

    Use PyArrow library to load data from HDFS in Python

    • Install PyArrow library using pip install pyarrow

    • Use pyarrow.hdfs.connect to connect to HDFS

    • Use pyarrow.parquet.read_table to read data from HDFS

  • Answered by AI
  • Q2. Query to find the top three salaried employees of each department
  • Ans. 

    Query to find the top three salaried employees of each department

    • Use a SQL query with a window function like ROW_NUMBER() to rank employees within each department based on salary

    • Partition the data by department and order by salary in descending order

    • Filter the results to only include rows where the row number is less than or equal to 3

  • Answered by AI

Skills evaluated in this interview

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

I applied via Naukri.com and was interviewed in Dec 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Different joins
  • Q2. Case study
Round 2 - Case Study 

Revenue impact for casino

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

English, quant, logical reasoning

Round 2 - Technical 

(2 Questions)

  • Q1. Wacc, coc, beta
  • Q2. Coc, equity, capm
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Technical.purely
Round 2 - One-on-one 

(1 Question)

  • Q1. Purely tech..and then you present a dashboard on power bi
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via campus placement at Indian Institute of Technology (IIT), Jodhpur and was interviewed in Jun 2024. There was 1 interview round.

Round 1 - One-on-one 

(3 Questions)

  • Q1. What is p value?
  • Ans. 

    A p-value is a measure used in statistical hypothesis testing to determine the strength of evidence against the null hypothesis.

    • A p-value is the probability of obtaining results as extreme as the observed results, assuming the null hypothesis is true.

    • A p-value is compared to a significance level (usually 0.05) to determine if the null hypothesis should be rejected.

    • A p-value less than the significance level indicates st

  • Answered by AI
  • Q2. Tell the output a**2
  • Ans. 

    The output of a**2 is the square of the value of a.

    • The output is the value of a multiplied by itself

    • For example, if a = 3, then the output would be 9 (3*3)

  • Answered by AI
  • Q3. Difference between append() and concat
  • Ans. 

    append() adds elements to a single DataFrame, while concat() combines multiple DataFrames.

    • append() is a method used to add rows to a DataFrame.

    • concat() is a function used to combine multiple DataFrames along a particular axis.

    • append() modifies the original DataFrame, while concat() returns a new DataFrame.

    • Example: df1.append(df2) vs pd.concat([df1, df2])

  • Answered by AI
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Question related to SQL.
  • Q2. Concept of Data Warehousing.
  • Ans. 

    Data warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.

    • Data warehousing involves extracting data from multiple sources and consolidating it into a central repository.

    • It is used for analytical reporting, business intelligence, and decision-making purposes.

    • Data warehouses are designed for query and analysis rather than transaction processing.

    • Examples of d...

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Join and window functions
  • Q2. Python questions and puzzles

ANZ Operations & Technology Interview FAQs

How many rounds are there in ANZ Operations & Technology Data Analyst interview?
ANZ Operations & Technology interview process usually has 2 rounds. The most common rounds in the ANZ Operations & Technology interview process are Technical and Coding Test.

Tell us how to improve this page.

ANZ Operations & Technology Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
ANZ Operations & Technology Data Analyst Salary
based on 42 salaries
₹11 L/yr - ₹38 L/yr
293% more than the average Data Analyst Salary in India
View more details

ANZ Operations & Technology Data Analyst Reviews and Ratings

based on 4 reviews

3.5/5

Rating in categories

2.1

Skill development

4.2

Work-life balance

3.5

Salary

3.0

Job security

4.2

Company culture

2.9

Promotions

2.9

Work satisfaction

Explore 4 Reviews and Ratings
Engineer
169 salaries
unlock blur

₹8.1 L/yr - ₹31.2 L/yr

Analyst
90 salaries
unlock blur

₹3 L/yr - ₹13 L/yr

Senior Analyst
84 salaries
unlock blur

₹3.8 L/yr - ₹7.6 L/yr

Software Engineer
55 salaries
unlock blur

₹11 L/yr - ₹32.5 L/yr

Data Engineer
44 salaries
unlock blur

₹8.6 L/yr - ₹35.2 L/yr

Explore more salaries
Compare ANZ Operations & Technology with

HSBC Group

4.0
Compare

JPMorgan Chase & Co.

4.0
Compare

Barclays Global Service Centre

4.0
Compare

Standard Chartered

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