Genpact Senior ETL Developer Interview Questions and Answers

Q1. Types of Joins Join scenarios counts of left join , right join How to validate source vs target data Questions based on current project
Add your answer
Q2. Workflow/ Mapping parameters Joiner Lookup Type2 implementation Hadoop basics
Add your answer

General, oop concept

Q1. OOP Concept basics with example
Add your answer
Q2. SOLID Principles
Add your answer

Q1. Package discussion
Add your answer
Q2. Whether ready to work with any shifts
Add your answer

30 marks 30 minutes aptitude questions

To and far on social issues such as poverty

Q1. Normal discussion on c and java
Add your answer
Q2. Fibonacci series, prime numbers program
Add your answer
Q3. Java basics and other programs basics
Add your answer

Q1. What are oops concepts in java, explain real time scenario
Ans. 
OOPs concepts in Java include inheritance, polymorphism, encapsulation, and abstraction.
• Inheritance allows a subclass to inherit properties and methods from a superclass.

• Polymorphism allows objects to take on multiple forms and behave differently based on their context.

• Encapsulation hides the implementation details of an object and only exposes necessary information.

• Abstraction allows for the creation of abstract class...read more
Answered by AI
View 1 more answer
Q2. Uses of interface, inheritance
Ans. 
Interfaces define contracts for behavior, while inheritance allows for code reuse and polymorphism.
• Interfaces allow for loose coupling and abstraction, enabling multiple implementations of the same behavior.

• Inheritance allows for code reuse and extension of existing classes, reducing code duplication.

• Polymorphism allows objects of different classes to be treated as if they were of the same class, simplifying code and i
Answered by AI
Add your answer
Q3. SQL query for join of tables
Ans. 
SQL query for joining tables
• Use JOIN keyword to combine two or more tables based on a related column

• Specify the columns to be selected using SELECT keyword

• Use ON keyword to specify the condition for joining the tables

• Different types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN
Answered by AI
Add your answer
Q4. Java concepts used in your project
Ans. 
Used Java concepts such as inheritance, polymorphism, and exception handling in my project.
• Implemented inheritance to create a base class and derived classes with specific functionalities.

• Utilized polymorphism to allow objects of different classes to be treated as if they were of the same class.

• Implemented exception handling to handle errors and prevent program crashes.

• Used interfaces to define a set of methods that a ...read more
Answered by AI
Add your answer
Q5. Overloading vs overriding, practical uses
Ans. 
Overloading is having multiple methods with the same name but different parameters. Overriding is having a method in a subclass with the same name and parameters as a method in the superclass.
• Overloading is used to provide different ways to call a method with different parameters

• Overriding is used to provide a specific implementation of a method in a subclass

• Overloading is resolved at compile-time while overriding is r...read more
Answered by AI
Add your answer

Q1. Basic questions on SQL
Add your answer
Q2. Datastructure and Algorithm questions
Add your answer

Q1. What is java? What is variable?
Ans. 
Java is a popular programming language used for developing various applications. A variable is a named memory location used to store data.
• Java is an object-oriented language

• It is platform-independent

• Variables in Java have a specific data type

• Variables can be assigned values and their values can be changed

• Example: int age = 25; String name = "John";
Answered by AI
View 1 more answer
Q2. What is inheritance? types of inheritance
Ans. 
Inheritance is a concept in object-oriented programming where a class inherits properties and behaviors from another class.
• Inheritance allows code reuse and promotes code organization.

• There are different types of inheritance: single inheritance, multiple inheritance, multilevel inheritance, and hierarchical inheritance.

• Single inheritance involves a class inheriting from a single base class.

• Multiple inheritance involves...read more
Answered by AI
View 1 more answer
Q3. 1.Java is a high level language 2.java is a programme is called a set of instructions 3.java run time environment (jre) 4.java is a platform independent. Variable: A variable which is container that some d...read more
Add your answer
Q4. Inheritance; 1.Acquring the properties of parent class to the child class with out changeing the properties of parent class is known as inheritance 2.inheritanc is a is relationship 3.extends keyword is us...read more
Ans. 
Inheritance is acquiring properties of parent class to child class without changing parent class properties. It is classified into 5 types.
• Inheritance is a way to reuse code and establish a relationship between classes

• The 'extends' keyword is used to implement inheritance in Java

• Examples of inheritance include a 'Car' class inheriting properties from a 'Vehicle' class

• Single level inheritance involves one parent class a...read more
Answered by AI
Add your answer

May I about you ? Which your qualification and which stream

Moderate level of aptitude test

A simple case study questions are provided

Q1. Most of the questions from oops concepts and data structure
Add your answer