Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by CAMS Team. If you also belong to the team, you can get access from here

CAMS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

CAMS SQL Server Database Administrator Interview Questions and Answers

Updated 16 Feb 2025

CAMS SQL Server Database Administrator Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
Easy
Process Duration
More than 8 weeks
Result
Selected Selected

I was interviewed before Feb 2024.

Round 1 - HR 

(1 Question)

  • Q1. Tell about urself
Round 2 - Technical 

(2 Questions)

  • Q1. Basic of sql & queries
  • Q2. Advance excel

Interview Preparation Tips

Interview preparation tips for other job seekers - worst experiance in cams

Interview questions from similar companies

I applied via Referral and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Basics of sql
  • Q2. Basics of BA
  • Q3. Daily day routine

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest with the interviewer. Explain 100% what you know and in which you have experience.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Medium leetcode question on array list

Round 2 - One-on-one 

(4 Questions)

  • Q1. Core java and collections, exceptions and threading
  • Q2. Core java collections
  • Q3. Multi threading
  • Q4. Executor framework
Round 3 - One-on-one 

(1 Question)

  • Q1. Threading related questions
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Hackathon Test with 2 medium level coding question.

Round 2 - Coding Test 

Technical Video Interview- Java concepts mostly related to Java 8, 1 coding program and some db questions were asked.

Round 3 - Technical 

(1 Question)

  • Q1. Questions related to System Design.
Round 4 - Behavioral 

(1 Question)

  • Q1. Questions related to my projects . Some questions related to my current role and responsibilities.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Basic java questions and 2 DSA medium level problems
  • Q2. Two sum leet code problem
Round 2 - Technical 

(1 Question)

  • Q1. Design round. Design a system that send notification’s to all the passengers of trains just when the train arrives at the station next to it. And one question on tree LCA
  • Ans. 

    Design a system to send notifications to train passengers when the train arrives at the next station.

    • Use GPS tracking to determine train location in real-time

    • Implement a notification system that sends alerts to passengers' devices

    • Integrate with train schedule data to know when the train is approaching the next station

  • Answered by AI

I applied via Referral and was interviewed in Apr 2022. There were 4 interview rounds.

Round 1 - Coding Test 

Asked basic questions .... To check concept and logic

Round 2 - Technical 

(2 Questions)

  • Q1. SQL query for------ deleting duplicate from table
  • Q2. SQL query for second highest salary
  • Ans. 

    SQL query to find second highest salary

    • Use ORDER BY and LIMIT to get the highest salary

    • Use subquery to exclude the highest salary and get the second highest

  • Answered by AI
Round 3 - HR 

(1 Question)

  • Q1. Basic information and documents verification
Round 4 - Candidate engagement round 

(1 Question)

  • Q1. Roles and responsibilities and queries solving .

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep on learning new concepts,try to solve complex problems which helps in improving logic.

Provide valid information in resume.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
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 - Coding Test 

Medium leetcode problem on array and linked list. And some theoretical questions

Round 3 - One-on-one 

(1 Question)

  • Q1. Core java , collections, object oriented principles . Some small coding questions based on usage of overriding and overloading
Round 4 - One-on-one 

(1 Question)

  • Q1. Multi treading and 1 problem solving question.
Round 5 - One-on-one 

(1 Question)

  • Q1. Discussion with ED : expectations and managerial questions
Round 6 - HR 

(1 Question)

  • Q1. Typical HR questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Do understand Core java concepts in depth and problems solving skills - leetcode or hackerrank . Do solve easy to medium stuff
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Sep 2022. There were 5 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Array related problem
Round 3 - Technical 

(1 Question)

  • Q1. C# oops related deep question
Round 4 - Technical 

(1 Question)

  • Q1. Project Design related questions
Round 5 - Technical 

(1 Question)

  • Q1. SQL Linq mvc net core related questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I was interviewed before Mar 2024.

Round 1 - Coding Test 

Some questions that range from easy to medium level.

Round 2 - Technical 

(2 Questions)

  • Q1. General questions around your resume, the tech stacks you worked on, fundamentals and deepdive into that.
  • Q2. High level system design
  • Ans. 

    High level system design involves creating an overall architecture for a software system.

    • Identify the main components of the system

    • Define the interactions between components

    • Consider scalability, reliability, and performance

    • Use diagrams like UML to visualize the design

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

(1 Question)

  • Q1. Can you describe your experience, the projects you have worked on, challenges you solved and other stuffs around that.
  • Ans. 

    I have extensive experience working on various software projects, overcoming challenges and delivering successful solutions.

    • Developed a web application for a healthcare company to streamline patient data management

    • Implemented a real-time messaging feature in a social media platform to improve user engagement

    • Optimized database queries to improve performance of an e-commerce website

    • Collaborated with cross-functional team...

  • Answered by AI
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion
Interview experience
3
Average
Difficulty level
-
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Sep 2022. There were 3 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 - Case Study 

How would you approach performance issues in an application module

Round 3 - Technical 

(1 Question)

  • Q1. How would you process millions of records in an excel file
  • Ans. 

    Use programming language to read and process data from Excel file efficiently.

    • Use a programming language like Python, Java, or C# to read the Excel file.

    • Utilize libraries like pandas in Python or Apache POI in Java for efficient data processing.

    • Implement batch processing or parallel processing to handle millions of records efficiently.

    • Optimize code for memory management and performance to avoid crashes or slowdowns.

    • Con...

  • Answered by AI

Skills evaluated in this interview

CAMS Interview FAQs

How many rounds are there in CAMS SQL Server Database Administrator interview?
CAMS interview process usually has 2 rounds. The most common rounds in the CAMS interview process are HR and Technical.
How to prepare for CAMS SQL Server Database Administrator 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 CAMS. The most common topics and skills that interviewers at CAMS expect are Performance Tuning, Replication, SQL Server Dba, SQL Server and Cloud.
What are the top questions asked in CAMS SQL Server Database Administrator interview?

Some of the top questions asked at the CAMS SQL Server Database Administrator interview -

  1. basic of sql & quer...read more
  2. advance ex...read more

Tell us how to improve this page.

CAMS SQL Server Database Administrator Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more

Interview Questions from Similar Companies

Citicorp Interview Questions
3.7
 • 564 Interviews
Wells Fargo Interview Questions
3.8
 • 563 Interviews
HSBC Group Interview Questions
4.0
 • 484 Interviews
American Express Interview Questions
4.2
 • 358 Interviews
BNY Interview Questions
3.9
 • 341 Interviews
UBS Interview Questions
3.9
 • 331 Interviews
Morgan Stanley Interview Questions
3.7
 • 291 Interviews
Morningstar Interview Questions
3.9
 • 241 Interviews
View all
Assistant Processing Officer
653 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Processing Officer
591 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Executive
396 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Process Officer
366 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Support Officer
284 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare CAMS with

KFintech

3.5
Compare

Franklin Templeton Investments

4.1
Compare

Sundaram BNP Paribas Fund Services

3.9
Compare

CAMS Investor Services

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