AU Small Finance Bank 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. 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. More related towards Hadoop, Spark, scenario based competency questions
Add your answer

Q1. Code performance, optimization, batch processing
Add your answer

Q1. Questions on Data Modelling
Add your answer
Q2. Questions on SQL and Data Warehousing
Add your answer

Q1. SQL query writing involving complex queries
Add your answer
Q2. Questions on Snowflake and other distributed systems
Add your answer

Q1. Sql based questions
Add your answer

Q1. Basic technical questions not much complicated
Add your answer
Q2. Explain spark architecture
Ans. 
Spark architecture is a distributed computing framework that consists of a driver program, cluster manager, and worker nodes.
• Consists of a driver program that manages the execution of the Spark application

• Utilizes a cluster manager to allocate resources and coordinate tasks across worker nodes

• Worker nodes execute the tasks and store data in memory or disk for processing

• Supports fault tolerance through resilient distrib...read more
Answered by AI
Add your answer
Q3. Technical skills on hive Hadoop spark and python
Add your answer

Q1. Mostly on salary part
Add your answer