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
3.9

based on 6.8k Reviews

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

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

Interview Questionnaire 

2 Questions

  • Q1. What is the next steps
  • Ans. 

    The next steps depend on the current task or project at hand.

    • Assess the current status of the project

    • Identify any potential roadblocks or challenges

    • Develop a plan of action to address any issues

    • Communicate with stakeholders and team members

    • Execute the plan and monitor progress

    • Document any changes or updates

    • Continuously evaluate and improve the system

  • Answered by AI
  • Q2. When is the interview date and time

Interview Preparation Tips

Interview preparation tips for other job seekers - I have an extensive knoledge inthe administration of the microsoft SQL server FIELD AND HAVE THE SPECIFIC SKILLS YOU ARE LOOKING FOR

I applied via Naukri.com and was interviewed in Oct 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Prepare basic

Interview Preparation Tips

Interview preparation tips for other job seekers - Just focus on basics of sql

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.

Fast track your campus placements

View all
HGS SQL Database Administrator Salary
based on 5 salaries
₹1 L/yr - ₹3.8 L/yr
75% 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 & Benefits

4.1

Job Security

5.0

Company culture

3.2

Promotions/Appraisal

5.0

Work Satisfaction

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

₹1.2 L/yr - ₹5 L/yr

Process Consultant
1.6k salaries
unlock blur

₹1 L/yr - ₹4.8 L/yr

Process Associate
881 salaries
unlock blur

₹1.2 L/yr - ₹4.5 L/yr

Customer Relation Officer
752 salaries
unlock blur

₹0.9 L/yr - ₹6 L/yr

Senior Process Associate
525 salaries
unlock blur

₹1.7 L/yr - ₹5 L/yr

Explore more salaries
Compare HGS with

WNS

3.4
Compare

Teleperformance

3.9
Compare

Concentrix Corporation

3.8
Compare

Genpact

3.9
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview