ANZ Data Engineer interview questions

The best work culture someone could ever find , im glad I joined the company. Nor sure abt Australia, but NZ has best quality of work and employee loves to go to work. If you get offer from anz ,don't think twice.

1. Application Screening What happens: Your resume is reviewed by recruiters or automated systems (ATS). Tip: Tailor your resume with keywords from the job description. 📌 2. Online Assessment / Aptitude Round Format: MCQs or coding questions (via platforms like HackerRank, Codility, etc.). Topics: SQL queries Python logic (data structures, file handling) Basic data modeling Logical reasoning / aptitude 📌 3. Technical Interview (1–2 Rounds) Focus: Core SQL and Python Data pipeline concepts Database design (e.g., normalization, indexing) ETL/ELT concepts Cloud basics (GCP, AWS optional for freshers) Example Question: "Design a simple data pipeline to clean and store sales data." 📌 4. System Design (Optional for Freshers) If included: Simplified scenario-based question like designing a mini data warehouse or streaming pipeline. Expected: Logical thinking, table design, SCD types, data flow discussion. 📌 5. HR/Behavioral Interview Topics: Tell me about yourself. Why data engineering? Teamwork, problem-solving, and learning experiences. Tip: Use the STAR method (Situation, Task, Action, Result) for structured answers. 📌 6. Final Round / Managerial Discussion (Optional) Discussion: Work attitude, career goals, and potential growth. Could include: Light technical questions + project or internship discussion.