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

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

What is a key disadvantage of the F-test when compared to multiple t-tests?

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

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

Commonwealth Bank Salaries by Position

Role: Senior Software Engineer (PeopleSoft)Experience: 7-10 yearsLocation: Bengaluru <ul><li>You are passionate about making peoples jobs simpler and more rewarding</li><li>We are a team of big thinkers who are engineering the future of banking </li><li>Together we could create industry leading product lifecycles that support capabilities, people and technology</li></ul> Do work that mattersCommBank is recognized as leading the industry in IT and operations with its world-class platforms and processes, agile IT infrastructure, and innovation in everything from payments to internet banking and mobile apps. As a member of the Finance Technology team, you will contribute to all aspects of the financials technology services we deliver, from inception and design to coding to deployment to operation. Our Core Finance platform/services are leveraged across all Business Unit Platforms globally. What will set you up for success? <ul><li>You’re ready to scale up engineered quality for competitive advantage </li><li>You’re passionate about making peoples jobs simpler and more rewarding </li><li>The opportunity to enable quality at scale in practices beyond testing excites you</li><li>You thrive to bring best practices and innovation to solve complex engineering problems with simple solutions</li></ul> We’re interested in hearing from people who:<ul><li>Develop and test efficient, reliable and maintainable application components and solutions to meet design specifications for Finance projects and operations.</li><li>Designs technical solutions and consumption patterns.</li><li>Influences and guides stakeholders in the definition of requirements.</li><li>Communicate efficiently within or outside team to create a transparent work environment</li><li>Software development according to program specifications and as directed.</li><li>Follow release and change processes in the compilation and distribution of software builds and releases to development and test environments.</li><li>Basic troubleshooting of environment and deployment issues.</li><li>Engage with project stakeholders to provide system support.</li><li>Implement system updates into production in accordance with specific production readiness and change management protocol.</li></ul>Tech SkillsEssential<ul><li>5 - 8 Years of experience as a PeopleSoft Techno-Functional Consultant in PeopleSoft Finance (9.1/9.2) Support/Enhancement, Implementation and Upgrade projects.</li><li>Experience in developing efficient solutions using PeopleSoft PeopleTools 8.5x - Application designer, App Engine, Component Interface, People Code, Application Package, Workflow/AWE, and Integration Broker, PSQUERY, DMS & Web services.</li><li>Experience in Designing & Developing reports using XMLP, SQR, PSQUERY</li><li>Experience and understanding of PeopleSoft Security - Application, Data, Definition security.</li><li>Experience in comparing & migrating code changes between PeopleSoft environments.</li><li>Excellent client-facing consulting and communication skills.</li><li>Experience with PeopleSoft integrations including good understanding of the standard API’s.</li><li>Able and willing to participate in hands-on configuration activities.</li><li>Experience with Agile frameworks and tools, in particular Jira and Confluence</li></ul> Desirable:<ul><li>Good knowledge of PeopleSoft Finance functionality and processes. Overall Understanding of core modules like General Ledger, Accounts Payable, Asset Management, Expenses and AR/BI.</li><li>Ability to form strong relationships with business SME's and vendors.</li><li>Strong influence, communication and presentation skills, ability to liaise with technical/non-technical stakeholders and senior management</li><li>Ability to work as part of both support and project teams.</li><li>Demonstrate initiative by identifying inefficiencies and able to recommend improvements.</li><li>Excellent requirements gathering skills and ability to translate business requirements into specifications.</li></ul> If you are interested in this opportunity, please email your updated CV to RithishP.Ravi@cba.com.au

