Prepare for and practice interview questions from Cibc.

Cibc Interview Questions

Cibc Interview Guides

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

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

Cibc Salaries by Position

CIBC Senior Business Analyst Chicago, Illinois Apply Now We’re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what’s right for our clients.
At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and what they contribute.
JOB PURPOSE
The Senior Business Analyst is responsible for working with stakeholders across the organization as part of a program/project team to successfully develop/design/configure and implement a new system or process. This is accomplished by partnering with business end users, technical teams, vendors, and other stakeholders gathering and documenting business requirements, documenting current and future process flows, creating use cases and test plans, and planning and managing the user acceptance testing effort for that new system or process.
KEY ACCOUNTABILITIES
Requirements Gathering:
Collaborate with stakeholders, including business users, project managers, and developers to gather and document detailed business requirements. Conduct interviews, workshops, and brainstorming sessions to elicit requirements, ensuring a comprehensive understanding of business needs.
Documentation of Process Flows:
Create clear and concise process flow diagrams, mapping out current and future state processes. Identify process gaps, inefficiencies, and areas for improvement.
Test Planning and Management:
Develop comprehensive test plans with test objectives and test cases based on gathered requirements. Execute and manage test activities including test execution, defect management, and reporting.
Project Support:
Work closely with program/project manager(s), providing support throughout each project lifecycle phase. Assist in project planning, tracking progress, and managing project documentation.
Documentation and Reporting:
Create comprehensive project documentation, including business requirements, functional specifications, use cases, and process flows. Assist the program/project manager(s) in preparing status reports, dashboards, and presentations.
Process Improvement:
Continuously evaluate and improve project management methodologies, tools, and templates to enhance project efficiency and effectiveness.
Leadership:
Display deep business perspective; comprehensive knowledge across multiple lines of business and/or legal entities within the US Region. Effectively guide business analysts to execution with best practices.
What CIBC Offers
At CIBC, your goals are a priority. We start with your strengths and ambitions as an employee and strive to create opportunities to tap into your potential.
What you need to know
CIBC is committed to creating an inclusive environment where all team members and clients feel like they belong. You need to be legally eligible to work at the location(s) specified above.
Job Location
Employment Type
Regular
Weekly Hours
40
Skills
Business Effectiveness, Business Requirements, Communication, Data Mining, Data Reporting, Metrics Analysis, Process Improvements, Reporting and Analysis, Requirements Management, Statistical Analysis, Test Execution, Test Management

#J-18808-Ljbffr

