AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
ANZ Banking Group Data Engineer Interview Questions and Answers for Experienced
ANZ Banking Group Data Engineer Interview Experiences for Experienced
2 interviews found
Anonymous
I applied via Recruitment Consulltant and was interviewed in Nov 2024. There was 1 interview round.
(1 Question)
- Q1. Load 60 GB of csv file and perform transformation.
- Ans.
Use distributed computing framework like Apache Spark to efficiently load and transform the large CSV file.
Use Apache Spark to distribute the workload across multiple nodes for faster processing.
Utilize Spark's DataFrame API to read the CSV file and apply transformations.
Consider partitioning the data to optimize performance.
Use Spark SQL for complex transformations and aggregations.
Leverage in-memory processing capabi
I applied via Recruitment Consulltant and was interviewed in Apr 2024. There were 3 interview rounds.
They gave a regular problem like using sqllite in the code and using it to get data from a csv file and parse it. I was allowed to use google. They wanted to see how I approach a problem.
(1 Question)
- Q1. General questions on work experience, some technical basic questions
(2 Questions)
- Q1. Asked a lot of situational questions, seemed satisfied with the answers
- Q2. Why should we hire you? what was the one time you felt like a failure?
Interview Preparation Tips
Top trending discussions
Interview questions from similar companies
I appeared for an interview before Jun 2016.
Interview Questionnaire
6 Questions
- Q1. Tell me about yourself from the day u were born till today (Stopped mid way when I mentioned the finance course)
- Q2. What is a Brownian motion? Properties of Brownian motion?
- Ans.
Brownian motion is the random motion of particles in a fluid due to collisions with other particles.
Brownian motion was first observed by Robert Brown in 1827.
It is named after the botanist Robert Brown.
The motion is caused by the random movement of fluid molecules.
Brownian motion is a continuous-time stochastic process.
It is often used to model various phenomena in physics, finance, and biology.
Properties of Brownian ...
- Q3. What is a Martingale? What are Markov Processes? Is Martingale a Markov Process? Are Markov Processes Martingales?
- Ans.
A Martingale is a mathematical concept used in probability theory and statistics. Markov Processes are stochastic processes that satisfy the Markov property.
A Martingale is a sequence of random variables where the expected value of the next variable, given the current and past variables, is equal to the current variable.
Markov Processes are stochastic processes where the future state depends only on the current state a...
- Q4. Then the HR guy asked me One trait of mine that I’m not proud of?
- Q5. Then there was a puzzle m2 = n2 + 32294 ( It was also asked in last year’s interview)
- Q6. Then there was another HR question, In a group would it be better for me to assume a leadership position or simply be a part of it? Why?
Interview Preparation Tips
Experience: The Maths section had questions on basic probability and statistics. Also the Maths section had a higher weight age than the other sections (Questions carrying 3 marks each while other sections had 1 or 2 marks for each question. They were here, offering a quant profile so that justifies the distribution.) The DI/Quant (2 marks each) and English (1 Mark Each) section were similar to CAT. The finance section had questions on Basic Accounting. Anyone who did well in the Maths section could find his name in the shortlist.
Round: Technical + HR Interview
Experience: Possible Lapses: I
Data Analyst Interview Questions & Answers
Jana Small Finance Bank
Vikrant Yadav
posted on 20 Jan 2025
(1 Question)
- Q1. Questions mainly involved window function, recursion, some puzzels
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(3 Questions)
- Q1. Sas proc format
- Q2. How have you debug macros
- Ans.
I have debugged macros by reviewing code, checking for errors, using print statements, and stepping through code.
Reviewing the macro code line by line to identify any syntax errors or logical mistakes
Using print statements to output variable values and check for unexpected results
Stepping through the code using a debugger tool to track the flow of execution and pinpoint issues
Testing the macro with different inputs to
- Q3. How big data handled by you
- Ans.
I handle big data by using advanced analytics tools and techniques to extract valuable insights.
Utilize data visualization tools like Tableau or Power BI to analyze and present data
Use programming languages like Python or R for data manipulation and statistical analysis
Implement machine learning algorithms to uncover patterns and trends in large datasets
Leverage cloud computing platforms like AWS or Google Cloud for sc...
Skills evaluated in this interview
Discussion of jd, technical questions on spark
(2 Questions)
- Q1. Spark framework
- Q2. Spark dataframes
(2 Questions)
- 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.
- 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
Selected
I applied via LinkedIn and was interviewed in Sep 2023. There was 1 interview round.
(1 Question)
- Q1. Would you send a mail to stakeholder in place of your colleague
Selected
I applied via LinkedIn and was interviewed before Dec 2023. There was 1 interview round.
(1 Question)
- Q1. Automation you have done
I applied via Recruitment Consulltant and was interviewed in Jul 2022. There were 3 interview rounds.
(2 Questions)
- Q1. Questions on Data Modelling
- Q2. Questions on SQL and Data Warehousing
(2 Questions)
- Q1. SQL query writing involving complex queries
- Q2. Questions on Snowflake and other distributed systems
Interview Preparation Tips
- SQL
- Snowflake
- Python
- Data modell
(1 Question)
- Q1. Explain different type of SQL query?
- Ans.
Different types of SQL queries include SELECT, INSERT, UPDATE, DELETE, JOIN, and more.
SELECT: Retrieves data from a database
INSERT: Adds new records to a table
UPDATE: Modifies existing records in a table
DELETE: Removes records from a table
JOIN: Combines rows from two or more tables based on a related column
Interview Preparation Tips
ANZ Banking Group Interview FAQs
Tell us how to improve this page.
ANZ Banking Group Interviews By Designations
- ANZ Banking Group Analyst Interview Questions
- ANZ Banking Group Credit Assessment Officer Interview Questions
- ANZ Banking Group Operations Analyst Interview Questions
- ANZ Banking Group Engineer Interview Questions
- ANZ Banking Group Credit Officer Interview Questions
- ANZ Banking Group Senior Analyst Interview Questions
- ANZ Banking Group Software Developer Interview Questions
- ANZ Banking Group Senior Credit Assessment Officer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Engineer Interview Questions
- Big Data Engineer Interview Questions
- Software Engineer Interview Questions
- Database Admin Interview Questions
- Senior Software Engineer Interview Questions
- Data Analyst Interview Questions
- System Engineer Interview Questions
- Associate Software Engineer Interview Questions
- Show more
ANZ Banking Group Data Engineer Interview Process for Experienced
based on 2 interviews
Interview experience
Data Engineer Interview Questions from Similar Companies
Fast track your campus placements
ANZ Banking Group Data Engineer Reviews and Ratings
based on 8 reviews
Rating in categories
|
Senior Analyst
625
salaries
|  ₹3 L/yr - ₹10.5 L/yr |
|
Credit Assessment Officer
501
salaries
| ₹4 L/yr - ₹14 L/yr |
|
Analyst
416
salaries
| ₹2 L/yr - ₹8.5 L/yr |
|
Senior Credit Assessment Officer
272
salaries
| ₹5.6 L/yr - ₹21 L/yr |
|
Engineer
168
salaries
| ₹9.2 L/yr - ₹38.1 L/yr |
AU Small Finance Bank
IndusInd Bank
IDFC FIRST Bank
Yes Bank
- Home >
- Interviews >
- ANZ Banking Group Interview Questions >
- ANZ Banking Group Data Engineer Interview Questions for Experienced