Role: Software Engineer - Abintio DevelopmentExperience: 6-9 years Your responsibilities:<ul><li>Adhere to the <a>Code of Conduct</a>. The Code of Conduct sets the standards of behaviour, actions and decisions we expect from our people.</li><li>Complete project work stream deliverables including quality control/sign off for area of accountability.</li><li>Recommend changes to processes and systems, with measurable business benefits, based on current and future customer needs, industry trends and new technologies, knowledge of the system, analysis and performance and oversee the management and execution of any enhancements made.</li><li>Manage relationships with suppliers, where required.</li><li>Undertake appropriate planning for compliance upgrades and/or software releases.</li><li>Conduct release planning and demand management for business systems.</li><li>Ensure effective change management and capacity management processes are in place.</li><li>Ensure Group methodologies and processes are embraced.</li><li>Mentor and develop junior team members and/or lead small functional teams.</li></ul> Undertake any other tasks assigned by your manager that you have the capability to perform safely in line with relevant internal Bank policies and external regulatory requirements. Your Experience and Skills: <ul><li>Knowledge of the systems and technologies which this role will support including:</li><li>Abinitio</li><li>SAP Ariba.</li><li>Integration tools– Autosys scheduling, SFTP, APIs, etc.</li><li>SQL.</li><li>JIRA.</li><li>Minimum two years’ experience in Procurement applications.</li><li>Experience working on technology enabled projects using Software as a Service (SaaS) solutions.</li></ul>Desirable:<ul><li>SAP Fieldglass.</li><li>Ability to program in JavaScript.</li><li>Knowledge of markup languages like HTML and XML.</li><li>Web development tools and techniques such as .NET and AJAX.</li><li>Cloud computing expertise.</li><li>Working as part of a geographically dispersed team</li><li>Detailed knowledge of specific CBA business systems and processes</li></ul>

Role: Software Engineer (SAP Ariba)Experience: 3-6 years Your responsibilities<ul><li>Adhere to the <a>Code of Conduct</a>. The Code of Conduct sets the standards of behaviour, actions and decisions we expect from our people.</li><li>Complete project work stream deliverables including quality control/sign off for area of accountability.</li><li>Recommend changes to processes and systems, with measurable business benefits, based on current and future customer needs, industry trends and new technologies, knowledge of the system, analysis and performance and oversee the management and execution of any enhancements made.</li><li>Manage relationships with suppliers, where required.</li><li>Undertake appropriate planning for compliance upgrades and/or software releases.</li><li>Conduct release planning and demand management for business systems.</li><li>Ensure effective change management and capacity management processes are in place.</li><li>Ensure Group methodologies and processes are embraced.</li><li>Mentor and develop junior team members and/or lead small functional teams.</li></ul> Undertake any other tasks assigned by your manager that you have the capability to perform safely in line with relevant internal Bank policies and external regulatory requirements. Your Experience and SkillsExperience:Essential:<ul><li>Knowledge of the systems and technologies which this role will support including:</li><li>SAP Ariba.</li><li>P2P/S2P.</li><li>Contract Management.</li><li>Sourcing.</li><li>Ability to program in JavaScript.</li><li>Cloud computing expertise.</li><li>Integration tools– Autosys scheduling, SFTP, APIs, etc.</li><li>SQL.</li><li>JIRA.</li><li>Minimum two years’ experience in Procurement applications.</li><li>Experience working on technology enabled projects using Software as a Service (SaaS) solutions.</li></ul>Desirable:<ul><li>SAP Fieldglass.</li><li>Knowledge of markup languages like HTML and XML.</li><li>Web development tools and techniques such as .NET and AJAX.</li><li>Working as part of a geographically dispersed team</li><li>Detailed knowledge of specific CBA business systems and processes</li></ul> If you are interested in this opportunity, please email your updated CV to RithishP.Ravi@cba.com.au

Role: Senior Software Engineer (Pega)Experience: 6-10 years Your experience:<ul><li>Upto 6-10 years of experience in building, desiging Pega applications.</li><li>Experience in designing and developing Pega PRPC applications using Pega .</li><li>Experience with process methodology, development methodologies</li><li>(Agile, SDLC, Iterative) strongly preferred.</li><li>Excellent object-oriented analysis and design skills and system integration skill</li><li>Excellent track record of delivery within large projects</li><li>Excellent executive communication & presentation</li><li>Experience designing and developing process-based solutions or BPM (business process management)</li><li>Experience in various rules and features like Flows, Activities, User Interface, Flow Actions, Agents, SLA, Correspondence, SingleSignOn, External Authentication, PRPC Security, Reports, Listeners (File, MQ), Connectors and SOAP</li></ul> Essential:Certified System Architect & Certified Senior System Architect (CSSA) If you are interested in this opportunity, please email your updated CV to RithishP.Ravi@cba.com.au

Commonwealth Bank Interview Questions

Commonwealth Bank Interview Guides

Commonwealth Bank Interview Questions

Commonwealth Bank Salaries by Position

Commonwealth Bank Opening Jobs