Upload Button Icon Add office photos
Engaged Employer

i

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

HGS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

HGS SQL Database Administrator Interview Questions and Answers

Updated 6 Dec 2021

HGS SQL Database Administrator Interview Experiences

1 interview found

Interview Questionnaire 

1 Question

  • Q1. Multiple questions and basically

Interview Preparation Tips

Interview preparation tips for other job seekers - In online campus .in database in client support

Interview questions from similar companies

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Aptitude , reasoning, general questions

Round 2 - Technical 

(2 Questions)

  • Q1. What is spark architecture and partitions
  • Ans. 

    Spark architecture refers to the structure of Apache Spark framework, while partitions are units of data distribution for parallel processing.

    • Spark architecture includes components like Driver, Executor, and Cluster Manager

    • Partitions are units of data distribution for parallel processing in Spark RDDs

    • Increasing the number of partitions can improve parallelism and performance

    • Example: In Spark, data is divided into parti...

  • Answered by AI
  • Q2. What is rdd, trsnsformations
  • Ans. 

    RDD (Resilient Distributed Dataset) is a fundamental data structure in Apache Spark for distributed data processing. Transformations are operations that create a new RDD from an existing one.

    • RDD is a fault-tolerant collection of elements that can be operated on in parallel.

    • Transformations are functions that produce a new RDD by applying a computation on the existing RDD.

    • Examples of transformations include map, filter, ...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Salary expectations
  • Q2. Current ctc n expected ctc
  • Ans. 

    The current CTC (Cost to Company) and expected CTC (Cost to Company) are typically discussed during salary negotiations.

    • Be honest about your current salary and provide a realistic expectation for your future salary.

    • Consider factors such as your experience, skills, industry standards, and the company's budget when discussing CTC.

    • It is important to have a clear understanding of your worth and negotiate accordingly.

  • Answered by AI

Skills evaluated in this interview

SQL Database Administrator Interview Questions Asked at Other Companies

asked in TCS
Q1. What is a database management System and what is concept of prima ... read more
asked in TCS
Q2. Diff composite and non composite key and then to create primary k ... read more
asked in TechnoGen
Q3. how to create new users/ login, how to create new job, what are t ... read more
asked in TCS
Q4. Which programming language do you prefer and why?
asked in TCS
Q5. What is Maps, Hash maps, Skeleton class OOPS concepts?

Interview Questionnaire 

2 Questions

  • Q1. What can you do if company have no necessary of your work?
  • Q2. What benefit will you get to the company

Interview Questionnaire 

1 Question

  • Q1. Manual and SQL based questions... practical questins,like writing queries test cases etc.

What people are saying about HGS

View All
a team lead
1w
How to Identify Unplanned Leaves
There are different types of unplanned leaves, like health issue, family urgency, but how to takle death of relatives, specially Grandfather/ Grandmother passed away. I am not saying everyone lies but few take advantage of this, how to takle them.
Got a question about HGS?
Ask anonymously on communities.

Interview Questionnaire 

1 Question

  • Q1. To develop a product catalogue in core Java using Maven.
  • Ans. 

    Develop a product catalogue in core Java using Maven for efficient project management and dependency handling.

    • Set up a Maven project: Use 'mvn archetype:generate' to create a new project structure.

    • Define dependencies: Add necessary libraries in 'pom.xml', e.g., 'javax.persistence' for ORM.

    • Create entity classes: Define product attributes like 'id', 'name', 'description', and 'price'.

    • Implement CRUD operations: Use JPA or...

  • Answered by AI

Skills evaluated in this interview

I applied via Recruitment Consultant and was interviewed in Jan 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. I have attended as full stack developer and I have been asked questions on springs and java .

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and try to answer with elaborated explanation. Answer the questions as per your previous experiences.

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

Round 1 - Coding Test 

Coding test

Round 2 - Technical 

(1 Question)

  • Q1. Technical round was asked technical questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Basic should be strong in the programming language you know
Are these interview questions helpful?

I applied via Naukri.com and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. How much salary u want
  • Q2. I said as per industry standard

Interview Preparation Tips

Interview preparation tips for other job seekers - Nice interview, Average questions

I applied via Campus Placement and was interviewed before Sep 2020. There were 2 interview rounds.

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong basic knowledge about the topics in the resume

I applied via Naukri.com and was interviewed in Dec 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Introduction, roles and responsibilities, Features of sitecore, exm, sitecore database, e commerce and few other topics like scheduling, publishing, creating multilingual sites etc

Interview Preparation Tips

Interview preparation tips for other job seekers - This is for sitecore role.
Be confident and dictate.
Explain whatever you know.

HGS Interview FAQs

How to prepare for HGS SQL 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 HGS. The most common topics and skills that interviewers at HGS expect are AWS, Azure, Powershell, SQL and SSAS.

Tell us how to improve this page.

Interview Questions from Similar Companies

Teleperformance Interview Questions
3.9
 • 2k Interviews
WNS Interview Questions
3.3
 • 1.1k Interviews
Infosys BPM Interview Questions
3.6
 • 1k Interviews
iEnergizer Interview Questions
4.7
 • 784 Interviews
Omega Healthcare Interview Questions
3.7
 • 477 Interviews
R1 RCM Interview Questions
3.8
 • 318 Interviews
Sagility Interview Questions
3.9
 • 212 Interviews
View all
HGS SQL Database Administrator Salary
based on 4 salaries
₹1 L/yr - ₹3.4 L/yr
73% less than the average SQL Database Administrator Salary in India
View more details

HGS SQL Database Administrator Reviews and Ratings

based on 2 reviews

1.3/5

Rating in categories

4.1

Skill development

2.2

Work-life balance

3.2

Salary

4.1

Job security

5.0

Company culture

3.2

Promotions

5.0

Work satisfaction

Explore 2 Reviews and Ratings
Senior Process Consultant
1.9k salaries
unlock blur

₹2 L/yr - ₹5 L/yr

Process Consultant
1.5k salaries
unlock blur

₹1.6 L/yr - ₹4 L/yr

Process Associate
825 salaries
unlock blur

₹1.7 L/yr - ₹4 L/yr

Customer Relation Officer
672 salaries
unlock blur

₹1.2 L/yr - ₹3.5 L/yr

Associate
549 salaries
unlock blur

₹1.6 L/yr - ₹5.1 L/yr

Explore more salaries
Compare HGS with

Teleperformance

3.9
Compare

Concentrix Corporation

3.7
Compare

iEnergizer

4.7
Compare

WNS

3.3
Compare
write
Share an Interview