Were building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing whats right for our clients. At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and what they contribute. To learn more about CIBC, please visit CIBC.com (https://www.cibc.com/en/about-cibc.html) US Technology, Infrastructure & Innovation (US TI&I) enables the continuous transformation of our Bank by accelerating the shift to digital, strengthening operational resilience, simplifying what we do, improving CIBC's speed to market and protecting our Bank's assets. The teams work to maximize the investment in resources and technology while building an appropriate balance between high-touch client service and our fiduciary responsibility to protect CIBC, our clients, and our shareholders from undue risk. **What you'll be doing** As a hands-on Lead Software Engineer/Architect in technology architecture, you will architect and drive the design and development of complex, highly integrated, data-intensive custom software. Work with a team of experienced developers, system analysts, and QA testers and regularly interact with business partners regarding requirements and project milestones. Hands-on and staying very technical. Responsible for developing solution architectures that reflect the integration of business logic, processes, and data that deliver on the business need. Guide solution delivery teams in the implementation of the solution architecture. Contribute to the architecture roadmap that integrates and aggregates all of the solutions for a business unit. **How you'll succeed** + **Client engagement: ** Meet with internal clients to understand their priorities, advise them on solutions, and provide forward-looking technical solutions. Use your knowledge of software development tools and methods to help clients meet their goals. + **Relationship building: ** Work with internal CIBC teams, including operations, business, security, and cloud engineering. Grow your network, deepen existing relationships, and collaborate with others to ensure clients are connected to the right people and opportunities. + **Leveraging technology:** Become a technology expert. Share your knowledge by introducing clients to our banking applications, enabling them to better manage their banking needs. **Who you are** + You serve as a "trusted advisor" to the application development team and their business partners to achieve strategic objectives through the effective use of technology. + You are an expert with: Azure, Asp.NET, MS SQL, ETL, Entity Framework, browser-based technologies like JavaScript, jQuery, CSS, etc. + You have hands-on development for prototype solutions + You have experienced with large-scale software development; and experience with DevOps is a plus. + You have a minimum of 7 years of experience software engineering and architecture. Technology experience within financial services is preferred. + You are a transformative thought leader who is responsible for the development and implementation of solution roadmaps. + You can build rapport with all business stakeholders. + You have worked as a senior contributor to cross-functional teams to design and deliver software solutions that deliver business value. + You have the ability to handle a high degree of ambiguity; adapting to changing priorities; continuously finding areas to deliver value and have the ability to handle multiple, concurrent, large initiatives. + You assess, strategize, and manage the delivery of data-related projects. + You collaborate with partner teams to define deliverables and create documentation. + You develop solution concepts. + You excel at defining both solutions and data architecture. + You have demonstrated experience in analyzing relevant information and prepare recommendations to guide teams in building high-quality solutions. + You can manage technical tasks at a granular level. + You proactively identify risks. Anticipate issues and guide teams through complex situations. + You act as a key liaison across the IT department. + You put our clients first. You engage with purpose to find the right solutions. You go the extra mile because it's the right thing to do. + Youre goal-oriented. Youre motivated by accomplishing your goals and delivering your best to make a difference. + You're passionate about people. You find meaning in relationships and surround yourself with a diverse network of partners. You connect with others through respect and authenticity. + You love to learn. You're passionate about growing your knowledge. You have a strong sense of curiosity. + Youre a certified professional. Microsoft certifications (including Azure) are desirable but not required. + Values matter to you. You bring your real self to work, and you live our values - trust, teamwork, and accountability. _At CIBC, we enable the work environment most optimal for you to thrive in your role. Youll have the flexibility to manage your work activities within a hybrid work arrangement where youll spend 25 days per month on-site while other days will be remote._ California residents your privacy rights regarding your actual or prospective employment (https://us.cibc.com/en/about-us/california-consumer-privacy-act-employment.html) **What CIBC Offers** At CIBC, your goals are a priority. We start with your strengths and ambitions as an employee and strive to create opportunities to tap into your potential. We aspire to give you a career, rather than just a paycheck. + We work to recognize you in meaningful, personalized ways including a competitive salary, incentive pay, banking benefits, a benefits program*, a vacation offering, wellbeing support, and MomentMakers, our social, points-based recognition program. + Our spaces and technological toolkit will make it simple to bring together great minds to create innovative solutions that make a difference for our clients. + We cultivate a culture where you can express your ambition through initiatives like Purpose Day; a paid day off dedicated for you to use to invest in your growth and development. *Subject to plan and program terms and conditions **What you need to know** + CIBC is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. If you need accommodation, please contact Mailbox.careers-carrieres@cibc.com + You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit. + We may ask you to complete an attribute-based assessment and other skills tests (such as simulation, coding, MS Office). Our goal for the application process is to get to know more about you, all that you have to offer, and give you the opportunity to learn more about us. **Job Location** IL-70 W Madison St, 10th Fl **Employment Type** Regular **Weekly Hours** 40 **Skills** Custom Software, Data Architecture, JavaScript, Microsoft .NET Development At CIBC, we are in business to help our clients, employees and shareholders achieve what is important to them. Our ability to create value for all CIBC stakeholders is driven by a business culture based on common values: Trust, Teamwork and Accountability. Working with CIBC makes you a part of a work environment committed to our clients, employees and communities - a place where you can excel. Every day, our 44,000 employees help our clients achieve their financial goals, because what matters to our clients, matters to us.

Cibc Interview Questions

Cibc Interview Guides

Cibc Interview Questions

Cibc Salaries by Position

Cibc Opening Jobs