TCS Senior Developer Interview Questions, Process, and Tips

JavaStream API - Employee list need to get data based on department of HR and more than salary of 30000

Opps concepts and questions like reverse linked, string palindrome

Q1. Table , linux flow
Add your answer

Be prepared and give upto point answer

Q1. Tell me about project
Add your answer
Q2. Tell me about day today job
Add your answer

Q1. How did the project configuration can be done in .net without using the config files
Ans. 
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
Answered by AI
Add your answer
Q2. What are the ways you can add authentication to the .net app service
Ans. 
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
Answered by AI
Add your answer
Q3. Troubleshoot modules how do you decide and when
Ans. 
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
Answered by AI
Add your answer

Some basic DDL and DML queries were asked for the tables to be framed in their databases.

Q1. What were the schedulers you 've used to schedule your ETL jobs? What are the advantages of each of them?
Ans. 
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.
Answered by AI
View 1 more answer

Some coding queries were asked in this round, on the Big Data processing with the Hadoop ecosystem and Hive database.

Q1. More in-depth coding queries were asked in this round.
Add your answer
Q2. Questions regarding Informatica Data Retrieval were asksed.
Add your answer
Q3. What were the data retrieval steps in Informatica, while doing the ETL ?
Ans. 
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
Answered by AI
Add your answer
Q4. More questions on the Informatica Data Quality were asked in this round.
Add your answer