AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
ITC Infotech
Compare
Filter interviews by
ITC Infotech Interview Questions and Answers
227 Interview questions
ServiceNow has introduced several new features enhancing user experience, automation, and integration capabilities.
Enhanced User Interface: The new UI provides a more intuitive experience with improved navigation and accessibility features.
AI-Powered Virtual Agent: The virtual agent now includes advanced natural language processing capabilities for better user interactions.
Integration Hub: New connectors allow sea...
Employees fill in data entry by accurately inputting, verifying, and managing data using various tools and software.
Use of data entry software like Microsoft Excel or specialized databases.
Input data from paper forms, ensuring accuracy and completeness.
Verify entered data against source documents to minimize errors.
Utilize keyboard shortcuts to enhance speed and efficiency.
Regularly back up data to prevent loss an...
Data entry in Excel involves inputting, organizing, and managing data efficiently using various Excel features.
Open Excel and create a new workbook or open an existing one.
Click on a cell to start entering data; for example, type 'John Doe' in cell A1.
Use the Tab key to move to the next cell horizontally or Enter to move vertically.
To enter dates, type in a recognizable format like '01/01/2023'.
Utilize Excel's fea...
Steps to configure a printer using a DHCP IP address involve network setup, driver installation, and printer configuration.
Ensure the printer is connected to the network and powered on.
Access the printer's control panel to check its DHCP settings.
Obtain the printer's IP address from the control panel or print a configuration page.
On the computer, go to 'Devices and Printers' and select 'Add a Printer'.
Choose 'Add ...
What people are saying about ITC Infotech
The OSI model is a conceptual framework used to understand network communication in seven layers.
Layer 1: Physical - Deals with the physical connection (e.g., cables, switches).
Layer 2: Data Link - Manages node-to-node data transfer (e.g., Ethernet).
Layer 3: Network - Handles routing of data (e.g., IP addresses).
Layer 4: Transport - Ensures complete data transfer (e.g., TCP, UDP).
Layer 5: Session - Manages session...
PST and OST files are data files used by Microsoft Outlook for storing emails, contacts, and calendar items.
PST files are used for storing emails and data locally on a computer.
OST files are used for offline access to emails when connected to an Exchange server.
PST files can be imported/exported easily, while OST files sync with the server.
Example: A PST file might be created for archiving old emails, while an OST...
The OSI model has 7 layers that standardize network communication protocols.
1. Physical Layer: Deals with the physical connection (e.g., cables, switches).
2. Data Link Layer: Manages node-to-node data transfer (e.g., Ethernet).
3. Network Layer: Handles routing of data packets (e.g., IP).
4. Transport Layer: Ensures reliable data transfer (e.g., TCP, UDP).
5. Session Layer: Manages sessions between applications (e.g....
ZCC stands for Zero-Crossing Control, a technique used in electronic circuits for efficient switching.
ZCC minimizes power loss during switching events.
Commonly used in AC motor drives to improve efficiency.
Helps reduce electromagnetic interference (EMI) in circuits.
Example: In a TRIAC-based dimmer switch, ZCC ensures smooth light dimming.
A VPN (Virtual Private Network) creates a secure connection over the internet, protecting data and privacy.
Encrypts internet traffic to protect data from eavesdroppers.
Allows remote access to a private network, useful for telecommuting.
Bypasses geo-restrictions, enabling access to region-locked content.
Examples include services like NordVPN, ExpressVPN, and Cisco AnyConnect.
Operational Technology (OT) faces challenges like cybersecurity, integration, workforce skills, regulatory compliance, and system reliability.
Cybersecurity threats: OT systems are increasingly targeted by cyberattacks, such as ransomware affecting critical infrastructure.
Integration with IT: Bridging the gap between IT and OT systems can lead to data silos and operational inefficiencies.
Workforce skills gap: There...
ITC Infotech Interview Experiences
374 interviews found
Jayalakshmi Jaya
I applied via Monster and was interviewed in May 2024. There was 1 interview round.
(6 Questions)
- Q1. Select 3 rd highest salary from employee table
- Ans.
To select the 3rd highest salary from the employee table, you can use a SQL query with the 'LIMIT' and 'OFFSET' keywords.
Use a SQL query like 'SELECT salary FROM employee ORDER BY salary DESC LIMIT 1 OFFSET 2' to get the 3rd highest salary.
The 'ORDER BY' clause sorts the salaries in descending order, 'LIMIT 1' limits the result to 1 row, and 'OFFSET 2' skips the first two rows.
Make sure to adjust the 'OFFSET' value if ...
- Q2. Difference between put and patch
- Ans.
Put is used to create or replace a resource, while patch is used to update a resource partially.
Put is idempotent, meaning multiple identical requests will have the same effect as a single request
Patch is not idempotent, as multiple identical requests may have different effects
Put requires the client to send the entire updated resource, while patch only requires the specific changes to be sent
- Q3. Difference between == and equals in string
- Ans.
The == operator checks for reference equality, while the equals method checks for value equality in strings.
Use == to check if two string variables refer to the same object in memory.
Use equals() method to check if two string variables have the same sequence of characters.
Example: String str1 = "hello"; String str2 = "hello"; str1 == str2 will return false, but str1.equals(str2) will return true.
- Q4. Difference way of declaring String
- Ans.
String can be declared using double quotes, single quotes, or the String constructor.
Declare using double quotes: String str1 = "Hello";
Declare using single quotes: String str2 = 'World';
Declare using String constructor: String str3 = new String("Java");
- Q5. Difference between String builder and String buffer
- Ans.
String builder is not synchronized, while String buffer is synchronized.
String builder is faster than String buffer because it is not synchronized.
String buffer is thread-safe, while String builder is not.
String builder is preferred for single-threaded applications, while String buffer is preferred for multi-threaded applications.
- Q6. Convert array into arraylist
- Ans.
Convert array to ArrayList of strings
Create a new ArrayList<String>
Use Arrays.asList() method to convert array to ArrayList
Example: String[] array = {"apple", "banana", "orange"}; ArrayList<String> list = new ArrayList<>(Arrays.asList(array));
Skills evaluated in this interview
Anonymous
Selected
I appeared for an interview in Dec 2024.
(2 Questions)
- Q1. Realted to o365 theory
- Q2. Regarding litigation hold and retention policies with mailflow and structure and some scenario based questions
(2 Questions)
- Q1. Regarding technical questions and scenario based
- Q2. Teams issues and outlook
(2 Questions)
- Q1. Salary discussion
- Q2. Description of working culture and ethics
- Ans.
Our working culture promotes collaboration, innovation, and integrity.
We prioritize teamwork and open communication to achieve common goals.
We encourage creativity and out-of-the-box thinking to solve complex problems.
We uphold high ethical standards and value honesty and transparency in all interactions.
We strive for continuous improvement and learning to stay ahead in the ever-evolving technology landscape.
I appeared for an interview in Feb 2025.
(2 Questions)
- Q1. How did you handle projects as a program manager?
- Ans.
As a program manager, I coordinated multiple projects, ensuring alignment with strategic goals and effective resource management.
Developed a comprehensive project roadmap that aligned with organizational objectives, ensuring all stakeholders were informed.
Implemented Agile methodologies to enhance team collaboration and adaptability, resulting in a 20% increase in project delivery speed.
Facilitated regular cross-functi...
- Q2. Tell your 3 professional achievement on which you proud
- Ans.
Successfully led cross-functional teams to deliver projects on time, improve processes, and enhance client satisfaction.
Led a team of 10 in delivering a critical software project 2 weeks ahead of schedule, resulting in a 15% cost saving.
Implemented Agile methodologies that improved team productivity by 30%, enabling faster response to client needs.
Developed a stakeholder communication plan that increased client satisfa...
Interview Preparation Tips
I appeared for an interview in Feb 2025.
Oriented in sql,java logical question and manual testing they asked about that.
Pass by value &pass by reference
About the project &They suggest one topic in based on us
(2 Questions)
- Q1. Self introduction
- Q2. About sql,java, logical question and ressume based questions they asked in technical round also we haven.
Interview Preparation Tips
Selected
I applied via AmbitionBox and was interviewed in Nov 2024. There were 4 interview rounds.
(2 Questions)
- Q1. About your self
- Q2. Communication skills
(3 Questions)
- Q1. Programming language
- Q2. What tools do you utilize for data analysis?
- Ans.
I utilize tools such as Excel, Python, SQL, and Tableau for data analysis.
Excel for basic data manipulation and visualization
Python for advanced data analysis and machine learning
SQL for querying databases
Tableau for creating interactive visualizations
- Q3. Pandas numpy seaborn matplot
Data analysis of code in the context of data analysis.
Coding logical question paper.
Selected
I appeared for an interview in Aug 2024.
First, test and then pass the next.
I did not have a coding test, but the next round included a coding test.
Two were passed, and the next round was conducted on the assignment.
Assignment: right or wrong case study on the assignment.
The main focus is on group discussion.
(7 Questions)
- Q1. Why does the company conduct coding tests?
- Ans.
Coding tests help assess candidates' technical skills and problem-solving abilities.
Coding tests help evaluate candidates' ability to write efficient and clean code.
They assess problem-solving skills and logical thinking.
Coding tests ensure that candidates have the necessary technical skills for the job.
They help identify candidates who can work well under pressure and meet deadlines.
- Q2. Interview was good questions asking them
- Q3. What was tha other option
- Ans.
The other option was to work as a customer service representative.
Customer service representative role involves handling customer inquiries and resolving issues.
Requires good communication skills and ability to remain calm under pressure.
Examples: answering phone calls, responding to emails, assisting customers with product information.
- Q4. First all company was chose a member skills analyse them
- Q5. A person was any problem solve them
- Q6. What are you strength and weakness as a telecaler
- Ans.
My strength as a telecaller is my excellent communication skills and ability to build rapport with customers. My weakness is sometimes I can be too detail-oriented, which may slow down my call volume.
Strength: Excellent communication skills
Strength: Ability to build rapport with customers
Weakness: Detail-oriented, which may slow down call volume
- Q7. Company has problems how could you motivate the manager
- Ans.
Motivate the manager by addressing the company's problems and offering support and solutions.
Listen to the manager's concerns and show empathy
Offer constructive feedback and solutions to address the problems
Provide resources and support to help the manager overcome challenges
Recognize and appreciate the manager's efforts and achievements
Encourage open communication and collaboration within the team
(1 Question)
- Q1. Each question answering and group discussion aptitude test pass assignment was response was good
(1 Question)
- Q1. Hr job was correct a person are rong are right choose them
Interview Preparation Tips
I applied via Approached by Company and was interviewed in Oct 2024. There were 3 interview rounds.
One coding test happen
(2 Questions)
- Q1. Java questions, spring boot framework questions
- Q2. DSA using stream api
- Ans.
Using stream API for Data Structures and Algorithms
Stream API in Java can be used to perform operations on collections like filtering, mapping, reducing, etc.
It can be used for implementing various data structures and algorithms efficiently.
For example, you can use stream API to find the sum of all elements in an array or filter out even numbers from a list.
(2 Questions)
- Q1. Java questions and spring boot questions
- Q2. One program using stream api
- Ans.
Using stream API to filter a list of numbers and find the sum of even numbers
Use Stream.filter() to filter out even numbers
Use Stream.mapToInt() to convert stream to IntStream
Use IntStream.sum() to find the sum of even numbers
Skills evaluated in this interview
Selected
I appeared for an interview before Jun 2024, where I was asked the following questions.
- Q1. Projects and scenario based questions
- Q2. Targets and logical abilities
- Q3. Work related test paper
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
(4 Questions)
- Q1. How do you optimize Stored procedure
- Ans.
Optimizing stored procedures involves using proper indexing, reducing unnecessary loops, and minimizing database calls.
Use proper indexing on columns used in WHERE clauses to improve query performance
Avoid using cursors and loops whenever possible, as they can be inefficient
Minimize the number of database calls by combining multiple queries into a single query or using temporary tables
Consider using bulk processing tec...
- Q2. How do you optimize SQL query
- Ans.
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
Use indexes on columns frequently used in WHERE clauses
Minimize data retrieval by selecting only necessary columns
Avoid unnecessary joins by using EXISTS or IN clauses instead
Optimize query structure by using appropriate join types and conditions
- Q3. What is use of returning clause
- Ans.
Returning clause is used to return a value from a function or procedure in PL/SQL.
Used to return a single value from a function or procedure
Can be used to return multiple values using OUT parameters
Helps in passing values back to the calling program
- Q4. Disadvantages of triggers
- Ans.
Triggers can lead to performance issues, complexity, and potential for unintended consequences.
Triggers can make code harder to debug and maintain
They can lead to cascading effects if not carefully implemented
Performance can be impacted if triggers are not optimized
Triggers can introduce dependencies between different parts of the codebase
Skills evaluated in this interview
Mamta Balakrishna
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Java program to split alpha-numeric values without using the split method
- Ans.
Split alpha-numeric values in Java without using split method
Iterate through each character in the input string
Check if the character is a digit or a letter using Character.isDigit() and Character.isLetter() methods
Create separate strings for digits and letters and store them in an array
- Q2. SQL query to add a new column to a table and the column value should have a default value and never be null
- Ans.
Use ALTER TABLE statement to add a new column with a default value and set it to NOT NULL
Use ALTER TABLE table_name ADD column_name data_type DEFAULT default_value NOT NULL;
Example: ALTER TABLE employees ADD hire_date DATE DEFAULT '2022-01-01' NOT NULL;
Selected
I appeared for an interview in May 2025, where I was asked the following questions.
- Q1. What is Active Directory?
- Ans.
Active Directory is a directory service by Microsoft for managing users, computers, and resources in a networked environment.
Centralized management of user accounts and permissions.
Supports Group Policy for enforcing security settings across devices.
Facilitates single sign-on (SSO) for accessing multiple applications.
Organizes resources in a hierarchical structure using domains, trees, and forests.
Example: Users can be...
- Q2. What are PST (Personal Storage Table) and OST (Offline Storage Table) files?
- Ans.
PST and OST files are data files used by Microsoft Outlook for storing emails, contacts, and calendar items.
PST files are used for storing emails and data locally on a computer.
OST files are used for offline access to emails when connected to an Exchange server.
PST files can be imported/exported easily, while OST files sync with the server.
Example: A PST file might be created for archiving old emails, while an OST file...
- Q3. What is the OSI model?
- Ans.
The OSI model is a conceptual framework used to understand network communication in seven layers.
Layer 1: Physical - Deals with the physical connection (e.g., cables, switches).
Layer 2: Data Link - Manages node-to-node data transfer (e.g., Ethernet).
Layer 3: Network - Handles routing of data (e.g., IP addresses).
Layer 4: Transport - Ensures complete data transfer (e.g., TCP, UDP).
Layer 5: Session - Manages sessions bet...
- Q4. How many layers are there in the OSI model, and what are their names?
- Ans.
The OSI model has 7 layers that standardize network communication protocols.
1. Physical Layer: Deals with the physical connection (e.g., cables, switches).
2. Data Link Layer: Manages node-to-node data transfer (e.g., Ethernet).
3. Network Layer: Handles routing of data packets (e.g., IP).
4. Transport Layer: Ensures reliable data transfer (e.g., TCP, UDP).
5. Session Layer: Manages sessions between applications (e.g., API...
- Q5. What are the steps to configure a printer using a DHCP IP address?
- Ans.
Steps to configure a printer using a DHCP IP address involve network setup, driver installation, and printer configuration.
Ensure the printer is connected to the network and powered on.
Access the printer's control panel to check its DHCP settings.
Obtain the printer's IP address from the control panel or print a configuration page.
On the computer, go to 'Devices and Printers' and select 'Add a Printer'.
Choose 'Add a net...
ITC Infotech Interview FAQs
The duration of ITC Infotech interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
ITC Infotech Interviews By Designations
- ITC Infotech Associate Information Technology Consultant Interview Questions
- ITC Infotech Lead Consultant Interview Questions
- ITC Infotech Associate Consultant Interview Questions
- ITC Infotech Software Developer Interview Questions
- ITC Infotech Associate IT Consultant 2 Interview Questions
- ITC Infotech IT Consultant Interview Questions
- ITC Infotech Software Engineer Interview Questions
- ITC Infotech Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Associate Information Technology Consultant Interview Questions
- Lead Consultant Interview Questions
- Associate Consultant Interview Questions
- Software Developer Interview Questions
- Associate IT Consultant 2 Interview Questions
- IT Consultant Interview Questions
- Software Engineer Interview Questions
- Java Developer Interview Questions
- Show more
Overall Interview Experience Rating
based on 366 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
ITC Infotech Reviews and Ratings
based on 4k reviews
Rating in categories
5-8 Yrs
₹ 9.5-26 LPA
6-8 Yrs
Not Disclosed
2-9 Yrs
Not Disclosed
|
Associate Information Technology Consultant
5.1k
salaries
|  ₹3.9 L/yr - ₹15 L/yr |
|
Lead Consultant
4.7k
salaries
| ₹9.2 L/yr - ₹36 L/yr |
|
Associate Consultant
943
salaries
| ₹2.5 L/yr - ₹19.2 L/yr |
|
Software Engineer
514
salaries
| ₹3.6 L/yr - ₹14.3 L/yr |
|
Senior Software Engineer
382
salaries
| ₹6.8 L/yr - ₹25.4 L/yr |
TCS
Mphasis
L&T Technology Services
Coforge
- Home >
- Interviews >
- ITC Infotech Interview Questions
