Commonwealth Bank of Australia, India Interview Questions, Process, and Tips

Q1. C# programs based on requirement
Add your answer

Basic c# programs for valuations

Q1. 1. Scenario based questions on rest assured
Add your answer
Q2. Detailed question on performance testing 90th percentile
Add your answer
Q3. Automation framework Design discussion and challenges faced
Add your answer
Q4. How to connect db from Java code and one scenario question on this
Add your answer

Q1. About cba core values discussion
Add your answer

Q1. OOPS CONCEPTS c#, web apu
Add your answer

Q1. How to optimize a query performance
Add your answer

Q1. What are the Projects you have worked??
Add your answer
Q2. How good are you in SQL ??
Ans. 
I am proficient in SQL and have experience in writing complex queries.
• Proficient in writing complex SQL queries

• Experience in working with large databases

• Familiarity with database management systems like MySQL, Oracle, and SQL Server

• Ability to optimize queries for better performance

• Experience in data analysis and reporting using SQL
Answered by AI
Add your answer
Q3. How good are you in DW Concepts
Ans. 
I have a strong understanding of DW concepts and their application in quality engineering.
• I have experience in designing and implementing data warehouses.

• I am proficient in ETL processes and data integration.

• I have knowledge of dimensional modeling and data mart design.

• I am familiar with data quality management and data governance practices.

• I have worked with various DW tools such as Informatica, SSIS, and Talend.

• I hav...read more
Answered by AI
Add your answer
Q4. Basic ETL Testing Flow
Add your answer
Q5. SQL - Concatenation, SUBSTR, INSTR, Rank & Dense Rank, UNION & UNION ALL , MINUS , Duplicate Handling
Add your answer

Q1. Explain about the Projects you have worked ?
Ans. 
I have worked on various projects as a Quality Engineer.
• Implemented quality control measures to ensure product compliance

• Developed and executed test plans and procedures

• Identified and resolved quality issues through root cause analysis

• Collaborated with cross-functional teams to improve product quality

• Implemented statistical process control techniques for process improvement
Answered by AI
Add your answer
Q2. Architecture of the project
Ans. 
The project architecture is a layered architecture with separate components for presentation, business logic, and data access.
• The project follows a layered architecture pattern.

• There are separate components for presentation, business logic, and data access.

• The presentation layer handles the user interface and interaction.

• The business logic layer contains the core functionality and rules of the application.

• The data acce...read more
Answered by AI
Add your answer
Q3. Business Knowledge on the project
Add your answer
Q4. SQL and DataWarehose Concepts
Add your answer
Q5. Basic Testing Knowledge
Add your answer
Q6. Challenges faced in ETL Testing Projects
Ans. 
Challenges in ETL Testing Projects
• Data quality issues

• Complex data transformations

• Handling large volumes of data

• Ensuring data integrity

• Dealing with data inconsistencies

• Performance testing

• Managing dependencies between source and target systems
Answered by AI
Add your answer

Q1. Why there is lot switches in your profile ?
Ans. 
I have experience with a variety of switches in my profile.
• I have worked with different types of switches in my previous roles.

• Switches are an essential component in quality engineering as they help control and monitor various processes.

• Examples of switches I have worked with include pressure switches, temperature switches, and limit switches.

• I am familiar with the principles of switch operation and troubleshooting.

• Hav...read more
Answered by AI
Add your answer
Q2. Are you able to relocate to Bangalore ?
Ans. 
Yes, I am able to relocate to Bangalore.
• I am open to relocating to Bangalore for the position.

• I have no issues with moving to Bangalore for work.

• I am willing to make the necessary arrangements to relocate to Bangalore.

• I understand the importance of being flexible and adaptable in my career.

• I have previously relocated for job opportunities and have successfully adjusted to new environments.
Answered by AI
Add your answer
Q3. Do you have any offer in Hand ?
Add your answer

Q1. Springboot microservices
Add your answer
Q2. SAGA design pattern & java8
Add your answer