i
ITC Infotech
Filter interviews by
I applied via AmbitionBox and was interviewed in Nov 2024. There were 4 interview rounds.
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
Data analysis of code in the context of data analysis.
Coding logical question paper.
I applied via Approached by Company and was interviewed in Oct 2024. There were 3 interview rounds.
One coding test happen
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.
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
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
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...
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
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
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
I applied via Approached by Company and was interviewed in Nov 2024. There was 1 interview round.
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
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;
ITC Infotech interview questions for popular designations
I applied via Walk-in and was interviewed in Aug 2024. There were 3 interview rounds.
Our company is a leading provider of HR solutions, specializing in recruitment, training, and consulting services.
Founded in 2005 by John Smith
Headquartered in New York City
Clients include Fortune 500 companies such as Google and Microsoft
Offers a wide range of services including talent acquisition, leadership development, and HR technology solutions
Experienced HR professional with a passion for talent development and employee engagement.
Over 8 years of experience in HR roles
Skilled in recruitment, training, and performance management
Led initiatives to improve employee satisfaction and retention
Strong communication and interpersonal skills
Bachelor's degree in Human Resources Management
I have been following the company's growth and success in the industry for several years.
I have been a loyal customer of the company for the past 5 years.
I regularly read industry news and updates, and this company has been featured multiple times.
I have friends who work at the company and have shared positive feedback about the work culture.
My name is John Doe.
Full name is John Doe
Common first and last name combination
Easy to remember and pronounce
I plan to stay long-term and grow with the company.
I am committed to the company's long-term goals and vision.
I am looking for stability and opportunities for growth within the organization.
I am excited about the potential to contribute to the company's success over the long term.
Get interview-ready with Top ITC Infotech Interview Questions
I applied via Naukri.com and was interviewed in Sep 2024. There were 2 interview rounds.
I have 5 years of experience working with Next.js, building dynamic and responsive web applications.
5 years of experience with Next.js
Proficient in building dynamic and responsive web applications
Strong understanding of React and JavaScript
Experience with server-side rendering and API integration
Portfolio includes projects showcasing Next.js skills
I have worked on 5 projects using Next.js for building dynamic web applications.
Developed a company website using Next.js for improved performance and SEO optimization
Created a blog platform with server-side rendering using Next.js
Integrated authentication and authorization features using NextAuth.js in an e-commerce project
Utilized API routes in Next.js to fetch and display data dynamically
Implemented dynamic routing
Given an array of numbers. each item is the price of a product per day (key). Find a solution that calculates the best day to sell an item and the best day to buy an item
I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.
Horizontal scaling involves adding more machines to your network, while vertical scaling involves adding more power to an existing machine.
Horizontal scaling increases the number of machines in the network to distribute the load, while vertical scaling increases the power of a single machine.
Horizontal scaling is more cost-effective and easier to implement than vertical scaling.
Examples of horizontal scaling include ad...
I applied via Monster and was interviewed in May 2024. There was 1 interview round.
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
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
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.
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");
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.
Convert array to ArrayList of strings
Create a new ArrayList
Use Arrays.asList() method to convert array to ArrayList
Example: String[] array = {"apple", "banana", "orange"}; ArrayList
Top trending discussions
Interview experience
based on 3.5k reviews
Rating in categories
Associate Information Technology Consultant
5.2k
salaries
| ₹4.1 L/yr - ₹17 L/yr |
Lead Consultant
4.4k
salaries
| ₹9 L/yr - ₹35.4 L/yr |
Associate Consultant
854
salaries
| ₹2.5 L/yr - ₹16 L/yr |
Software Engineer
501
salaries
| ₹4 L/yr - ₹14 L/yr |
Senior Software Engineer
362
salaries
| ₹6.4 L/yr - ₹27 L/yr |
TCS
Wipro
HCLTech
Tech Mahindra