IBM Senior Consultant Interview Questions and Answers

The P2P process, or Procure-to-Pay, encompasses the entire procurement cycle from requisition to payment.

• Initiation: The process begins with identifying a need for goods or services.

• Requisition: A purchase requisition is created and approved, detailing the required items.

• Supplier Selection: Suitable suppliers are evaluated and selected based on criteria like price and quality.

• Purchase Order: A formal purchase orde...read more

We have implemented Agile methodology by conducting daily stand-up meetings, using Kanban boards, and prioritizing user stories.

• Conducting daily stand-up meetings to discuss progress and roadblocks

• Using Kanban boards to visualize workflow and track tasks

• Prioritizing user stories based on business value and customer feedback

Rank assigns unique ranks to each distinct row, while dense rank assigns consecutive ranks to rows with the same values.

• Rank leaves gaps in rank values if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each distinct row based on the order specified, while dense rank function assigns consecutive ranks to rows with the same values

• For example, if we have scores of 90, 85, 85...read more

LWC is a newer component model that uses modern web standards while Aura is an older component model.

• LWC uses a shadow DOM while Aura does not.

• LWC has a smaller bundle size and faster performance compared to Aura.

• LWC has a more modular architecture while Aura has a more monolithic architecture.

• LWC has better support for mobile devices compared to Aura.

• Examples of LWC include lightning-input-field and lightning-but...read more

Different types of slowly changing dimensions (SCD) include Type 1, Type 2, and Type 3.

• Type 1 SCD: Overwrites old data with new data, losing historical information.

• Type 2 SCD: Keeps multiple versions of the same record, each with a unique identifier.

• Type 3 SCD: Tracks changes by adding columns to the existing record.

• Example: Type 1 - Updating a customer's address directly in the database.

• Example: Type 2 - Keeping ...read more

Discussing my record of timely payments and financial responsibility in professional settings.

• Consistently paid invoices within 30 days, maintaining strong vendor relationships.

• Implemented automated payment systems that reduced late fees by 20%.

• Managed a budget of $500,000, ensuring all expenses were tracked and paid on time.

• Received commendations from management for maintaining a flawless payment record over thre...read more