Upload Button Icon Add office photos

Filter interviews by

Anand Rathi Information Technology Interview Questions and Answers

Updated 12 Mar 2025

Anand Rathi Information Technology Interview Experiences

Popular Designations

5 interviews found

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
  • Q1. Core java related
  • Q2. Domain related queries

Java Developer Interview Questions asked at other Companies

Q1. Sort 0 and 1 Problem Statement Given an integer array ARR of size N containing only integers 0 and 1, implement a function to sort this array. The solution should scan the array only once without using any additional arrays. Input: The firs... read more
View answer (4)

SQL Developer Interview Questions & Answers

user image Anonymous

posted on 18 Apr 2024

Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Different types of SQL Joins
  • Ans. 

    Different types of SQL Joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • INNER JOIN: Returns rows when there is at least one match in both tables.

    • LEFT JOIN: Returns all rows from the left table and the matched rows from the right table.

    • RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table.

    • FULL JOIN: Returns rows when there is a match in one of the tables.

  • Answered by AI
  • Q2. Difference between Stored Procedures and Functions
  • Ans. 

    Stored Procedures are used to perform a set of actions, while Functions return a value.

    • Stored Procedures can perform multiple actions and may or may not return a value

    • Functions always return a value and are used for calculations or data retrieval

    • Stored Procedures can have input/output parameters, while Functions only have input parameters

    • Stored Procedures are called using EXECUTE command, while Functions are called in

  • Answered by AI
Round 2 - One-on-one 

(1 Question)

  • Q1. Additional skills apart from database. Regarding C# and Web APIs
Round 3 - HR 

(1 Question)

  • Q1. Salary expectation

Interview Preparation Tips

Topics to prepare for Anand Rathi Information Technology SQL Developer interview:
  • HTML
  • CSS
  • C#.Net
  • API
  • SQL
Interview preparation tips for other job seekers - You should have skills in SQL, HTML, CSS, C# APIs. Study from W3 Schools before taking interview. Be confident. If you don't know answer to a question say positively, that currently I don't know but i'll search and let you know. Then you're good to go.

Skills evaluated in this interview

SQL Developer Interview Questions asked at other Companies

Q1. How is a change request in application serviced by development team (business analysis, code analysis, discussion with BA, requirment freeze, etc.)
View answer (4)

Developer Interview Questions & Answers

user image Paritosh Prasad

posted on 10 Jul 2022

I applied via Naukri.com and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. What is MVC ? What is routing ? When we use finally block
  • Ans. 

    MVC is a software architecture pattern. Routing is the process of directing HTTP requests to the appropriate controller. Finally block is used to execute code after a try-catch block.

    • MVC stands for Model-View-Controller

    • Routing is used to map URLs to specific actions in a controller

    • Finally block is used to ensure that a section of code is always executed, even if an exception is thrown

  • Answered by AI
  • Q2. Using keywords, difference between view data and view bag, can we possess temp data, which exception used without try and catch block and exception handling

Interview Preparation Tips

Interview preparation tips for other job seekers - Please learn about c# and MVC and SQL server

Skills evaluated in this interview

Developer Interview Questions asked at other Companies

Q1. Which programming language do you use regular in work
View answer (2)

I applied via Referral and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Basics of oops and databse related questions and programming concepts.

Interview Preparation Tips

Interview preparation tips for other job seekers - Great place to learn and work on lattest technologies. Work culture is upto the mark and process of development is as like as multinational comapanies. I got the oppotunity to work here and I learned a lot here.

Developer Associate Interview Questions asked at other Companies

Q1. Cycle Detection in a Singly Linked List Determine if a given singly linked list of integers forms a cycle or not. A cycle in a linked list occurs when a node's next points back to a previous node in the list. Thus, the list does not have a ... read more
View answer (1)

Anand Rathi Information Technology interview questions for popular designations

 Graduate Engineer Trainee (Get)

 (1)

 Java Developer

 (1)

 SQL Developer

 (1)

 Developer Associate

 (1)

 Developer

 (1)

I applied via Company Website and was interviewed before Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Basic Oop Fundamental.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was quite simple,In technical round they asked Basic Oop questions,project stuff etc.

Graduate Engineer Trainee (Get) Interview Questions asked at other Companies

Q1. Q: 1 What is IC engine? What is the types of IC engine? Q:2 Difference between Otto cycle and Diesel cycle? What is the process of both cycle and what is the effeciency of both cycle ? Which one is good in effeciency? Q:3 Difference between... read more
View answer (2)

Interview questions from similar companies

I appeared for an interview before Mar 2021.

Round 1 - Coding Test 

(2 Questions)

Round duration - 75 minutes
Round difficulty - Medium

