ITC Infotech IT Analyst ITA Interview Questions and Answers

Q1. Create Custom hook to fetch data
Ans. 
Custom hook to fetch data in React
• Create a custom hook using the 'useEffect' and 'useState' hooks

• Use 'fetch' or any other method to fetch data from an API

• Return the fetched data from the custom hook
Answered by AI
Add your answer
Q2. Javascript concept and output
Add your answer

Q1. React hooks and lifecycle
Add your answer
Q2. Custom hook and some tricky output question
Add your answer

Its moderate and nit that much difficult to attempt

Coding also moderate its not that much deep

Assignment is based on verbal communication

Q1. What is the 1st priority job or family?
Ans. 
Family should be the 1st priority as they provide emotional support and love.
• Family provides emotional support during tough times

• Family offers unconditional love and care

• Job can always be replaced, but family is irreplaceable
Answered by AI
Add your answer
Q2. What is the java?
Ans. 
Java is a high-level programming language known for its portability, security, and versatility.
• Java is an object-oriented language

• It is platform-independent, meaning code can run on any device with a Java Virtual Machine (JVM)

• Java is used for developing web applications, mobile apps, desktop applications, and more
Answered by AI
Add your answer
Q3. Tell me your personal details
Ans. 
I am a dedicated and experienced System Analyst with a strong background in IT and problem-solving skills.
• Experienced in analyzing and designing software systems

• Proficient in programming languages such as Java, C++, and SQL

• Strong communication and teamwork skills

• Detail-oriented and able to prioritize tasks effectively
Answered by AI
Add your answer
Q4. Regarding coding
Add your answer
Q5. Regarding gk questions
Add your answer

Q1. Write a code to create dataframe in adb using struct type
Ans. 
Creating a dataframe in adb using struct type
• Use the 'CREATE TABLE' statement to define the schema of the dataframe

• Define the struct type using 'STRUCT' keyword

• Insert data into the dataframe using 'INSERT INTO' statement
Answered by AI
Add your answer
Q2. Write a code to find max salary department wise and second highest salary department wise
Ans. 
Code to find max and second highest salary department wise
• Iterate through the list of employees and store max and second highest salary for each department

• Use a hashmap to store department wise salaries

• Sort the salaries in descending order to find max and second highest
Answered by AI
Add your answer
Q3. How do you call a variable from one note book to another note book in adb
Ans. 
You can call a variable from one notebook to another in adb by using the %run magic command.
• Use the %run magic command followed by the path to the notebook containing the variable you want to access.

• Make sure the notebook containing the variable is in the same directory or provide the full path.

• Once you run the %run command, the variables from the other notebook will be available in the current notebook.
Answered by AI
Add your answer
Q4. How do you do incremental load in adf
Ans. 
Incremental load in ADF is achieved by using watermark columns to track the last loaded data and only loading new or updated records.
• Use watermark columns to track the last loaded data

• Compare the watermark column value with the source data to identify new or updated records

• Use a filter condition in the source query to only select records with a timestamp greater than the watermark value

• Update the watermark column value
Answered by AI
Add your answer
Q5. What's your project and what does you do in it
Add your answer

Q1. Tell me about your self without going much into technical details of project
Add your answer
Q2. What is the reason for job change
Add your answer
Q3. How fast can you join
Add your answer

Write the Fibonacci series.

Q1. What are your reasons for wanting to join this organization?
Add your answer

Basic technical questions

Q1. Exepected salary?
Add your answer

Q1. Challenging part of your previous project
Add your answer
Q2. How to handle Scope creep
Ans. 
Scope creep can be handled by clearly defining project scope, setting boundaries, regularly communicating with stakeholders, and managing changes effectively.
• Clearly define project scope at the beginning

• Set boundaries and communicate them to stakeholders

• Regularly communicate with stakeholders to manage expectations

• Implement a change control process to evaluate and approve changes

• Prioritize requirements and focus on del
Answered by AI
Add your answer

Q1. Tell me about yourself, explain your project journey, how many projects you have led what was your previous experience what is scrum how do you identify requirements gathering what is sprint
Ans. 
I am an experienced business analyst with a track record of leading successful projects using Scrum methodology.
• I have led 10+ projects in my career, ranging from small-scale to enterprise-level

• My previous experience includes working as a business analyst for a Fortune 500 company

• Scrum is an agile framework used for project management and product development

• I identify requirements gathering by conducting stakeholder in...read more
Answered by AI
Add your answer
Q2. All scrum question
Add your answer
Q3. Client profile awareness
Add your answer

1 dsa question and aptitude

Q1. Tell me about yourself
Add your answer
Q2. Worst phase of your life
Add your answer