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

I applied via Campus Placement and was interviewed before Jan 2021. There were 2 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 tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Most of the questions were centred around Derivatives and Fixed Income Securities

Interview Preparation Tips

Interview preparation tips for other job seekers - Have a sound knowledge in Financial and Economics oriented topics.

I applied via Referral and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions related to Python, my former organisation, why do you want to shift, questions related to different types of risk

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be on time and well dressed
Communication must be good
Answer questions if you can, if you don’t know just accept you don’t know

I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic accounting questions, knowledge testing of Finance and Financial Statements.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and don't speak lie.

I applied via Campus Placement and was interviewed before Oct 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Have you ever worked in a team and how did you manage conflicts?
  • Ans. Gave an example of an academic group project and explained in detail the conflict or clash of ideas and how we approached towards an agreement
  • Answered Anonymously
  • Q2. Why finance?
  • Ans. Natural skills of analysis and interest towards numbers. Love to deal anything involving money or resource management
  • Answered Anonymously

Interview Preparation Tips

Interview preparation tips for other job seekers - Be natural and your own true self. If your natural skills are inclined towards the requirements, you will be hired or you will know where you have to improve.

I applied via Naukri.com and was interviewed before Oct 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Tell me about yourself
  • Q2. Question realted to final year project
  • Q3. Why Morgan Stanley and what do you know about our company?

Interview Preparation Tips

Interview preparation tips for other job seekers - Read the job description and know the job role as the interview questions are related to it.

I appeared for an interview before Jun 2016.

Interview Preparation Tips

Round: Test
Experience: 30 questions, 30

I applied via Campus Placement

Interview Questionnaire 

1 Question

  • Q1. A question based on probability of maximizing profit

Interview Preparation Tips

Round: Test
Experience: Easy, time was sufficient, Mostly Quantitative Aptitude
Tips: Chill and steam on till the end
Duration: 45 minutes
Total Questions: 15

Round: Puzzle Interview
Experience: Question was simple I forgot to take into account a factor in my equation but was able to correct my answer immediately upon given a hint

Round: HR Interview
Experience: Nothing special routine HR Questions

General Tips: Relax know yourself and your resume back and front
Skill Tips: A programming background helps
Skills: Quantitative Aptitude
Duration: 2
College Name: IIT Madras
Motivation: To get PPO and pursue an MBA abroad also the stipend is not bad
Funny Moments: When he asked me how much I wanted AmEx I told him that I told the Microsoft Interviewer that I would take an offer from AmEx irrespective. This was before I got interviewed for Microsoft.

PS I got offers from both AmEx and Microsoft

Interview Questionnaire 

3 Questions

  • Q1. What are your long term and short term goals?
  • Ans. 

    My short term goal is to gain experience and improve my skills. My long term goal is to become a leader in my field.

    • Short term goal: Gain experience and improve skills

    • Long term goal: Become a leader in the field

    • Examples: Attend workshops, take on challenging projects, seek mentorship

  • Answered by AI
  • Q2. Where do you see yourself after 5-6 years?
  • Ans. 

    In 5-6 years, I see myself as a senior analyst or manager, leading a team and contributing to the growth of the company.

    • Leading a team of analysts or managers

    • Contributing to the growth of the company

    • Continuing to learn and develop new skills

    • Building strong relationships with clients and colleagues

    • Exploring opportunities for professional growth and advancement

  • Answered by AI
  • Q3. Why didn't you choose to do MBA?
  • Ans. 

    I wanted to gain practical experience and develop my skills in the workforce before pursuing further education.

    • I believe that hands-on experience is invaluable in any field

    • I wanted to develop my skills and knowledge in a practical setting

    • I felt that pursuing an MBA immediately after my undergraduate degree would not provide me with the same level of experience and growth

    • I plan to pursue an MBA in the future, once I hav...

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: 20 students were shortlisted on the basis of the resume.

Round: HR Interview
Experience: The interview was a mix of HR and technical interview.

The HR interview was based on simple HR questions – questions about me, my motivations in life. My strengths and weaknesses and work preferences. A major part of my interview focused on questions related to my internship.

In the technical round they asked me questions related to the bank reconciliation statement, effect of various entries on passbook and cashbook and questions related to contra entries.
Tips: My advice is that one should be prepared for any question about their resume. In case you have mentioned any subjects in your resume you should be prepared for the same.

College Name: Lady Shri Ram college

Interview Questionnaire 

6 Questions

  • Q1. Why should the company choose you?
  • Ans. 

    I have the necessary skills, experience, and passion to contribute to the company's growth and success.

    • I have a proven track record of achieving targets and delivering results.

    • I possess strong communication and interpersonal skills, which enable me to work effectively with colleagues and clients.

    • I am a quick learner and adaptable to new technologies and work environments.

    • I am passionate about the industry and committed...

  • Answered by AI
  • Q2. Which political figure do you like?
  • Q3. Which party do you prefer?
  • Ans. 

    I prefer not to disclose my political preference.

    • I believe in keeping my political views private.

    • As an analyst, it is important to remain neutral and unbiased.

    • My personal political preference does not affect my work or analysis.

  • Answered by AI
  • Q4. What is the role of CBI
  • Ans. 

    CBI is the premier investigating agency of India, responsible for investigating high-profile cases.

    • CBI stands for Central Bureau of Investigation

    • It is responsible for investigating cases related to corruption, economic offenses, and special crimes

    • It has the power to investigate cases across state borders

    • CBI is also responsible for maintaining the Interpol wing in India

    • Some high-profile cases investigated by CBI include...

  • Answered by AI
  • Q5. Why are you putting Indian Politics over auditing as you are a commerce student ?
  • Ans. 

    I am interested in both fields and believe that understanding politics is crucial for auditing.

    • Politics and business are intertwined, and understanding the political landscape can help in auditing decisions.

    • As a commerce student, I have learned about the impact of government policies on businesses.

    • In India, politics plays a significant role in shaping the economy and business environment.

    • Having knowledge of political d...

  • Answered by AI
  • Q6. What is your favorite subject?
  • Ans. 

    My favorite subject is history.

    • I love learning about past events and how they shaped the world we live in today.

    • I find it fascinating to study different cultures and civilizations throughout history.

    • I enjoy analyzing historical documents and artifacts to gain a deeper understanding of the past.

    • Some of my favorite topics include ancient Egypt, the Roman Empire, and World War II.

  • Answered by AI

Interview Preparation Tips

Round: Resume Shortlist
Experience: Resume was the key criteria in the selection procedure. All students were asked to submit their resume to the placement cell and on the basis of it 10 students were selected.

Round: HR Interview
Experience: There was no written test and there was directly an interview round. In the interview they inquired about me and my family. They also inquired about my interests to which I replied politics. They were looking for a person who has views about different things happening in the society rather a person who remains in his/her shell.

College Name: Lady Shri Ram College

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 45 salaries
₹13.3 L/yr - ₹38 L/yr
275% 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
167 salaries
unlock blur

₹8.4 L/yr - ₹31.3 L/yr

Analyst
92 salaries
unlock blur

₹2 L/yr - ₹9.5 L/yr

Senior Analyst
84 salaries
unlock blur

₹3.8 L/yr - ₹7.6 L/yr

Software Engineer
58 salaries
unlock blur

₹12.2 L/yr - ₹34.1 L/yr

Data Analyst
45 salaries
unlock blur

₹13.3 L/yr - ₹38 L/yr

Explore more salaries
Compare ANZ Operations & Technology with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

HSBC Group

3.9
Compare

Citicorp

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