Infosys 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

An aptitude test is an assessment to measure a candidate mental aptitude/mental ability

Q1. Can you briefly Tell us about yourself?
Ans. 
I am a passionate software developer with 5 years of experience in web development and a strong background in computer science.
• 5 years of experience in web development

• Strong background in computer science

• Passionate about software development
Answered by AI
Add your answer
Q2. What do you consider to be your strongest points?
Ans. 
My strongest points include problem-solving skills, attention to detail, and ability to work well in a team.
• Strong problem-solving skills - I enjoy tackling complex issues and finding creative solutions.

• Attention to detail - I am meticulous in my work and strive for perfection in every task.

• Team player - I collaborate effectively with colleagues, communicate openly, and contribute positively to group projects.
Answered by AI
Add your answer
Q3. Which programming languages do you use regularly in your work
Ans. 
I regularly use Java, Python, and SQL in my work as a Software Developer.
• Java

• Python

• SQL
Answered by AI
Add your answer

A group discussion is a structured conversation in which participants share their ideas, perspectives, and solutions on a specific topic.

Q1. What motivates you to seek employment at Wipro?
Ans. 
I am motivated to seek employment at Wipro because of their reputation for innovation and opportunities for growth.
• Impressed by Wipro's track record of delivering cutting-edge solutions

• Excited about the chance to work with a diverse and talented team

• Eager to take advantage of Wipro's professional development programs
Answered by AI
Add your answer
Q2. What are your long-term career goals?
Ans. 
My long-term career goal is to become a lead software developer and eventually move into a management role.
• Advance to a lead software developer position

• Gain experience in managing a team of developers

• Develop strong leadership and communication skills

• Continue learning new technologies and staying updated with industry trends
Answered by AI
Add your answer

Assignment details refer to the specifics of an assignment, including any documents and/or emails or subsequent correspondence between the company and the client.

Q1. Different types of streams based questions
Add your answer
Q2. Collection , competable future, java 8 features
Add your answer

Q1. Project based questions
Add your answer
Q2. Scenario based question (multithreading and caching related scenarios were asked to me)
Add your answer
Q3. One coding challenge
Add your answer

It included all aptitude

Contains all pseudo questions related to DSA

Q1. What is a class?
Ans. 
A class is a blueprint for creating objects in object-oriented programming.
• Defines the properties and behaviors of objects

• Can be used to create multiple instances of objects

• Encapsulates data and methods within a single unit
Answered by AI
Add your answer
Q2. What is an object?
Ans. 
An object is a self-contained entity that consists of data and methods to manipulate that data.
• Objects are instances of classes in object-oriented programming.

• They have attributes (data) and methods (functions) to operate on the data.

• Objects can interact with each other through method calls.

• Example: In a car simulation program, a 'Car' object may have attributes like 'color' and 'speed', and methods like 'accelerate' a
Answered by AI
Add your answer
Q3. How the login page comes when clicks on some webpage icon like facebook?
Ans. 
The login page is displayed when a user clicks on a webpage icon like Facebook by redirecting to a separate login page.
• Clicking on the webpage icon triggers a redirect to the login page

• The login page prompts the user to enter their credentials

• After successful login, the user is redirected back to the original webpage
Answered by AI
Add your answer
Q4. DDL and DML commands
Add your answer
Q5. Polymorphism and method overriding?
Add your answer
Q6. Entire opps in java
Ans. 
Object-oriented programming in Java involves creating classes, objects, inheritance, polymorphism, and encapsulation.
• Classes are blueprints for objects, defining attributes and behaviors.

• Objects are instances of classes, representing real-world entities.

• Inheritance allows a class to inherit attributes and methods from another class.

• Polymorphism enables objects to be treated as instances of their parent class.

• Encapsulat...read more
Answered by AI
Add your answer

First round was Aptitude which was quite easy

Q1. Resume bases Question
Add your answer
Q2. Question on OOPS
Add your answer

Q1. Resume and scenario based question
Add your answer

Q1. Introduce yourself
Ans. 
I am a software developer with 5 years of experience in Java and Python.
• Experienced in Java and Python programming languages

• Worked on developing web applications using Spring framework

• Familiar with Agile development methodologies
Answered by AI
Add your answer
Q2. What challenges do you faced during your project and how you approached them
Ans. 
I faced challenges with integrating third-party APIs and resolved them by thoroughly researching documentation and seeking help from colleagues.
• Integrating third-party APIs required understanding complex documentation

• Encountered issues with data formatting and authentication

• Collaborated with team members to troubleshoot and find solutions
Answered by AI
Add your answer

Q1. Tell me the high level overview of dataguard installation?
Add your answer
Q2. What are your daily tasks adn what things you handel in your team?
Add your answer