This was an online coding round where we had 2 questions to solve under 75 minutes. I found both the questions to be of Easy to Medium level of difficulty.

  • Q1. 

    Line Reflection Problem Statement

    You are given several sets of points on a 2D plane, each set represented as a list of coordinates. Your task is to determine if there exists a line parallel to the Y-axis...

  • Ans. 

    The task is to determine if there exists a line parallel to the Y-axis that reflects given points symmetrically.

    • Iterate through each test case and check if a vertical reflection line exists for the given points

    • Calculate the midpoint of the x-coordinates and check if it reflects the points symmetrically

    • Consider edge cases where points are on the reflection line or have the same x-coordinate

  • Answered by AI
  • Q2. 

    Number of Islands Problem Statement

    You are provided with a 2-dimensional matrix having N rows and M columns, containing only 1s (land) and 0s (water). Your goal is to determine the number of islands in t...

  • Ans. 

    Count the number of islands in a 2D matrix of 1s and 0s.

    • Iterate through the matrix and perform depth-first search (DFS) to find connected 1s.

    • Mark visited cells to avoid redundant traversal.

    • Increment island count whenever a new island is encountered.

  • Answered by AI
Round 2 - Face to Face 

(4 Questions)

Round duration - 60 minutes
Round difficulty - Medium

This round had 2 coding questions followed by some questions from DBMS.

  • Q1. 

    Largest Rectangle in Histogram Problem Statement

    You are given an array/list HEIGHTS of length N, where each element represents the height of a histogram bar. The width of each bar is considered to be 1.

    ...
  • Ans. 

    Find the area of the largest rectangle that can be formed within the bounds of a given histogram.

    • Iterate through the histogram bars and calculate the area of the largest rectangle that can be formed using each bar as the height.

    • Use a stack to keep track of the indices of the bars in non-decreasing order of height.

    • Pop elements from the stack and calculate the area until a smaller height bar is encountered.

    • Update the max...

  • Answered by AI
  • Q2. 

    Valid Parentheses Problem Statement

    Given a string 'STR' consisting solely of the characters “{”, “}”, “(”, “)”, “[” and “]”, determine if the parentheses are balanced.

    Input:

    The first line contains an...
  • Ans. 

    The task is to determine if a given string consisting of parentheses is balanced or not.

    • Iterate through the characters of the string and use a stack to keep track of opening parentheses.

    • If an opening parenthesis is encountered, push it onto the stack.

    • If a closing parenthesis is encountered, check if it matches the top of the stack. If it does, pop the stack, else the string is not balanced.

    • At the end, if the stack is e...

  • Answered by AI
  • Q3. Can you explain the concept of ACID properties in DBMS?
  • Ans. 

    ACID properties in DBMS ensure data integrity and consistency in transactions.

    • Atomicity: All operations in a transaction are completed successfully or none at all.

    • Consistency: Data is always in a valid state before and after a transaction.

    • Isolation: Transactions are isolated from each other to prevent interference.

    • Durability: Once a transaction is committed, changes are permanent and survive system failures.

    • Example: If...

  • Answered by AI
  • Q4. Can you explain the different levels of data abstraction in a DBMS?
  • Ans. 

    Levels of data abstraction in a DBMS refer to the different views of data provided to users and applications.

    • Physical level: Deals with how data is stored on the storage media. Example: data blocks, pages, indexes.

    • Logical level: Focuses on how data is represented to users. Example: tables, views, constraints.

    • View level: Provides a customized view of the database for specific users or applications. Example: queries, rep

  • Answered by AI
Round 3 - Face to Face 

(4 Questions)

Round duration - 60 minutes
Round difficulty - Medium

Standard DS/Algo round with 2 coding questions followed by 2 interesting puzzles.

  • Q1. 

    Cycle Detection in Undirected Graph Problem Statement

    You are provided with an undirected graph containing 'N' vertices and 'M' edges. The vertices are numbered from 1 to 'N'. Your objective is to determi...

  • Ans. 

    Detect if an undirected graph contains a cycle by exploring all possible paths.

    • Use Depth First Search (DFS) algorithm to traverse the graph and detect cycles.

    • Maintain a visited set to keep track of visited vertices and a parent pointer to avoid visiting the same vertex twice.

    • If a visited vertex is encountered that is not the parent of the current vertex, a cycle is present.

    • Consider edge cases like disconnected graphs a

  • Answered by AI
  • Q2. 

    Maximum 1s in a Row Problem

    Given a matrix ARR with dimensions N * M, consisting only of 0s and 1s where each row is sorted, determine the index of the row that contains the highest number of 1s. If multi...

  • Ans. 

    Find the row with the maximum number of 1s in a sorted matrix.

    • Iterate through each row of the matrix and count the number of 1s in each row

    • Keep track of the row index with the maximum number of 1s

    • Return the index of the row with the highest count of 1s

  • Answered by AI
  • Q3. You have two wires of different lengths, each taking different amounts of time to burn completely. How can you use these wires to measure a specific duration of time?
  • Ans. 

    By lighting both wires at the same time, the shorter wire will burn out first, allowing you to measure a specific duration of time.

    • Light both wires at the same time

    • Measure the time it takes for the shorter wire to burn out completely

    • The remaining length of the longer wire will indicate the specific duration of time

  • Answered by AI
  • Q4. You have 3 ants located at the corners of a triangle. The challenge is to determine the movement pattern of the ants if they all start moving towards each other. What will be the outcome?

