Filter interviews by
I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.
Asked questions on arrays
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
They asked about the sas,sql,and power bi
Hacker rank test - had to complete 2 python coding problems in an hour.
ANZ Operations & Technology interview questions for popular designations
I applied via Naukri.com and was interviewed in Oct 2023. There were 2 interview rounds.
ETL pipeline on cloud involves extracting data from various sources, transforming it, and loading it into a cloud-based data warehouse.
Use cloud-based ETL tools like AWS Glue, Google Cloud Dataflow, or Azure Data Factory to extract, transform, and load data.
Design the pipeline to handle large volumes of data efficiently and securely.
Utilize serverless computing and auto-scaling capabilities of cloud platforms to optimi...
Data modelling techniques involve creating a visual representation of data relationships and structures.
Identifying entities and their relationships
Creating entity-relationship diagrams
Normalizing data to reduce redundancy
Using tools like ERwin, Visio, or Lucidchart
Implementing data models in databases
Data Warehouse implementation involves designing, building, and maintaining a centralized repository for storing and analyzing data.
Designing the data warehouse schema to meet business requirements
Extracting, transforming, and loading data from various sources into the warehouse
Implementing data quality processes to ensure accuracy and consistency
Creating data models and reports for analysis and decision-making
Optimizi...
I applied via Walk-in and was interviewed in Jul 2024. There was 1 interview round.
Iq questions for all and group discussion
I applied via Naukri.com and was interviewed before Jul 2023. There were 2 interview rounds.
I applied via campus placement at Bhoj Reddy Engineering College For Women, Hyderabad and was interviewed in Sep 2023. There were 3 interview rounds.
Coding round was really tough , they asked to solve 2 problems one was medium and other was tough
Top trending discussions
The duration of ANZ Operations & Technology interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 19 interviews
Interview experience
based on 229 reviews
Rating in categories
Engineer
167
salaries
| ₹8 L/yr - ₹30.4 L/yr |
Analyst
94
salaries
| ₹3 L/yr - ₹11.4 L/yr |
Senior Analyst
78
salaries
| ₹3.8 L/yr - ₹7.6 L/yr |
Software Engineer
55
salaries
| ₹11 L/yr - ₹32.5 L/yr |
Data Analyst
41
salaries
| ₹10.9 L/yr - ₹38 L/yr |
HSBC Group
JPMorgan Chase & Co.
Barclays Global Service Centre
Standard Chartered