AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Genpact
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Genpact SQL Developer Interview Questions and Answers
Genpact SQL Developer Interview Experiences
4 interviews found
Anonymous
(1 Question)
- Q1. What is correlated subquery?
- Ans.
Correlated subquery is a subquery that references a column from the outer query.
Correlated subqueries are executed for each row processed by the outer query.
They can be used to filter results based on values from the outer query.
Example: SELECT * FROM table1 t1 WHERE t1.column1 = (SELECT MAX(column2) FROM table2 t2 WHERE t2.column3 = t1.column3)
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in May 2024. There was 1 interview round.
(2 Questions)
- Q1. How to insert multiple values in one go
- Ans.
Use the INSERT INTO statement with multiple value sets separated by commas
Use the INSERT INTO statement followed by the table name
List the column names in parentheses after the table name
Use the VALUES keyword followed by multiple value sets in parentheses, separated by commas
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2), (value3, value4)
- Q2. Update query using joins
- Ans.
Update query using joins in SQL
Use UPDATE statement with JOIN clause to update data in multiple tables
Specify the tables to be updated and joined using ON clause
Set the columns to be updated in SET clause
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Dec 2023. There were 3 interview rounds.
Any way ask for questions
Java platform coding test
Interview Preparation Tips
What people are saying about Genpact
I applied via Naukri.com and was interviewed before Sep 2021. There was 1 interview round.
(2 Questions)
- Q1. Interview was quite easy, they asked everything which was mentioned in my resume but it was mainly focused on sql basic questions like joins, union,dml, ddl commands . They hire me as a sql developer but...
- Q2. Joins, dml commands
Interview Preparation Tips
team members as robot.
No increment nothing .
Politics is there , people who play mind games are favorites of management.
Genpact interview questions for designations
Interview questions from similar companies
Selected
I was interviewed in Jan 2025.
Coding skill is very knowledgeable skill
Solving the problem of code assessment with proper logic.
Discuss a topic with many people to identify both positive and negative points
Aptitudes require strong logical thinking skills.
What about codding is telling for code rount
Interview Preparation Tips
key tips for job seekers:
1. Define Your GoalsIdentify what type of job you want and what industries interest you.Set clear, realistic goals for your job search.
2. Update Your Resume & LinkedInTailor your resume to highlight relevant skills and experience.Use keywords from the job description to get past applicant tracking systems (ATS).Keep your LinkedIn profile updated and engaging.
3. Build & Use Your Network.
4.Customize Your ApplicationsAvoid sending generic resumes—personalize each application.
(2 Questions)
- Q1. Explain sql commands
- Ans.
SQL commands are instructions used to interact with a database to perform tasks such as querying, updating, and managing data.
SQL commands are used to interact with databases to perform tasks like querying data, updating data, and managing database structures.
Common SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
Examples: SELECT * FROM table_name; INSERT INTO table_name (column1, column2) VALUES ...
- Q2. Explain normalization in sql
- Ans.
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity.
Normalization involves breaking down a database into smaller, more manageable tables.
It helps in reducing data redundancy by storing data in a structured way.
Normalization ensures data integrity by minimizing the chances of inconsistencies.
There are different normal forms like 1NF, 2NF, 3NF, etc. to guid
(1 Question)
- Q1. What is sql , index , stored proc , triggers
I applied via Naukri.com and was interviewed in Oct 2024. There was 1 interview round.
(2 Questions)
- Q1. Joins in sql server
- Q2. Set operator in sql
Interview Preparation Tips
(2 Questions)
- Q1. Explain about SSIS Architecture
- Ans.
SSIS Architecture is a platform for data integration and workflow applications.
SSIS stands for SQL Server Integration Services
It includes a data flow engine, control flow engine, and event handling
SSIS packages can be created using SQL Server Data Tools (SSDT)
SSIS packages can be scheduled and executed using SQL Server Agent
- Q2. How to implement transactions in ssis
- Ans.
Transactions in SSIS can be implemented using the TransactionOption property in Control Flow tasks.
Set the TransactionOption property to Required on the Control Flow tasks that need to be included in the transaction.
Use the TransactionOption property to specify the level of transaction support needed for each task.
Transactions can be managed using the Distributed Transaction Coordinator (DTC) service.
Interview Preparation Tips
Skills evaluated in this interview
(2 Questions)
- Q1. Write a query to display the highest salary
- Ans.
Query to display the highest salary in a table
Use the SELECT statement to retrieve data
Use the MAX() function to find the highest salary
Specify the column name for salary in the query
- Q2. Stored proceduers,functions,cursors triggers,
Interview Preparation Tips
Skills evaluated in this interview
Genpact Interview FAQs
Tell us how to improve this page.
Genpact Interviews By Designations
- Genpact Process Associate Interview Questions
- Genpact Process Developer Interview Questions
- Genpact Management Trainee Interview Questions
- Genpact Assistant Manager Interview Questions
- Genpact Business Analyst Interview Questions
- Genpact Consultant Interview Questions
- Genpact Senior Associate Interview Questions
- Genpact Accountant Interview Questions
- Show more
Interview Questions for Popular Designations
- Front end Developer Interview Questions
- Web Developer Interview Questions
- Backend Developer Interview Questions
- Software Developer Intern Interview Questions
- Junior Software Developer Interview Questions
- Full Stack Software Developer Interview Questions
- PHP Developer Interview Questions
- UI Developer Interview Questions
- Show more
Genpact SQL Developer Interview Process
based on 3 interviews
Interview experience
SQL Developer Interview Questions from Similar Companies
Fast track your campus placements
Genpact SQL Developer Reviews and Ratings
based on 1 review
Rating in categories
|
Process Developer
36.3k
salaries
|  ₹1 L/yr - ₹6.8 L/yr |
|
Process Associate
28.1k
salaries
| ₹0.9 L/yr - ₹6.5 L/yr |
|
Assistant Manager
19.9k
salaries
| ₹5 L/yr - ₹14 L/yr |
|
Management Trainee
19.4k
salaries
| ₹1.6 L/yr - ₹8.5 L/yr |
|
Manager
7.4k
salaries
| ₹5.7 L/yr - ₹24 L/yr |
Accenture
Capgemini
TCS
Cognizant
- Home >
- Interviews >
- Genpact Interview Questions >
- Genpact SQL Developer Interview Questions
