ANZ Banking Group Data Engineer Interview Questions and Answers

The first round which is online assessment for eliminating candidates was conducted consist of medium level aptitude questions there were 3 sub sec have duration of 20 15 15 minutes and questions 15 10 10 respectively and you cannot move to further section there is time constraints for each then followed by 15 minutes psychometric section having 50 questions that's all for screening round the total duration was 65 min.
Total 24 candidates were selected from this round out of 200 plus

Q1. What motivates to you for this job ?
Add your answer
Q2. What are the risks you have taken in previous role?
Add your answer
Q3. How do you handle the situation when your opinion differ from your senior members in your team?
Add your answer
Q4. Provide a approach to develop ETL pipeline where csv file is dropped in S3 and transform through airflow and load to snowflake.
Ans. 
Develop ETL pipeline using Airflow to process CSV files in S3 and load data into Snowflake.
• Set up an S3 sensor in Airflow to detect when a new CSV file is dropped in the specified bucket.

• Create a custom Python operator in Airflow to read the CSV file from S3, perform necessary transformations, and load data into Snowflake.

• Use SnowflakeHook in Airflow to establish connection with Snowflake and execute SQL queries to loa...read more
Answered by AI
Add your answer

Discussion of jd, technical questions on spark

Q1. Spark framework
Add your answer
Q2. Spark dataframes
Add your answer

Q1. Current ctc getting
Ans. 
I am currently earning $80,000 per year.
• My current annual salary is $80,000.

• I am earning $6,666.67 per month.

• I receive a monthly salary of $6,666.67.
Answered by AI
Add your answer
Q2. Expected CTC that is needed
Ans. 
Expected CTC should be based on industry standards, experience, skills, and location.
• Research industry standards for Data Engineers in your location

• Consider your level of experience and skills

• Factor in the cost of living in the area where the job is located

• Negotiate based on the value you bring to the company
Answered by AI
Add your answer

Q1. Airflow SQL Python DWH
Add your answer

Q1. Airflow Pyspark SQL AWS
Add your answer

Q1. Relocation , tech stack
Add your answer

Q1. What is an index and what does it do
Ans. 
An index is a data structure that improves the speed of data retrieval operations in a database by allowing quick access to specific data.
• Indexes are used to quickly locate data without having to search every row in a database table.

• They are created on specific columns in a table to speed up queries that filter or sort by those columns.

• Examples of indexes include primary keys, unique keys, and non-unique indexes.
Answered by AI
Add your answer

Q1. Tell me a time you resolve conflict
Add your answer

Q1. Basics of spark , Hadoop,sql, python
Add your answer

Q1. Building a pipeline
Ans. 
Building a pipeline involves creating a series of interconnected data processing steps to move and transform data from source to destination.
• Identify data sources and destinations

• Determine the data processing steps required

• Choose appropriate tools and technologies

• Design and implement the pipeline

• Monitor and maintain the pipeline
Answered by AI
Add your answer

Q1. Resume based questions
Add your answer

Q1. Where do you see yourself in 5 years
Ans. 
In 5 years, I see myself as a senior data engineer leading a team, implementing innovative solutions, and driving data-driven decision-making.
• Leading a team of data engineers

• Implementing innovative solutions to optimize data processing and analysis

• Driving data-driven decision-making across the organization

• Continuously learning and staying updated with the latest technologies and trends in data engineering

• Contributing t
Answered by AI
Add your answer