Infosys Technology Analyst Full-time Job Interview Questions, Process, and Tips

Q1. Tell me yourself
Ans. 
I am a technology analyst with a strong background in data analysis and software development.
• I have a Bachelor's degree in Computer Science from XYZ University

• I have 5 years of experience working as a technology analyst at ABC Company

• I specialize in data visualization tools such as Tableau and Power BI

• I have led successful projects in implementing new software solutions for clients
Answered by AI
Add your answer
Q2. What is your skillset and based on your skill set some straight forward question in round 1 and scenario based question in round 2.
Add your answer
Q3. Tell me some analytic function of sql
Ans. 
Analytic functions in SQL are used to perform calculations across a set of rows related to the current row.
• Common analytic functions include ROW_NUMBER, RANK, DENSE_RANK, LEAD, and LAG.

• They can be used to calculate running totals, moving averages, and identify duplicates in a dataset.

• Analytic functions are typically used with the OVER() clause to define the window of rows to be used in the calculation.
Answered by AI
Add your answer
Q4. Difference between rank and dense rank
Ans. 
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, 2, 4...read more
Answered by AI
Add your answer

Q1. I have Oracle EBS APPS.. so I faced questions on PLSQL tuning, exception handling, XML publisher report, P2P cycle with associative table
Add your answer
Q2. Bulk Binding, Bulk collect, cursor, dynamic SQL,DML/DDL Trigger
Add your answer

Q1. Difference in POST and PUT
Ans. 
POST is used to create a new resource, while PUT is used to update an existing resource.
• POST is used to create a new resource on the server.

• PUT is used to update an existing resource on the server.

• POST requests are not idempotent, while PUT requests are idempotent.

• POST requests do not require the client to specify the URI of the new resource, while PUT requests do.

• Example: POST /users creates a new user, PUT /users/123
Answered by AI
Add your answer
Q2. Explain headers with example in HTTP
Ans. 
Headers in HTTP are additional information sent with a request or response.
• Headers contain metadata about the message being sent.

• Examples of headers include Content-Type, User-Agent, and Authorization.

• Headers are key-value pairs separated by a colon, such as 'Content-Type: application/json'.
Answered by AI
Add your answer
Q3. What is @Qualifier annotation
Ans. 
The @Qualifier annotation is used in Spring framework to specify which bean should be autowired when multiple beans of the same type are present.
• Used to resolve ambiguity when multiple beans of the same type are present

• Can be used with @Autowired annotation to specify the bean to be injected

• Helps in selecting the bean based on a specific qualifier value
Answered by AI
Add your answer

Q1. 1. Introduces your self 2. Ask about basic datastage questions
Add your answer
Q2. 3 . Explain scd 2 and how can we build in datastage 4. Write sql query which is related to join and sub query.
Ans. 
SCD 2 is a type of slowly changing dimension in data warehousing, and can be implemented in DataStage using various techniques.
• SCD 2 stands for Slowly Changing Dimension Type 2, which tracks historical changes in data over time.

• In DataStage, SCD 2 can be implemented using the Change Data Capture stage or custom SQL queries.

• To implement SCD 2 in DataStage, you need to identify the key columns for tracking changes, defin...read more
Answered by AI
Add your answer
Q3. 5. How to improve performance in Datastage
Ans. 
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 other
Answered by AI
Add your answer

Q1. 1. Introduce yourself self
Add your answer
Q2. 2. Why are you planing to switch job
Add your answer

Quants, reasoning, english

With oops concepts, data structures

Q1. Change management
Add your answer
Q2. Dns dhcp troubleshooting
Add your answer

Q1. Basic Core JAVA
Add your answer

Q1. Project related questions
Add your answer