Add office photos
Employer? Claim Account for FREE
Genpact
CompareProud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Genpact Plsql Developer Interview Questions and Answers
Updated
4 Mar 2022
Sync Tech
Interview questions from similar companies
Anonymous
Interview experience
Good
Difficulty level
Moderate
Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Nov 2024.
1 Interview Round
1
Technical Round (4 Questions)
- Q1. Types of partition in sql Add Answer
- Q2. Can we edit data in complex views, will the underlying table be effected? Add Answer
- Q3. How do you do performance tuning? Add Answer
- Q4. Tell about regex Add Answer
Suvham Das
Interview experience
Average
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Technical Round (2 Questions)
- Q1. Factorial of a number View Answers (1)
- Q2. Sql queries including 2nd highest salary and table joins Add Answer
2
Technical Round (2 Questions)
- Q1. Sql question and table joins Add Answer
- Q2. Modelling of schema View Answers (1)
Interview Preparation Tips
Interview preparation tips for other job seekers - Some sql queries
1 DSA prime no
1 DSA prime no
Skills evaluated in this interview
Interview experience
Good
Difficulty level
Easy
Duration
-
Result
-
I applied via Naukri.com and was interviewed in Apr 2024.
1 Interview Round
1
Technical Round (6 Questions)
- Q1. What is view? Can we update in view? View Answers (1)
- Q2. What is synonym? View Answers (1)
- Q3. What is sequence View Answers (1)
- Q4. What is procedures? View Answers (1)
- Q5. What is difference between procedure and functions View Answers (1)
- Q6. What is partitions? View Answers (1)
Skills evaluated in this interview
Imaya Valli
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
3 Interview Rounds
1
Resume Shortlist Round
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
2
Technical Round (1 Question)
- Q1. 1.How to search a text in all database objects- search in all_source table 2.difference between procedure & function 3.difference between case & decode 4.write ...read more Add Answer
3
One-on-one Round (1 Question)
- Q1. Waiting for round 1 results Add Answer
Interview experience
Average
Difficulty level
Moderate
Duration
-
Result
Not Selected
I applied via Naukri.com and was interviewed in Aug 2023.
4 Interview Rounds
1
Resume Shortlist Round
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
2
HR Round (1 Question)
- Q1. Experience,ctc,expected ctc Add Answer
3
Technical Round (1 Question)
- Q1. Plsql concepts , procedure , functions Add Answer
4
Technical Round (1 Question)
- Q1. Plsql advance concepts, procedure , function Add Answer
uma devi
Interview experience
Excellent
Difficulty level
-
Duration
-
Result
-
2 Interview Rounds
1
Aptitude Test Round
It is little bit easy
2
Coding Test Round
2 coding question in python
Interview experience
Average
Difficulty level
Moderate
Duration
2-4 weeks
Result
No response
I applied via Approached by Company and was interviewed in Sep 2023.
3 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
2
Technical Round (1 Question)
- Q1. Window Functions in SQL View Answers (1)
3
Technical Round (1 Question)
- Q1. Uses of Packages in PL/SQL View Answers (1)
Skills evaluated in this interview
Interview experience
Bad
Difficulty level
Easy
Duration
Less than 2 weeks
Result
Not Selected
I was interviewed in Feb 2023.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Double-check your resume for any spelling mistakes. The recruiter may consider spelling mistakes as careless behavior or poor communication skills.
View all tips
2
Technical Round (2 Questions)
- Q1. 1. What are Triggers? Explain and differentiate type of Triggers? 2. What are Views? Materialized View? 3. Explain Job role in the Current Company? 4. What is I...read more Add Answer
- Q2. Reason for Job change Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - I gave the interview as an experienced, Got selected but still I haven't received Offer letter
Venkatesh Ganesh
I applied via Naukri.com and was interviewed in Jun 2022.
2 Interview Rounds
1
Resume Shortlist Round
Pro Tip by AmbitionBox:
Do not use an unprofessional email address such as cool_boy@email.com. It shows a lack of professionalism by the candidate.
View all tips
2
One-on-one Round (2 Questions)
- Q1. Triggers ,
procedures ,
exception handling ,
collections,
package Add Answer
- Q2. Type , array, partition, performance tuning, AWR Add Answer
Interview Preparation Tips
Interview preparation tips for other job seekers - For senior level they will expect knowledge on bulk processing exception handling packages collections
Genpact Interview FAQs
How to prepare for Genpact Plsql 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 Genpact. The most common topics and skills that interviewers at Genpact expect are PLSQL, ETL, Oracle, SQL Queries and Java.
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
- Oracle SQL and PLSQL Developer Interview Questions
- Senior Plsql Developer Interview Questions
- 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
- Show more
Plsql Developer Interview Questions from Similar Companies
Fast track your campus placements
12%
less
than the average Plsql Developer Salary in India
View more details
Genpact Plsql Developer Reviews and Ratings
based on 2 reviews
Rating in categories
|
Process Developer
36.3k
salaries
|  ₹1 L/yr - ₹6.8 L/yr |
|
Process Associate
28.2k
salaries
| ₹0.9 L/yr - ₹6.5 L/yr |
|
Assistant Manager
20k
salaries
| ₹4.8 L/yr - ₹14 L/yr |
|
Management Trainee
19.2k
salaries
| ₹1.6 L/yr - ₹8.5 L/yr |
|
Manager
7.5k
salaries
| ₹7 L/yr - ₹24 L/yr |
Explore more salaries
Compare Genpact with
Accenture
Compare
Capgemini
Compare
TCS
Compare
Cognizant
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
- Home >
- Interviews >
- Genpact Interview Questions >
- Genpact Plsql Developer Interview Questions
Share an Interview