i
Filter interviews by
Be the first one to contribute and help others!
I applied via Approached by Company and was interviewed in Oct 2024. There were 4 interview rounds.
Codility Test General C# and SQL
Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.
Create a class Employees with fields FirstName, LastName, DoB, and Gender
Calculate the average age of all employees
Calculate the average age by genders
I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.
Singleton pattern ensures a class has only one instance and provides a global point of access to it.
Factory pattern creates objects without specifying the exact class of object that will be created.
Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and up...
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate joins and subqueries
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
Clustered index: Physically reorders the data in the table based on the index key.
Non-clustered index: Contains a sorted list of references to the table data rows.
Unique index: Ensures that no two rows have the same values in the indexed columns.
Composite index: Index that is created on multiple columns.
Filtered index: Index that...
Yes, I have read SQL Execution Plans to optimize query performance.
I have analyzed SQL Execution Plans to identify bottlenecks in queries.
I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.
I have made query optimization recommendations based on SQL Execution Plans.
I have experience with tools like SQL Server Management Studio to view and analyze Execu
posted on 10 Dec 2024
I applied via Naukri.com and was interviewed in Nov 2024. There were 3 interview rounds.
My experience as a Category Manager in the retail industry aligns well with the needs of this company.
Managed product categories to drive sales and profitability
Developed strategic plans for assortment and pricing
Worked closely with suppliers to negotiate contracts and promotions
Implemented cost-saving initiatives and optimized product assortment to increase profitability.
Analyzed sales data to identify underperforming products and discontinued them
Negotiated better pricing with suppliers to reduce costs
Implemented promotional strategies to drive sales and increase margins
Optimized inventory levels to reduce carrying costs
Introduced new product lines with higher profit margins
The steps to start a new category involve market research, identifying trends, setting goals, creating a strategy, selecting products, and launching the category.
Conduct market research to identify gaps and opportunities in the market.
Identify trends and consumer preferences to determine the potential success of the new category.
Set clear goals and objectives for the new category, including sales targets and market sha...
The first round was a coding test, which was outsourced to an external vendor. I was asked 2 basic DSA questions, and there was discussions around the time and space complexity, and scope of optimizing the solutions. Post that there were a few questions around Spring Boot features and basic system design. The interviewer was professional throughout the interview, and the interview process felt more like a discussion, as compared to the standard interview process.
There was another round of coding - this time conducted by the organization itself. It consisted of a medium level DSA question on stacks. I wrote the code on my personal IDE and executed it there itself. The interviewer discussed about the possible edge cases and how I would deal with them. Post solving the question I was asked about my previous projects.
This was the final round where the discussion was largely around system design and HLD. It started off with questions are system design patterns and concepts. Then I was asked to design a booking design, with discussions around concurrency control and transaction management.
I applied via LinkedIn and was interviewed in Sep 2024. There were 4 interview rounds.
I have worked on developing and launching new mobile applications for a tech startup.
Led cross-functional teams to define product requirements
Conducted market research and user testing to inform product decisions
Worked closely with designers and engineers to bring products to market
Managed product roadmap and prioritized features based on user feedback
Take home assignment on a relevant problem statement for the organization
posted on 20 Sep 2024
I applied via Company Website and was interviewed in Aug 2024. There were 2 interview rounds.
First round 1.1 assessment test consist of total 30 questions in 30 minutes. Apti, technical questions, code snippet related questions.
Binary search has a time complexity of O(log n) where n is the number of elements in the array.
Time complexity is O(log n) as it divides the array in half at each step
Best case is O(1) when the element is found at the middle of the array
Worst case is O(log n) when the element is not present in the array
I applied via Company Website and was interviewed in Oct 2024. There was 1 interview round.
Asked to write a bank application - which includes adding,removing,transferring of money
I applied via Recruitment Consulltant and was interviewed in May 2024. There was 1 interview round.
I am fluent in three languages: English, Spanish, and French.
Fluent in English, Spanish, and French
Can communicate effectively in all three languages
Have experience working in multilingual environments
posted on 15 Nov 2024
I applied via Approached by Company and was interviewed in May 2024. There were 4 interview rounds.
Manager and one level above manager had discussion with my on why you want this job , why you are leaving current organization and want to join this organization. This type of questions were asked and discussion was of almost 30-40 minutes.
based on 14 reviews
Rating in categories
Stashfin
PrimeXBT
Rupifi
SmartOwner