Interview Preparation Tips

Eligibility criteriaAbove 7 CGPASapient Corporation interview preparation:Topics to prepare for the interview - Data Structures, Algorithms, DBMS, OS, Aptitude, OOPSTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Referral and was interviewed before Jul 2021. There was 1 interview round.

Round 1 - HR 

(1 Question)

  • Q1. About yourself and technology you know

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident in every situation and ready to face the situation

Interview Questionnaire 

3 Questions

  • Q1. Inevitable consisted of 4 round :-
  • Q2. One such question i remember was no of possible decoding of a given integer string. Ex - If a-1, b-2, c-3, ... Z - 26 Then 123 can be written as ABC, LC, AW
  • Q3. 3) MCQ - it consisted of multiple choice questions from android and java domain. The level was medium. 4) Manager round - asked questions about my project and technologies used. Gave me a problem relate...

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice Algorithms

Interview Questionnaire 

1 Question

  • Q1. Sharepoint

I applied via Naukri.com and was interviewed before Aug 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. I interviewed here for Fidelity, so bith technical rounds were conducted by Fidelity associates. They asked me deeper as well as common questions from Power Bi and SQL query writing.

Interview Preparation Tips

Interview preparation tips for other job seekers - Interviewer i got was very cooperative and engaging as well as appreciative.

Anand Rathi Information Technology Interview FAQs

How many rounds are there in Anand Rathi Information Technology interview?
Anand Rathi Information Technology interview process usually has 2 rounds. The most common rounds in the Anand Rathi Information Technology interview process are Technical, One-on-one Round and Resume Shortlist.
How to prepare for Anand Rathi Information Technology interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Anand Rathi Information Technology. The most common topics and skills that interviewers at Anand Rathi Information Technology expect are Relationship Management, OOPS, Postgresql, SQL and .Net.
What are the top questions asked in Anand Rathi Information Technology interview?

Some of the top questions asked at the Anand Rathi Information Technology interview -

  1. What is MVC ? What is routing ? When we use finally bl...read more
  2. Difference between Stored Procedures and Functi...read more
  3. Different types of SQL Jo...read more

Tell us how to improve this page.

Anand Rathi Information Technology Interview Process

based on 2 interviews

Interview experience

3.5
  
Good
View more

Interview Questions from Similar Companies

Cognizant Interview Questions
3.7
 • 5.6k Interviews
Nagarro Interview Questions
4.0
 • 762 Interviews
Publicis Sapient Interview Questions
3.5
 • 618 Interviews
GlobalLogic Interview Questions
3.6
 • 591 Interviews
UST Interview Questions
3.8
 • 514 Interviews
CGI Group Interview Questions
4.0
 • 490 Interviews
View all

Anand Rathi Information Technology Reviews and Ratings

based on 70 reviews

3.5/5

Rating in categories

3.3

Skill development

3.5

Work-life balance

2.9

Salary

4.0

Job security

3.6

Company culture

2.7

Promotions

3.1

Work satisfaction

Explore 70 Reviews and Ratings
PCG desk advisor

New Delhi

2-5 Yrs

Not Disclosed

Product Manager- Investment AUM

Mumbai

4-7 Yrs

Not Disclosed

PCG - Advisor

Mumbai

2-6 Yrs

Not Disclosed

Explore more jobs
Software Developer
24 salaries
unlock blur

₹1 L/yr - ₹8.2 L/yr

Developer Associate
21 salaries
unlock blur

₹1.5 L/yr - ₹2.5 L/yr

Developer
14 salaries
unlock blur

₹2 L/yr - ₹6.3 L/yr

Officer
13 salaries
unlock blur

₹1.3 L/yr - ₹2.1 L/yr

Java Developer
10 salaries
unlock blur

₹1.9 L/yr - ₹4.5 L/yr

Explore more salaries
Compare Anand Rathi Information Technology with

Cognizant

3.7
Compare

Sutherland Global Services

3.6
Compare

Optum Global Solutions

4.0
Compare

Hexaware Technologies

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview