Infosys Technology Analyst Interview Questions, Process, and Tips

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

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.

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

Data providers in TestNG allow for parameterization of test methods by supplying data from external sources.

• Data providers are methods annotated with @DataProvider that return a 2D array of objects to supply test method parameters

• Data providers can be used to supply data from Excel sheets, CSV files, databases, etc.

• Example: @DataProvider(name = "userData") public Object[][] userData() { return new Object[][] { { "John"

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

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'.

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