TCS Senior Developer Interview Questions and Answers

Data retrieval steps in Informatica ETL process

• Identify the source data to be extracted

• Create source and target connections in Informatica

• Design mappings to extract, transform, and load data

• Use transformations like Filter, Joiner, Lookup, etc.

• Run the ETL job to retrieve data from source to target

I have used Airflow and Oozie for scheduling ETL jobs.

• Airflow provides a user-friendly UI and supports multiple languages.

• Oozie is good for Hadoop-based ETL jobs and has a web console for monitoring.

• Airflow has a larger community and more plugins available.

• Oozie has better integration with Hadoop ecosystem tools.

• Both are open-source and can handle complex workflows.

Project configuration in .NET without config files

• Use code-based configuration instead of XML configuration

• Create a custom configuration provider

• Use environment variables or command line arguments

• Use a database or other external storage for configuration data

There are multiple ways to add authentication to .NET app service.

• Using Azure Active Directory

• Using IdentityServer

• Using OAuth2

• Using OpenID Connect

• Using JWT Tokens

I troubleshoot modules by identifying the problem, analyzing the code, and testing solutions.

• Identify the problem by reproducing the issue and gathering information

• Analyze the code to understand how it works and where the issue may be

• Test solutions by implementing and verifying the fix

• Document the troubleshooting process and solution for future reference

Springboot annotations include @RestController, @Autowired, @RequestMapping. Maven is a build automation tool. Java 8 features include lambda expressions, streams, and functional interfaces.

• @RestController - used to define RESTful web services

• @Autowired - used for automatic dependency injection

• @RequestMapping - maps HTTP requests to handler methods

• Maven is a build automation tool that manages project dependencies and builds the project

• Java 8 features include lambda expression...read more

To add a node into a linked list, you need to update the pointers of the previous node and the new node.

• Create a new node with the data to be added

• Update the next pointer of the new node to point to the current node's next

• Update the next pointer of the current node to point to the new node

SSL certificate is a digital certificate that authenticates the identity of a website and encrypts data transmitted between the website and the user's browser.

• SSL certificates are used to secure communication over the internet by encrypting data.

• They are issued by Certificate Authorities (CAs) after verifying the identity of the website owner.

• SSL certificates contain information such as the domain name, issuer, and expiration date.

• They enable the use of HTTPS protocol, ensuri...read more