ANZ Operations & Technology Interview Questions and Answers

Asked questions on arrays

Q1. Questions on databases
Add your answer
Q2. Questions on data structures
Add your answer
Q3. Questions on sql
Add your answer
Q4. Questions on projects
Add your answer
Q5. Questions on java
Add your answer

Q1. Day to day activities in business operations
Add your answer
Q2. Highlighting the need to work extra hour's
Add your answer

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
Add your answer

They asked about the sas,sql,and power bi

Hacker rank test - had to complete 2 python coding problems in an hour.

Q1. Tell me about yourself
Ans. 
I am a dedicated Security Engineer with a strong background in network security and threat analysis.
• Experienced in implementing and maintaining security measures to protect networks and systems

• Skilled in conducting security assessments and identifying vulnerabilities

• Proficient in incident response and forensic analysis

• Familiar with security tools such as SIEM, IDS/IPS, and endpoint protection solutions
Answered by AI
Add your answer
Q2. Tell me about past projects.
Ans. 
Developed a network security system for a large financial institution.
• Implemented firewalls, intrusion detection systems, and encryption protocols to protect sensitive data

• Conducted regular security audits and penetration testing to identify vulnerabilities

• Collaborated with cross-functional teams to ensure compliance with industry regulations
Answered by AI
Add your answer
Q3. Have you ever been in a situation where you had to deal with a conflict at workplace.
Ans. 
Yes, I have experience dealing with conflicts in the workplace.
• I have encountered conflicts related to project deadlines and resource allocation.

• I have resolved conflicts by facilitating open communication and finding mutually beneficial solutions.

• I have also utilized conflict resolution techniques such as active listening and compromise.

• One example is when team members disagreed on the approach to a project, I organiz...read more
Answered by AI
Add your answer