Premium Employer

i

This company page is being actively managed by Commonwealth Bank of Australia, India Team. If you also belong to the team, you can get access from here

Commonwealth Bank of Australia, India Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Commonwealth Bank of Australia, India Solution Designer Interview Questions and Answers

Updated 16 Jan 2022

Commonwealth Bank of Australia, India Solution Designer Interview Experiences

1 interview found

I applied via Naukri.com and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

9 Questions

  • Q1. Overall architecture of data lake and warehouse
  • Ans. 

    Data lake and warehouse are two different data storage solutions with distinct architectures.

    • Data lake is a centralized repository that allows storage of structured and unstructured data at any scale.

    • Data warehouse is a repository that stores structured data from various sources for querying and analysis.

    • Data lake uses a flat architecture, while data warehouse uses a hierarchical architecture.

    • Data lake is optimized for...

  • Answered by AI
  • Q2. My experience in design role
  • Q3. My experience around analytics and insights
  • Q4. Hadoop and cloud exposure
  • Q5. Basic on teradata
  • Q6. Data ingestion and integration
  • Q7. Data security and gdpr
  • Q8. Data encryption and hashing
  • Q9. Banking domain knowledge

Interview Preparation Tips

Interview preparation tips for other job seekers - Be straight forward, answer presicely ,
Say no if you don't know the answer.

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1. Explain SCD Type 2 Implementation in Informatica
  • Ans. 

    SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

    • SCD Type 2 maintains a separate row for each change in data, with a start and end date.

    • It requires a surrogate key to uniquely identify each row.

    • Informatica provides a built-in SCD Type 2 transformation to implement this technique.

    • Example: tracking changes in customer addresses over time.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Kindly focus on basic BI terminologies, common to trivial scenarios and introductory information on latest trending tools and technologies.

Skills evaluated in this interview

Interview Questionnaire 

8 Questions

  • Q1. Find a number which occurs odd number of times and all number occurs even number of times
  • Ans. 

    Find an odd occurring number among even occurring numbers.

    • Use XOR operation to cancel out even occurring numbers and get the odd occurring number.

    • Iterate through the array and XOR each element with the result variable.

    • The final result will be the odd occurring number.

  • Answered by AI
  • Q2. Some discussion about my minor project
  • Q3. Spiral order of binary tree and mattrix, print it
  • Ans. 

    Print the spiral order of a binary tree and matrix.

    • For binary tree, use level order traversal and alternate direction for each level.

    • For matrix, use four pointers to traverse in spiral order.

    • Example for binary tree: 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9

    • Example for matrix: 1 2 3 4 -> 8 7 6 5 -> 9 10 11 12 -> 16 15 14 13

  • Answered by AI
  • Q4. Some question about os,dbms
  • Q5. Find pair which have a given sum in a given array
  • Ans. 

    Finding pairs in an array with a given sum.

    • Iterate through the array and for each element, check if the difference between the given sum and the element exists in the array.

    • Use a hash table to store the elements of the array and their indices for faster lookup.

    • If there are multiple pairs with the same sum, return any one of them.

    • If no pair is found, return null or an empty array.

  • Answered by AI
  • Q6. Find total number of k element which have a given avg in a given array in minimum time complexity
  • Ans. 

    Find total number of k element with given avg in an array in minimum time complexity.

    • Use sliding window technique to traverse the array in O(n) time complexity.

    • Maintain a sum variable to keep track of the sum of elements in the window.

    • If the sum of elements in the window is equal to k times the given avg, increment the count.

    • Move the window by subtracting the first element and adding the next element in the array.

  • Answered by AI
  • Q7. Print all elements which in not boundary element in a given binary tree
  • Ans. 

    Printing non-boundary elements of a binary tree

    • Traverse the tree in any order (preorder, inorder, postorder)

    • Check if the current node is not a boundary node (not the first or last node in its level)

    • If it is not a boundary node, print its value

    • Recursively traverse its left and right subtrees

  • Answered by AI
  • Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question

Interview Preparation Tips

Round: Test
Experience: practice codes on paper
Tips:

Round: Technical Interview
Experience: very good
Tips: please try to explain each and every question in detail

Round: Technical Interview
Experience: my hr round is not taken by them,and some of face 3rd round ,which is HR
Tips: please prepare all types of problem from geeksforgeeks

Skill Tips: please try to understand every problem from geeksforgeeks
Skills: ds
College Name: NIT Bhopal
Motivation: best work culture,and a lots of learning opportunity in this company,and in every 6 month there is a appraisal

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. Asked many Dbsa questions. You need to be thorough about the joins in the databases.

Interview Preparation Tips

Round: Test
Experience: Practice questions on Indiabix.

Round: Technical Interview
Experience: Operating Systems basics, Dbsa basics

General Tips: 1: Be Confident.
2: Keep Smiling.
3: Do not be Panic.
4: Remember they are here to hire you but not reject you.
5: Do not loose hope.
6: Believe at yourself.
7: Start preparing early.
8: Do demo interviews with your friend.
Skill Tips: Make sure you do a course on object oriented programming
Skills: C, Sql, Java
College Name: BITS PILANI
Motivation: Every body joins a comapny for making a software or earning money. But I was always motivated to MAKE MONEY. I have taken this job because they have very extensive work in Share Market and they have lots of MBA from IIM's, Lots of CAs, CS. Thats why i have choosen Edelweiss. I have rejected epic System USA for this profile.

