Infosys Technology Analyst Interview Questions and Answers for Experienced

Polymorphism allows methods to do different things based on the object type, enhancing flexibility in programming.

• Polymorphism is a core concept in Object-Oriented Programming (OOP).

• It allows methods to be defined in multiple forms.

• There are two types: compile-time (method overloading) and runtime (method overriding).

• Example of method overloading: a function 'add' can add integers or doubles.

• Example of method over...read more

SQL Joins combine rows from two or more tables based on related columns, enabling complex queries and data retrieval.

• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from ...read more

I am open to any location that offers opportunities for growth and learning.

• Open to relocation for the right opportunity

• Prefer locations with strong tech industry presence

• Interested in cities known for innovation and technology hubs

Rank assigns unique ranks to each distinct value, while dense rank assigns consecutive ranks to each distinct value.

• Rank leaves gaps between ranks if there are ties, while dense rank does not

• Rank function is used to assign a unique rank to each distinct row, while dense rank function is used to assign consecutive ranks to each distinct row

• Example: If we have values 10, 20, 20, 30 - Rank would assign ranks as 1, 2,...read more

A job scheduler is a software application that is used to automate the scheduling of tasks or jobs in a computer system.

• Job schedulers help in optimizing resource utilization by efficiently managing the execution of tasks.

• They allow users to define dependencies between tasks and specify when and how often tasks should run.

• Examples of job schedulers include Cron for Unix-based systems and Task Scheduler for Windows...read more

To improve performance in Datastage, optimize job design, use efficient coding practices, utilize parallel processing, and monitor job performance.

• Optimize job design by reducing unnecessary stages and transformations

• Use efficient coding practices such as avoiding unnecessary data reads and writes

• Utilize parallel processing to take advantage of multiple CPU cores

• Monitor job performance using Datastage Director or ...read more