Interviewed for the position of Automation Test Analyst with Morgan Stanley, Mumbai, during March 2011.

Received a call from a search firm that processed my profile with Morgan Stanley, Mumbai. Subsequently, I was contacted by the Morgan Stanley recruitment team, who scheduled the first round of a telephonic interview with a Senior Manager/VP in the UK. The subsequent rounds proceeded as follows:

• 1st Round: Telephonic with a VP/Senior Manager in the UK to assess initial fitment, job profile, expectations, etc.
• 2nd Round: Telephonic round with a Framework Architect in Mumbai (covering QTP, VB script, logic, and puzzles).
• 3rd Round: Telephonic with a Framework Architect/Designer in London, UK (focusing on automation frameworks and QTP).

After these initial three rounds, I was invited for a face-to-face interview in Mumbai. Tickets and travel arrangements were handled by the Morgan Stanley recruitment team. The overall process was well-coordinated by HR. The interview process spanned almost the entire day, lasting approximately six hours, and consisted of:

• 1 HR Round (Face-to-face)
• 1 Technical Interview (Face-to-face)
• 1 Manager Round (Face-to-face)
• 2 Telephonic rounds with stakeholders and automation test specialists in the UK

I received the offer two weeks after the interview. Unfortunately, I was unable to accept the offer due to some conflicting priorities.

Describe the current framework, the considerations that went into designing it, any potential shortfalls of the framework, some suggested improvements on it, and hypothetical solutions around some technical requirements.

Test the sorting and filtering features of an Excel sheet through automation, especially using QTP or VBScript. The Excel sheet might contain millions of records, and the code should be optimized to perform the checks in the minimum possible time with accurate results.