ivy Interview Questions, Process, and Tips

It was coding McWilliams test of 20 questions with 2 coding questions

General group discussion questions

Q1. Don’t remember the question
Add your answer

Q1. Standard behavioural questions
Add your answer

Q1. Previous BAU tasks as BA
Ans. 
As a Business Analyst, previous BAU tasks included analyzing business processes, gathering requirements, creating documentation, and facilitating communication between stakeholders.
• Analyzed current business processes to identify areas for improvement

• Gathered requirements from stakeholders to understand their needs and priorities

• Created documentation such as business requirements documents, functional specifications, an...read more
Answered by AI
Add your answer
Q2. Write user stories on an MS Application
Ans. 
User stories for an MS Application
• As a user, I want to be able to create new documents in Word.

• As a user, I want to be able to format text in Excel.

• As a user, I want to be able to set reminders in Outlook.

• As a user, I want to be able to collaborate with others in PowerPoint.

• As a user, I want to be able to customize templates in Publisher.
Answered by AI
Add your answer

Q1. How much is relevant experience
Ans. 
Relevant experience is crucial for a Business Analyst as it provides the necessary skills and knowledge to effectively analyze business processes and make informed recommendations.
• Relevant experience includes working in a similar industry or role, understanding business processes, and using analytical tools.

• Experience in data analysis, project management, and communication skills are also important for a Business Analy...read more
Answered by AI
Add your answer
Q2. Why do you want to switch
Ans. 
I want to switch to explore new challenges and opportunities for growth.
• Seeking new challenges to expand my skill set

• Interested in exploring different industries and sectors

• Looking for opportunities for career advancement

• Want to broaden my professional network
Answered by AI
Add your answer

Q1. Pattern printing
Add your answer
Q2. Previous project
Ans. 
Developed a web application for tracking inventory and sales data
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js and Express

• Utilized MongoDB for database storage
Answered by AI
Add your answer

Q1. Acid properties
Ans. 
ACID properties are a set of properties that guarantee reliable database transactions.
• Atomicity: All operations in a transaction are completed successfully or none at all.

• Consistency: Database remains in a consistent state before and after the transaction.

• Isolation: Transactions are isolated from each other until they are completed.

• Durability: Once a transaction is committed, changes are permanent and cannot be lost.

• Ex...read more
Answered by AI
Add your answer
Q2. How to connect to db
Ans. 
To connect to a database, you need to use a database connection string with the appropriate credentials.
• Use a database connection string with the necessary information such as server address, database name, username, and password.

• Choose the appropriate database driver for the type of database you are connecting to (e.g. MySQL, PostgreSQL, MongoDB).

• Establish a connection using a programming language-specific database li...read more
Answered by AI
Add your answer

Q1. Expected salary
Ans. 
My expected salary is based on my experience, skills, and the market rate for Software Engineers.
• Consider my years of experience in software development

• Research the average salary for Software Engineers in this location

• Factor in any additional skills or certifications I may have

• Be open to negotiation based on the overall compensation package
Answered by AI
Add your answer
Q2. Preferred location
Ans. 
I am open to opportunities in various locations, with a preference for cities with a strong tech industry.
• Open to various locations

• Preference for cities with strong tech industry
Answered by AI
Add your answer

Q1. Asked to write algorithm for given problem
Add your answer
Q2. Describe current project
Add your answer

Q1. How do. you optimise a complex api what stratgies would you recommend
Ans. 
To optimize a complex API, consider reducing unnecessary data transfer, caching frequently accessed data, using efficient data structures, and implementing proper error handling.
• Identify and remove unnecessary data transfer to reduce latency

• Implement caching mechanisms for frequently accessed data to improve performance

• Use efficient data structures and algorithms to optimize processing speed

• Implement proper error handl...read more
Answered by AI
Add your answer
Q2. What are the cachine techniques you used in your previous project
Ans. 
I used various caching techniques such as in-memory caching and database caching in my previous project.
• Implemented in-memory caching using Redis to store frequently accessed data

• Utilized database caching by storing query results in memory to reduce database load

• Used HTTP caching to cache responses at the client or server side for faster retrieval
Answered by AI
Add your answer

Round 1 : Two DSA questions on arrays and strings that went on for 45 mins.

Q1. Maximum Sum Subarray
Add your answer
Q2. Anagram related string question
Add your answer