Interview Preparation Tips

Round: Test
Experience: The written test was quite similar to the typical CAT pattern. It contained sections on Reading Comprehension, Data Interpretation and Mathematics.

Round: Technical + HR Interview
Experience: There were 2 interviewers in the first interview, one was a technical guy and the other was from HR. They asked me a few very simple puzzles, a few basic programming questions (swapping the value of two variables etc.), questions related to the development cycle of software products. The HR guy asked stuff like what do you want to achieve in life? Strengths, weaknesses etc.

Round: Case Study Interview
Experience: The third interview was the most important one (and I guess that was the deciding interview). The interviewer started with questions like why finance? Which companies are you sitting for? Then he gave me a case study:

Interview Questionnaire 

2 Questions

  • Q1. Oops, os, dbms, project
  • Q2. Why hsbc, why should I hire you.
  • Ans. 

    I have a strong background in software engineering and a passion for innovation, making me a valuable asset to HSBC.

    • I have a proven track record of successfully delivering high-quality software solutions in previous roles.

    • I am highly skilled in various programming languages and technologies, including Java, Python, and SQL.

    • I have experience working in agile development environments, allowing me to adapt quickly to chan...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: 4 sections, 15 questions each. Sections on apti, english, programming, technical.
Tips: Time management, complete english and technical first
Duration: 1 hour
Total Questions: 60

Round: Group Discussion
Experience: We were asked which super hero would you like to be. Shared the information. Always present the positives and negatives and emphasize that despite of being negatives
Tips: Think everything through before speaking
Duration: 40 minutes

Round: Technical Interview
Experience: Prepare well, anything can be asked on the things written on your resume

Round: HR Interview
Experience: Sell yourself. Tell them why you would be the best candidate.
Tips: Tell your advantages of being a fresher that you would be comfortable in any technology

College Name: Acropolis institute of technology and research

I applied via LinkedIn and was interviewed before Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. All microsoft technologies related

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing

I applied via Recruitment Consultant and was interviewed in Dec 2020. There was 1 interview round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be 100% technical in java here they will not be any support u need to dig deep lot of complex modules which we cannot understand in depth

Interview Questionnaire 

1 Question

  • Q1. Questions on angular framework,.net core , dependency injection,legacy .net, session management , agile ceremonies.

I applied via Recruitment Consultant and was interviewed in Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. I was mostly asked about the process. First round was technical, mostly on Java
  • Q2. JVM Architecture, Java 9 new feature, collection framework, hibernate
  • Q3. 2nd round was mostly on tools and processes.

Interview Preparation Tips

Interview preparation tips for other job seekers - Always come prepare with whatever you have mentioned in your resume, if you talking about any tools, you should have end to end knowledge on that, you can't say I used Jenkins and then while answering, you would say I don't know how to create a job or pipeline. That kind of answer is not acceptable.

Commonwealth Bank of Australia, India Interview FAQs

How to prepare for Commonwealth Bank of Australia, India Solution Designer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Commonwealth Bank of Australia, India. The most common topics and skills that interviewers at Commonwealth Bank of Australia, India expect are Agile Methodology, SAS, Analytics, Business Intelligence and Business Objects.
What are the top questions asked in Commonwealth Bank of Australia, India Solution Designer interview?

Some of the top questions asked at the Commonwealth Bank of Australia, India Solution Designer interview -

  1. Overall architecture of data lake and wareho...read more
  2. Data ingestion and integrat...read more
  3. Hadoop and cloud expos...read more

Tell us how to improve this page.

Join Commonwealth Bank of Australia, India World-class technology and banking operations capability center

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 575 Interviews
Citicorp Interview Questions
3.7
 • 573 Interviews
HSBC Group Interview Questions
3.9
 • 487 Interviews
American Express Interview Questions
4.2
 • 365 Interviews
UBS Interview Questions
3.9
 • 338 Interviews
Morgan Stanley Interview Questions
3.6
 • 293 Interviews
FactSet Interview Questions
3.9
 • 208 Interviews
BNP Paribas Interview Questions
3.8
 • 180 Interviews
View all
Commonwealth Bank of Australia, India Solution Designer Salary
based on 8 salaries
₹28 L/yr - ₹43 L/yr
89% more than the average Solution Designer Salary in India
View more details
Senior Analyst
262 salaries
unlock blur

₹8.1 L/yr - ₹30.3 L/yr

Senior Software Engineer
251 salaries
unlock blur

₹15 L/yr - ₹50.1 L/yr

Senior Associate
242 salaries
unlock blur

₹5.8 L/yr - ₹12.4 L/yr

Software Engineer
205 salaries
unlock blur

₹12 L/yr - ₹35.6 L/yr

Analyst
204 salaries
unlock blur

₹4.8 L/yr - ₹20 L/yr

Explore more salaries
Compare Commonwealth Bank of Australia, India with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

HSBC Group

3.9
Compare

Citicorp

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview