National Australia Bank Senior Analyst II Interview Questions and Answers for Experienced

General discussion, HR round and Manger Round

Q1. JD related questions
Add your answer
Q2. Technical questions
Add your answer

Q1. Give All Answer in Star Approach.
Add your answer
Q2. If you have conflict with your collogue how you will handle that?
Add your answer

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

Any thing ask me any questions

Q1. What is the meaning of ICICI
Ans. 
ICICI Bank is an Indian multinational banking and financial services company.
• ICICI stands for Industrial Credit and Investment Corporation of India

• It is one of the largest private sector banks in India

• Offers a wide range of banking products and financial services

• Headquartered in Mumbai, Maharashtra, India
Answered by AI
View 2 more amswers
Q2. Who many dranchs of icici
Ans. 
ICICI Bank has over 5,275 branches across India.
• ICICI Bank has a network of over 5,275 branches across India.

• The branches are spread across various cities and towns in the country.

• ICICI Bank also has a significant presence in rural areas through its network of branches.

• The bank continues to expand its branch network to reach more customers.

• Some of the branches also offer specialized services like wealth management and
Answered by AI
Add your answer

Q1. What is the meaning dy hr
Ans. 
DY HR stands for Dynamic Human Resources.
• DY HR refers to a dynamic approach to managing human resources within an organization.

• It involves adapting HR strategies and practices to meet the changing needs of the business and its employees.

• Examples include implementing flexible work arrangements, continuous performance feedback, and personalized development plans.
Answered by AI
Add your answer
Q2. Thank you for giving me the best opportunity
Add your answer

Who many types of coding

Q1. What about your self
Add your answer
Q2. I am sorry asking about this
Add your answer
Q3. Who many people working in your dank
Add your answer
Q4. Tell me the dank details
Ans. 
The interviewer is asking for specific and detailed information.
• Provide in-depth analysis and specifics

• Include relevant data and examples

• Avoid vague or general responses
Answered by AI
Add your answer
Q5. What is the annual package
Ans. 
The annual package for the Business Analyst position is competitive and includes benefits.
• The annual package includes salary, bonuses, and benefits such as healthcare, retirement plans, and paid time off.

• The specific amount of the annual package may vary depending on the company, location, and level of experience.

• Candidates can negotiate their annual package during the job offer stage.
Answered by AI
Add your answer
Q6. I am sorry asking this like
Add your answer
Q7. Thank you for supporting me
Add your answer
Q8. Please stop the questions
Add your answer

Q1. What is the CPU
Ans. 
The CPU, or Central Processing Unit, is the primary component of a computer that performs instructions and processes data.
• The CPU is often referred to as the 'brain' of the computer

• It executes instructions from software programs

• The speed of a CPU is measured in gigahertz (GHz)

• Examples of CPU manufacturers include Intel and AMD
Answered by AI
Add your answer
Q2. Tell me about yourself
Add your answer
Q3. How many types of JavaScript in HTML
Ans. 
There is only one type of JavaScript in HTML, which is client-side JavaScript.
• There is only one type of JavaScript in HTML, which is client-side JavaScript.

• Client-side JavaScript is used to make web pages interactive and dynamic.

• Examples of client-side JavaScript include form validation, animations, and interactive maps.
Answered by AI
Add your answer

How many types of coding

What is the meaning this round

Tell me about growth of monthly in India

Q1. Question regarding job experience
Add your answer

Q1. About job role and experience
Add your answer

Q1. Salary discussion
Add your answer

Pandas and SQL questions and some business case

Q1. The head of the vertical took interview, explained role and asked about my experience.
Add your answer
Q2. What project did you work on?
Add your answer

Q1. A senior data scientist asked technical questions on my experience.
Add your answer
Q2. What is the advantage or lstm over rnn.
Ans. 
LSTM has better memory retention than RNN.
• LSTM can remember long-term dependencies better than RNN.

• LSTM has a gating mechanism that controls the flow of information.

• LSTM can handle vanishing gradient problem better than RNN.

• LSTM is more suitable for tasks that require long-term memory, such as speech recognition and language translation.
Answered by AI
Add your answer
Q3. What is multicollinearity and what are its effects?
Ans. 
Multicollinearity is a phenomenon where two or more independent variables in a regression model are highly correlated.
• It can lead to unstable and unreliable estimates of regression coefficients.

• It can make it difficult to determine the individual effect of each independent variable on the dependent variable.

• It can also result in inflated standard errors and p-values, making it difficult to identify statistically signif...read more
Answered by AI
Add your answer

Q1. Introduction about yourself
Ans. 
I am a highly motivated and detail-oriented analyst with a strong background in data analysis and problem-solving.
• Graduated with a degree in Statistics from XYZ University

• Proficient in statistical software such as R and Python

• Experience in analyzing large datasets to identify trends and patterns

• Strong communication skills to present findings to stakeholders
Answered by AI
Add your answer
Q2. Product details and Knowledge check
Add your answer

Q1. Process and compliance
Add your answer
Q2. Team Handled or not
Add your answer