i
Infosys
Filter interviews by
Methods and best practices for cleaning up data include removing duplicates, handling missing values, standardizing formats, and validating data accuracy.
Remove duplicates by identifying and deleting identical records.
Handle missing values by imputing with mean, median, or mode.
Standardize formats by converting data into a consistent structure.
Validate data accuracy by cross-referencing with external sources or using d
Best practices for optimizing SQL code
Use indexes on columns frequently used in WHERE clauses
Avoid using SELECT * and only retrieve necessary columns
Optimize joins by using INNER JOIN instead of OUTER JOIN when possible
Avoid using subqueries and instead use JOINs or CTEs
Regularly analyze query performance using EXPLAIN or query execution plans
They asked questions on arithmetic, logical reasoning and english vocabulary and grammar.
I am a dedicated System Engineer with 5 years of experience in designing, implementing, and maintaining complex IT systems.
Experienced in network infrastructure design and implementation
Proficient in troubleshooting and resolving technical issues
Skilled in scripting and automation for system optimization
Certified in various IT certifications such as CCNA and MCSE
Code for sorting an array of strings
Use a sorting algorithm like bubble sort, selection sort, or quicksort
Compare strings using strcmp() function in C or compareTo() method in Java
Ensure the sorting algorithm is efficient and handles edge cases like empty array or duplicate strings
A function is a block of code that performs a specific task when called.
Functions can take input parameters and return output values
Functions can be reused multiple times in a program
Examples: sum(x, y) returns the sum of x and y, print(message) displays a message on the screen
Data types in C language define the type of data that a variable can store.
Basic data types include int, float, char, double, etc.
Derived data types include arrays, pointers, structures, unions, etc.
Example: int num = 10; char letter = 'A'; float value = 3.14;
I applied via Naukri.com and was interviewed in Nov 2024. There were 2 interview rounds.
Infosys interview questions for popular designations
I applied via infosys official website and was interviewed in Jul 2024. There were 3 interview rounds.
Developed a mobile app for tracking daily water intake and setting hydration goals.
Designed user interface for easy input of water consumption
Implemented reminder notifications to encourage regular hydration
Integrated with health tracking apps to sync data
Conducted user testing to gather feedback for improvements
Routing is the process of selecting the best path for data packets to travel from one network to another.
Routing involves determining the optimal path for data packets to reach their destination
Routers use routing tables to make decisions on how to forward packets
Routing protocols like OSPF and BGP help routers communicate and update routing information
Examples of routing protocols include RIP, EIGRP, and IS-IS
MVC is a design pattern for structuring web applications, while Web API is a framework for building HTTP services.
MVC stands for Model-View-Controller and is used for organizing code in web applications.
Web API is a framework for building HTTP services that can be accessed by various clients, not just browsers.
MVC is typically used for server-side rendering of web pages, while Web API is used for providing data and fun...
A class is a blueprint for creating objects, while an object is an instance of a class.
A class defines the properties and behaviors of objects, while an object is a specific instance of a class.
Classes can be used to create multiple objects with similar characteristics.
Objects can interact with each other by calling methods defined in their class.
Example: Class 'Car' defines properties like 'color' and 'model', while a...
No, we cannot create an object of a constructor directly.
Constructors are used to initialize objects of a class, not to create objects of the constructor itself.
To create an object, we use the 'new' keyword followed by the constructor function.
Example: function Person(name) { this.name = name; } var person1 = new Person('John');
SQL joins are used to combine rows from two or more tables based on a related column between them. The default join is an INNER JOIN.
SQL joins are used to retrieve data from multiple tables based on a related column between them
The default join in SQL is an INNER JOIN, which returns rows when there is at least one match in both tables
Other types of joins include LEFT JOIN, RIGHT JOIN, and FULL JOIN
Deployment in our project is done using automated scripts and tools to ensure consistency and efficiency.
Deployment scripts are written to automate the process of deploying code to different environments.
We use tools like Jenkins, Ansible, and Docker for continuous integration and deployment.
Each deployment goes through a series of automated tests to ensure stability and functionality.
Rollback procedures are in place i...
Get interview-ready with Top Infosys Interview Questions
I applied via Naukri.com and was interviewed in Jun 2024. There were 2 interview rounds.
I applied via Walk-in and was interviewed in Oct 2024. There were 3 interview rounds.
Array easy question and string handling and Java 8 based task
HashMap is a data structure in Java that stores key-value pairs and allows for fast retrieval of values based on keys.
HashMap is part of the Java Collections framework.
It uses hashing to store and retrieve elements quickly.
Example: HashMap
Manipulate an array of strings using various string methods.
Use String methods like substring, replace, toUpperCase, toLowerCase, etc.
Concatenate strings using '+' operator.
Split strings into arrays using split method.
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
What people are saying about Infosys
Some of the top questions asked at the Infosys interview -
The duration of Infosys interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 4.8k interviews
Interview experience
based on 39.4k reviews
Rating in categories
Technology Analyst
55.6k
salaries
| ₹3 L/yr - ₹11 L/yr |
Senior Systems Engineer
50.6k
salaries
| ₹2.8 L/yr - ₹8 L/yr |
System Engineer
39.5k
salaries
| ₹2.5 L/yr - ₹5.5 L/yr |
Technical Lead
30.7k
salaries
| ₹5.1 L/yr - ₹19.5 L/yr |
Senior Associate Consultant
27.9k
salaries
| ₹4.5 L/yr - ₹16.8 L/yr |
TCS
Wipro
Cognizant
Accenture