Upload Button Icon Add office photos

HCL Infosystems

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

HCL Infosystems SQL Developer Interview Questions and Answers

Updated 6 Jul 2024

HCL Infosystems SQL Developer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(2 Questions)

  • Q1. Tell about your self
  • Ans. 

    Experienced SQL Developer with strong knowledge in database management and optimization.

    • Over 5 years of experience in SQL development

    • Proficient in writing complex SQL queries and stored procedures

    • Skilled in database performance tuning and optimization

    • Familiar with ETL processes and data warehousing

    • Certified in SQL Server administration

  • Answered by AI
  • Q2. Interested Technology
Round 2 - Technical 

(2 Questions)

  • Q1. What is SQL where it use
  • Ans. 

    SQL is a programming language used for managing and manipulating relational databases.

    • SQL stands for Structured Query Language

    • It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables

    • Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE

  • Answered by AI
  • Q2. What is Join and Procedure
  • Ans. 

    Join is used to combine rows from two or more tables based on a related column, while Procedure is a set of SQL statements that perform a specific task.

    • Join is used to retrieve data from multiple tables based on a related column

    • Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Procedure is a set of SQL statements stored in the database and executed when called

    • Procedures can accept input parameters

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Company Website and was interviewed before Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions on Java,SQL,some trending technologies(IOT,Big data),pattern questions, programming questions with different approaches.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of DSA, have knowledge about the databases, some common dml ,ddl statements, programming knowledge of a particular language like C,Java, python,etc...have good command on oops concepts... little bit of frameworks knowledge will also help

I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.

Round 1 - Aptitude Test 
Round 2 - Technical 

(1 Question)

  • Q1. Basic questions of java.
Round 3 - HR 

(1 Question)

  • Q1. Intro and other hr related questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - Cover the basic questions regarding the programming language.

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

Round 1 - Aptitude Test 

Puzzles, Psychometric Test

Round 2 - One-on-one 

(1 Question)

  • Q1. Some water in 3 Jars question, you had to measure out 5L correctly

Interview Preparation Tips

Interview preparation tips for other job seekers - Make the interview interactive, I got this input from another Senior. Before i went into the interview room the volunteers were telling all those who goes into Room No 1 is screwed. I was praying i don't get room no 1. But fortunately for me I got room no 1 because when the interviewer gave me the puzzle and handed over pen and paper he went back to relax his posture and when i explained i will fill the 5L Jar first, he immediately came forward to listen to me, at that moment i knew i got the job because i felt the previous candidates never made their interview interactive and that's why he went back to relax his posture.

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

Round 1 - Aptitude Test 

First round was coding as well as aptitude done together went well I guess focusing on codes helps a lot.

Round 2 - Technical 

(1 Question)

  • Q1. 2nd round included tr and mr round went quite enegritic

Interview Preparation Tips

Interview preparation tips for other job seekers - Resume skills matters a lot don't fill resume the technologies you don't even aware of

I was interviewed in Sep 2016.

Interview Questionnaire 

3 Questions

  • Q1. Tell me about yourself
  • Ans. 

    I am a passionate software developer with experience in Java, Python, and web development.

    • Experienced in Java, Python, and web development technologies

    • Strong problem-solving skills and ability to work in a team

    • Completed multiple projects including a web-based inventory management system

  • Answered by AI
  • Q2. Simple coding questions..Basically pattern.
  • Q3. And also they will ask about your projects.

Interview Preparation Tips

Round: Test
Experience: 60 multiple choice questions so have to manage time carefully.
Tips: Have to give equal importance to all the sections..So try to do well in all section.
Duration: 1 hour 30 minutes
Total Questions: 60

Round: Technical + HR Interview
Experience: Don't panic...Only write those things that you know in your resume.

Skills: Smart Coding
College Name: Jaypee Institute Of Information Technology, Noida

I was interviewed in May 2017.

Interview Preparation Tips

Round: Test
Total Questions: 20

Round: Group Discussion
Duration: 1 hour

Skills: Coding Skills And Knowledge On Data Structures

I was interviewed in Jun 2017.

Interview Preparation Tips

Round: Test
Duration: 1 hour 30 minutes

Skills: Engineering Basics

I was interviewed in May 2017.

Interview Preparation Tips

Round: Group Discussion
Duration: 7 hours

College Name: Andhra university

I was interviewed in Aug 2017.

Interview Preparation Tips

Round: Test
Tips: Practice e litmus questions and also give mock tests on placement season
Duration: 2 hours

Round: Technical + HR Interview
Experience: The interviewer asked me questions from the subjects I mentioned in my CV and also asked so many situational questions like what will you do in this situation etc.

Skills: Presence Of Mind, Technical Skill
Contribute & help others!
anonymous
You can choose to be anonymous

HCL Infosystems Interview FAQs

How many rounds are there in HCL Infosystems SQL Developer interview?
HCL Infosystems interview process usually has 2 rounds. The most common rounds in the HCL Infosystems interview process are HR and Technical.
How to prepare for HCL Infosystems SQL Developer 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 HCL Infosystems. The most common topics and skills that interviewers at HCL Infosystems expect are Functional, SQL Server and Triggers.
What are the top questions asked in HCL Infosystems SQL Developer interview?

Some of the top questions asked at the HCL Infosystems SQL Developer interview -

  1. What is SQL where it ...read more
  2. What is Join and Proced...read more
  3. Interested Technol...read more

Recently Viewed

INTERVIEWS

L&D Infotech Pvt.Ltd

No Interviews

INTERVIEWS

LTIMindtree

No Interviews

INTERVIEWS

NICE

No Interviews

INTERVIEWS

Tech Mahindra

No Interviews

INTERVIEWS

Honeywell Building Solutions

No Interviews

INTERVIEWS

Rock On

No Interviews

INTERVIEWS

AVASOFT

No Interviews

INTERVIEWS

Embibe

No Interviews

INTERVIEWS

NCR Voyix

No Interviews

INTERVIEWS

Cognizant

No Interviews

Tell us how to improve this page.

HCL Infosystems SQL Developer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

HCL Infosystems SQL Developer Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

4.0

Work-life balance

2.0

Salary

1.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Technical Lead
322 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Software Engineer
230 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Senior Analyst
226 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
201 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Lead Engineer
195 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare HCL Infosystems with

HCLTech

3.5
Compare

Wipro

3.7
Compare

Tech Mahindra

3.5
Compare

TCS

3.7
Compare
Did you find this page helpful?
Yes No
write
Share an Interview
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent