National Australia Bank Data Engineer Interview Questions and Answers for Experienced

Q1. Tell me about your self
Add your answer
Q2. SQL basics
Add your answer
Q3. Banking terms
Add your answer

Basic apt questions. Can easily practice online

Q1. Few hypothetical questions to check your analysis knowledge
Add your answer
Q2. How much flowers were to be accumulated at the end of the day if each person offered 5 flowers a day at the temple.
Ans. 
The total number of flowers accumulated at the end of the day can be calculated by multiplying the number of people by the number of flowers each person offers.
• Multiply the number of people by 5 to get the total number of flowers accumulated

• For example, if there are 10 people, the total number of flowers accumulated would be 10 * 5 = 50
Answered by AI
Add your answer

A coding test is an assessment used to evaluate a candidate's programming skills and problem-solving abilities. It typically involves solving problems using code within a specified time frame, often through platforms like HackerRank or LeetCode. The tests assess language proficiency, coding efficiency, and logical thinking.

An aptitude test is an assessment designed to evaluate a person's ability to perform specific tasks and react to a range of different situations. It measures cognitive abilities, problem-solving skills, logical reasoning, and sometimes specific skill sets relevant to a job or educational setting. These tests are commonly used in hiring processes, educational admissions, and career guidance.

Q1. 1. Introduction
Add your answer
Q2. 2. Project description
Ans. 
Developed a predictive model to forecast sales based on historical data
• Used machine learning algorithms to analyze sales trends

• Incorporated external factors like seasonality and promotions into the model

• Validated the model using cross-validation techniques
Answered by AI
View 1 more answer
Q3. Basics for spark and scala
Add your answer

SQL server

SQL DBA

Q1. Salary discussed, Appts test
Add your answer

An easy coding round was conducted that involved SQL questions.

An easy one-hour discussion based on the resume.

Q1. Base on SQL and tableau
Add your answer
Q2. How join work share in detail with examples
Add your answer
Q3. How to get nth salary
Add your answer
Q4. How to delete duplicates
Ans. 
To delete duplicates, use SQL query with DISTINCT keyword or remove duplicates programmatically in Python using sets.
• Use SQL query with DISTINCT keyword to remove duplicates from a database table

• In Python, remove duplicates from a list using sets: list(set(original_list))

• For pandas DataFrame, drop duplicates using df.drop_duplicates()
Answered by AI
Add your answer

Q1. Live coding on the platform
Add your answer