Prepare for and practice interview questions from Commonwealth Bank.

Commonwealth Bank Interview Questions

Commonwealth Bank Interview Guides

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

Let’s say we have a table with an <code>id</code> and <code>name</code> fields. The table holds over 100 million rows and we want to sample a random row in the table without throttling the database.

Write a query to randomly sample a row from this table.

Input:

<code>big_table</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>

Write a query to randomly sample a row from a big table.

Random SQL Sample

Let’s say you work for a social media company that has just done a launch in a new city. Looking at weekly metrics, you see a slow decrease in the average number of comments per user from January to March in this city.

The company has been consistently growing new users in the city from January to March.

What are some reasons why the average number of comments per user would be decreasing and what metrics would you look into?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

What metric could be used to measure if active users are still engaging on the platform despite an overall decrease in the average number of comments per user?

Decreasing Comments

How would you investigate a decline in the average number of comments per user?

Commonwealth Bank Salaries by Position

Role: Engineering ManagerExperience: 14-16 years Chapter Lead - Workflow Engineering<ul><li>You are a passionate leader, specialised in managing high-performing teams.</li><li>Responsible for delivering best in class engineering solutions</li><li>We're one of the biggest workflow practices across Australia</li><li>Together we can build state-of-the-art solutions for people</li></ul> Do work that mattersThe Workflow Crew is responsible for driving the architecture, design, build and governance roadmap across the group for various workflow technologies. This is your opportunity to join an established company where there is a focus on personal and professional development.As an organisation, we foster an innovative, dynamic culture and a genuine commitment to drive diversity and inclusion. As Workflow Engineer, you will be responsible for ongoing change and development for the workflow solutions and provide technology oversight to different business units like Retail Banking, Business Banking, etc.You also have the opportunity to provide your technical expertise to help strengthen the standards of the team that spans across multiple geographies.We are passionate, dynamic and customer obsessed! We welcome diverse view-points and seek these out in delivering customer value. We want to re-imagine ‘what’s possible’ and make all of our decisions with a customer-obsessed lens! We welcome innovative thinking, and an eagerness to get things done. You will foster an environment of engineering excellence and a culture of ongoing improvement. You will support critical programs of work by designing and implementing solutions for business driven initiatives and technology uplift. See yourself in our team Within this role, you will work alongside a fantastic team of people, and highly invested managers focused on your career progression. You will foster an environment of engineering excellence and a culture of ongoing improvement. You will support critical programs of work by designing and implementing solutions for business driven initiatives and technology uplift as part of Workflow Crew. You will enjoy working in a hybrid agile development environment, running workshops and sprint ceremonies. We’re Interested In Hearing From People Who<ul><li>Can provide advanced technical knowledge and experience to assist in resolving technology issues</li><li>Have understanding of core business and technical strategies to deliver best business outcomes</li><li>Can provide consultancy across projects and delivery teams and contribute to delivery planning with expert advice</li><li>Can follow best practices and industry standards in the team while fine tuning those standards to fit the CBA standards.</li><li>Can drive the development of strategic programs of work, including proof of concept developments.</li><li>Manage a team of talented engineers as a people leader.</li><li>Can take responsibility for nominated technical assets related to areas of expertise including roadmaps and technical direction</li></ul>Technical Skills We use a broad range of tools, languages, and frameworks. We do not expect you to know them all but experience or exposure with some of these, or a willing to learn these skillsets (or equivalents) will set you up for success in this team!<ul><li>Pega CLSA Certification – Must Have.</li><li>Excellent Experience in designing and developing Pega and workflow applications</li><li>Excellent knowledge of integrations patterns, design and implementation</li><li>Various hosting patterns like Pega SaaS, AWS, Azure.</li><li>Cloud domain knowledge - AWS Certification, Nice to have. </li><li>Designing, documenting and presenting formal solution designs</li><li>Agile & Scrum Knowledge</li><li>Proficient at SQL and working with other larger volume in data</li><li>Knowledge of Standard industry tools for CI/CD pipeline</li><li>Experience with debugging and tuning performance issues</li><li>Excellent understanding of micro services architecture, API gateways and restful API design patterns</li><li>Sound grasp of data integrity, system security, and unit testing</li><li>Sound grasp of containerisation (Docker, Kubernetes), AWS cloud hosting, Cloud cost optimisations</li><li>Understanding of monitoring tools and event based application models with Kafka</li><li>Knowledge of CI/CD pipeline – Jenkins, Github Actions</li><li>Knowledge of Devops practices – composing Yaml pipelines, Infrastructure as code</li></ul> What will set you up for success?Our Chapter Leads are hands-on technical leaders, defining their teams’ technical roadmap and fostering a world-class engineering culture of innovation and curiosity.<ul><li>Prioritise the work the engineers would be productive and autonomous.</li><li>An evangelist for engineering principles, practices and standards</li><li>Be responsible for the strategic technology direction for the team, including managing code</li><li>Manage workforce planning and staff retention, cultivating a safe and trusted working environment </li><li>You are able to manage relationships and communications with project stakeholders, including customers and delivery teams. Along with vendors and third-party suppliers</li><li>Champion thought leadership for the process architecture and develop options for improving and updating current capability.</li><li>Act as an escalation, advice, and decision-making point for Pega Case Management.</li><li>Review and contribute to reference architecture and platform initiative involving workflow.</li><li>Monitor emerging technologies, industry developments, directions, and best practices.</li><li>Provide specialised expertise and development using Java, JEE and Pega Platform</li><li>Analysing systems to provide system support and recommendations for development.</li><li>Expert troubleshooting of implementation, environment and deployment issues.</li><li>Establish new ways of working and promote DevOps culture of CI/CD pipelines and Automation supported by world-class tools</li><li>Have expertise in managing any workflow based technical environments (preferably Pega)</li><li>Expertise to define and effectively communicate a long-term technical vision</li></ul> Working with us Whether you're passionate about customer service, driven by data, or called by creativity, a career with CommBank is for you. Our people bring their diverse backgrounds and unique perspectives to build a respectful, inclusive, and flexible workplace with flexible work locations. One where we’re driven by our values, and supported to share ideas, initiatives, and energy. One where making a positive impact for customers, communities and each other is part of our every day. Here, you’ll thrive. You’ll be supported when faced with challenges and empowered to tackle new opportunities. We’re hiring engineers from across all of Australia and have opened technology hubs in Melbourne, Adelaide, Brisbane and Perth. We really love working here, and we think you will too. We support our people with the flexibility to balance where work is done with at least half their time each month connecting in office. We also have many other flexible working options available including changing start and finish times, part-time arrangements and job share to name a few. Talk to us about how these arrangements might work in the role you’re interested in. If this sounds like the role for you then we would love to hear from you. Apply today!

Commonwealth Bank Interview Questions

Commonwealth Bank Interview Guides

Commonwealth Bank Interview Questions

Commonwealth Bank Salaries by Position

Commonwealth Bank Opening Jobs