Add office photos
Filter interviews by
Rikhav Securities Interview Questions and Answers
Rikhav Securities Interview Experiences
1 interview found
Lakshmi Lugade
Selected
I applied via Recruitment Consulltant and was interviewed before May 2023. There was 1 interview round.
(1 Question)
- Q1. Attendance management recruitment onboarding process salary process
Interview Preparation Tips
Senior HR Executive Interview Questions asked at other Companies
Interview questions from similar companies
Artyom Yeprikyan
I applied via Approached by Company and was interviewed in Oct 2024. There were 4 interview rounds.
(3 Questions)
- Q1. Salary Expectation
- Q2. Work Experience
- Q3. Relocation Plans
Codility Test General C# and SQL
(9 Questions)
- Q1. (live coding) Create a class Employees with fields FirstName LastName, DoB, and Gender Return avg age of employees, return avg age by genders
- Ans.
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
- Q2. What design pattern you know
- Ans.
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...
- Q3. SOLID principles
- Q4. How to optimize SQL Queries
- Ans.
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
- Q5. Which type of Indexes you know
- Ans.
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...
- Q6. Have you ever read SQL Execution Plan?
- Ans.
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
- Q7. .NET Framework DI 3th party tools
- Q8. Are you familiar with MSUnit, xUnit, nUnit
- Q9. Unit Testing libraries (e.g Bogus, Moq..)
(3 Questions)
- Q1. What questions do you have?
- Q2. How was your interview's?
- Q3. Why you want to change your job?
Interview Preparation Tips
Skills evaluated in this interview
Anonymous
I applied via Campus Placement
It was a MCQ test on CS Fundamentals. We have to answer 50 questions in 40 minutes. Accuracy is must. Company have its own cutoff and it's usually high. So try to gain maximum marks as possible. The results were announced in 1.5 hrs. The selected candidates will be appearing for the coding challenge.
There are 5 questions. 1 easy , 3 medium, 1 hard. You should solve atleast 4 questions to get shortlisted for the interview. Results are announced in 2-3 hours. Take a look at these questions. One of the questions from the coding challenge will be asked in the interview.
(5 Questions)
- Q1. Email validation question from coding challenge
- Q2. Binary Search on rotated arrays
- Ans.
Binary search on rotated arrays involves finding a target value in a sorted array that has been rotated at an unknown pivot point.
Identify the pivot point by finding the minimum element in the array.
Determine which half of the array the target value falls into based on the pivot point.
Perform binary search on the appropriate half of the array to find the target value.
- Q3. About projects (reason behind using the mentioned database)
- Q4. Use of package.json file
- Ans.
package.json file is used in Node.js projects to manage dependencies, scripts, and metadata.
Contains project metadata like name, version, description, etc.
Lists dependencies required for the project to run.
Defines scripts for tasks like building, testing, and running the project.
Can include configurations for tools like ESLint, Babel, etc.
- Q5. What are scripts in package.json file
- Ans.
Scripts in package.json file are commands that can be run using npm.
Scripts are defined under the 'scripts' key in package.json.
Common scripts include 'start', 'test', 'build', etc.
Scripts can be run using 'npm run
'.
Interview Preparation Tips
Skills evaluated in this interview
Selected
(1 Question)
- Q1. I have around 9 rounds interview in span of 2 months
(1 Question)
- Q1. Everyday one round interview
(1 Question)
- Q1. Same as above .it is too much
(1 Question)
- Q1. Same as above .it is too much
(1 Question)
- Q1. Same only .it is too much
4 member team interview
(1 Question)
- Q1. One on one interview
(1 Question)
- Q1. Reference . through referral I sent my resume
(1 Question)
- Q1. Salary discussion
(1 Question)
- Q1. It is too much
(2 Questions)
- Q1. Graph theory questions related
- Q2. Programming,data structure and algo
(2 Questions)
- Q1. Intro about your self
- Q2. Mostly focused on CSE fundamentals
I applied via Job Portal and was interviewed in Oct 2024. There was 1 interview round.
(3 Questions)
- Q1. SQL question ( window functions) dense_rank
- Q2. SQL question(window function) aggregation, there were 5 tables and you had to do some joins
- Q3. Some question on spark optimisations
Interview Preparation Tips
Selected
I applied via Referral and was interviewed in May 2024. There were 5 interview rounds.
(3 Questions)
- Q1. Tell me about yourself?
- Q2. Why did you living your current organization?
- Q3. What is your expected CTC?
- Ans.
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
Research industry standards for similar positions
Consider cost of living in the area
Factor in benefits and bonuses offered by the company
Be prepared to negotiate based on your value to the organization
(7 Questions)
- Q1. Tell me about yourself?
- Ans.
I am a results-driven executive with over 10 years of experience in leading teams and driving business growth.
Experienced executive with a proven track record of success
Skilled in team leadership and business development
Strong focus on achieving results and driving growth
- Q2. Why did you living your current organization?
- Q3. How did you manage the night shift and traveling?
- Ans.
I managed the night shift and traveling by prioritizing rest, staying organized, and utilizing technology.
Prioritized rest by ensuring adequate sleep during the day
Stayed organized by planning ahead and packing essentials in advance
Utilized technology for efficient communication and navigation while traveling
- Q4. What do you know about the EXL?
- Ans.
EXL is a leading operations management and analytics company that helps businesses improve performance.
EXL offers services in areas such as finance and accounting, healthcare, insurance, and more
They use advanced analytics and technology to drive business transformation
EXL has a global presence with offices in multiple countries
- Q5. What is Insurance?
- Ans.
Insurance is a financial product that provides protection against potential risks and losses.
Insurance involves an agreement between an individual or entity and an insurance company.
The individual or entity pays a premium in exchange for coverage against specific risks, such as property damage, illness, or liability.
Examples of insurance include health insurance, car insurance, life insurance, and property insurance.
- Q6. What do you know about the premium?
- Ans.
Premium refers to the amount of money an individual or business pays for an insurance policy.
Premium is the cost of purchasing an insurance policy
It is typically paid on a regular basis, such as monthly or annually
The premium amount is determined by factors such as the type of insurance, coverage amount, and the individual's risk profile
- Q7. What is your current CTC and expectation?
- Ans.
My current CTC is $100,000 and I am looking for a 15% increase in my next role.
Current CTC: $100,000
Expectation: 15% increase
Looking for opportunities in the range of $115,000 - $120,000
Aptitude test to check grammar and English fluency. It has different types of questions like passage reading and give the answers of questions from the passage, email writing, essay, grammar sections with fill in the blanks and picture based scenario in which you have to write the steps.
(2 Questions)
- Q1. Speed minimum 30.
- Q2. Accuracy minimum 90 percent.
(2 Questions)
- Q1. Discussion about the salary.
- Q2. Fixing the package.
Interview Preparation Tips
(5 Questions)
- Q1. Salary why not time being paid ?
- Q2. Without any evidence how blaming staff ??
- Ans.
Blaming staff without evidence is unprofessional and can damage morale and trust within the team.
Avoid jumping to conclusions without concrete evidence
Encourage open communication and transparency
Focus on problem-solving rather than assigning blame
Provide constructive feedback and support to help staff improve
Lead by example and take responsibility for mistakes
- Q3. Company always carried out theft staff ?
- Q4. No one professional staff in office and overall company ??
- Q5. Why directors board unseen to thefts??
- Ans.
Directors may not always be aware of thefts due to lack of oversight, trust in employees, or focus on other priorities.
Directors may not be directly involved in day-to-day operations where thefts occur
There may be a lack of proper oversight or monitoring mechanisms in place
Directors may trust their employees and not suspect them of theft
Directors may be focused on other strategic priorities and not pay attention to pot
Interview Preparation Tips
Hr team non capable and non educated people
I applied via Company Website and was interviewed in Jun 2024. There were 3 interview rounds.
Coding Test consists of 3 Problem Question (2 Logical questions and 1 SQL Query ) and Around 20 MCQS
Platform - CoderByte
30 Aptitude Question
3 Mail Writing Question
(5 Questions)
- Q1. Explain 1st Problem Solved in Coding Test. Optimize it.
- Ans.
Solved a sorting problem by implementing quicksort algorithm.
Implemented quicksort algorithm to efficiently sort the array.
Used recursion to divide the array into smaller subarrays and sort them individually.
Optimized the algorithm by choosing a pivot element strategically to minimize comparisons.
- Q2. Explain 2nd Problem Solved in Coding Test. I failed 1 test case in 1st round which was told to solve again.
- Q3. Explain 3rd Question based on SQL Query.
- Ans.
The 3rd question based on SQL query likely refers to a specific query or scenario related to SQL.
Understand the context of the query being asked about
Analyze the structure and purpose of the SQL query
Explain the expected output or result of the query
- Q4. Write a code to Reverse Digits.
- Ans.
Code to reverse digits of a number
Use modulo operator to extract the last digit of the number
Multiply the result by 10 and add the next digit until all digits are reversed
Handle negative numbers separately by converting to positive before reversing
- Q5. A problem question for solving a SQL Query.
Interview Preparation Tips
Stay continuously in contact, call the HR for updates as they don't call you, We need to call them else you will wait entire life.
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
The Hiring team and the trial team is very supportive, and the trial assignment was challenging and enjoyable. At First round the assignment is for design the Ai chat to Human chat process, that was very challenging, and I think best lesson I get from the assignment. and 2nd assignment to design and case study of the helplama website and i give best from my side and the team was very supportive and the work environment also best.
Rikhav Securities Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Executive Interview Questions
- Team Lead Interview Questions
- Software Developer Interview Questions
- Intern Interview Questions
- Senior Associate Interview Questions
- Sales Executive Interview Questions
- Associate Software Engineer Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Show more
Interview Questions from Similar Companies
Rikhav Securities Reviews and Ratings
based on 10 reviews
Rating in categories
|
Executive Accountant
6
salaries
|  ₹1.5 L/yr - ₹3 L/yr |
|
Accountant
4
salaries
| ₹1.1 L/yr - ₹3 L/yr |
|
HR Executive
4
salaries
| ₹3 L/yr - ₹4.2 L/yr |
|
Account Assistant
4
salaries
| ₹1 L/yr - ₹3 L/yr |
|
Manager
3
salaries
| ₹4.2 L/yr - ₹7.2 L/yr |
Exl India
Amazon Sellers Services
Primus Global Technologies
GAMMON INDIA
Calculate your in-hand salary
- Home >
- Interviews >
- Rikhav Securities Interview Questions
