i
Infosys
Work with us
Filter interviews by
Multithreading involves multiple threads within a single process, while multiprocessing uses multiple processes for parallel execution.
Multithreading shares the same memory space, making it lightweight and faster for tasks like I/O operations.
Multiprocessing has separate memory spaces, which can lead to better performance for CPU-bound tasks.
Example of multithreading: A web server handling multiple requests simult...
Static routing is a method of manually configuring routes in a network, providing fixed paths for data packets.
Static routes are manually configured by a network administrator.
They do not change unless manually altered, providing predictable routing.
Useful in small networks where routes are unlikely to change.
Example: A static route can be set to direct traffic from a local network to a specific gateway.
Static rou...
VLANs segment networks for improved performance and security by creating virtual networks within a physical network.
VLAN stands for Virtual Local Area Network, allowing logical segmentation of networks.
Improves security by isolating sensitive data traffic from general traffic.
Enhances performance by reducing broadcast domains, minimizing unnecessary traffic.
Example: A company can create separate VLANs for HR, Fina...
An Internet Service Provider (ISP) is a company that provides individuals and organizations access to the Internet.
ISPs can be local, regional, or national, such as Comcast, AT&T, or Verizon.
They offer various services including broadband, dial-up, and fiber-optic connections.
ISPs may also provide additional services like email hosting, web hosting, and domain registration.
Some ISPs operate as mobile network p...
Network security involves measures to protect data and resources in a network from unauthorized access and attacks.
Firewalls: Act as barriers between trusted and untrusted networks, controlling incoming and outgoing traffic.
Intrusion Detection Systems (IDS): Monitor network traffic for suspicious activity and alert administrators.
Encryption: Protects data in transit and at rest, ensuring that only authorized users...
HTML5 is the latest version of the Hypertext Markup Language, enhancing web development with new features and improved semantics.
Introduces new semantic elements like <article>, <section>, <header>, and <footer> for better structure.
Supports multimedia with <audio> and <video> tags, allowing easy embedding of media without plugins.
Includes the Canvas API for dynamic, scriptable ...
Snowflake architecture separates storage, compute, and services for efficient data management and scalability.
Multi-Cloud Architecture: Snowflake operates on AWS, Azure, and Google Cloud, allowing flexibility in deployment.
Separation of Storage and Compute: Users can scale storage and compute resources independently, optimizing costs.
Data Sharing: Snowflake enables secure and governed data sharing across different...
An end-to-end implementation in SAP PO involves integration, configuration, and deployment of processes across systems.
Define project scope and objectives, including business requirements.
Design integration scenarios using SAP PO tools like Integration Designer.
Configure adapters (e.g., IDoc, SOAP, REST) for communication between systems.
Develop and test mappings to transform data formats as needed.
Deploy the inte...
I am familiar with various utilities and abends in mainframe development, including their resolution techniques.
Common utilities include IDCAMS for data set management and DFSORT for data sorting.
Abend codes like S0C4 indicate a storage violation; resolved by checking for uninitialized variables.
S322 abend occurs due to time-out; resolved by optimizing the job or increasing the time limit.
Using tools like Abend-AI...
Data is passed to COBOL from JCL using DD statements to define input datasets and parameters.
Use DD statements in JCL to define datasets for COBOL programs.
Example: //INPUTFILE DD DSN=MY.DATASET, DISP=SHR to pass a dataset.
Use SYSIN DD for passing parameters directly to COBOL programs.
Example: //SYSIN DD * followed by input data in the JCL.
I appeared for an interview in Jan 2025.
Snowflake offers a unique architecture that separates storage and compute, providing scalability, flexibility, and cost-effectiveness.
Snowflake's architecture separates storage and compute, allowing for independent scaling of each component.
Snowflake uses virtual warehouses to allocate compute resources on-demand, optimizing performance and cost.
Snowflake's multi-cluster shared data architecture enables seamless collab...
Time travel refers to the ability to query historical data in Snowflake, while fail safe refers to the system's ability to maintain data integrity and availability in case of failures.
Time travel allows users to query data as it existed at a specific point in the past, using the TIMESTAMP parameter in queries.
Fail safe mechanisms in Snowflake ensure data integrity and availability by automatically handling system failu...
Live feed is real-time data while extract is historical data.
Live feed is data that is constantly updated in real-time.
Extract is historical data that is extracted at a specific point in time.
Live feed is commonly used for monitoring real-time events, while extract is used for analysis of past data.
Examples: Twitter feed is live data, while a monthly sales report is an extract.
Join combines data from two or more tables based on a related column, while data blending combines data from different sources without a direct relationship.
Join is used to combine data from multiple tables based on a common column.
Data blending is used to combine data from different sources without a direct relationship.
Join requires a common column to match records, while data blending does not require a common colum...
I appeared for an interview in Feb 2025, where I was asked the following questions.
I struggle with expressing my answers confidently, even when I know them to be correct.
I often second-guess my responses during discussions, fearing they may be incorrect.
In team meetings, I hesitate to share my ideas, even when I have valuable insights.
For example, during a recent project, I had a solution but didn't voice it, leading to delays.
I am working on this by practicing assertiveness and seeking feedback from...
I appeared for an interview in Jan 2025.
HF stands for Heavy Forwarder, used for data forwarding and processing. UF stands for Universal Forwarder, used for lightweight data forwarding only.
HF is used for data forwarding, processing, and indexing, while UF is used for lightweight data forwarding only
HF can parse and index data locally, while UF can only forward data to indexers
HF requires more resources and is typically deployed on dedicated hardware, while U...
DS in Splunk stands for Data Source.
DS refers to the source of data that is being indexed and analyzed in Splunk.
Common data sources in Splunk include log files, metrics, and events from various systems and applications.
DS can also refer to the Data Summary feature in Splunk, which provides a summary of indexed data.
stats, eventstats, streamstats, and tstats are different Splunk commands used for statistical analysis.
stats: used to calculate statistics on the events in the search results.
eventstats: used to calculate statistics on the events in the search results, but the results are added as new fields to each event.
streamstats: used to calculate statistics on the events in the search results, but the results are added as new fie...
In Splunk, the priority of files is determined by the order in which they are indexed.
Files are indexed based on the inputs.conf configuration file.
Priority can be set using the 'disabled' attribute in inputs.conf.
Files with higher priority are indexed first.
Priority can also be influenced by the order of stanzas in inputs.conf.
I applied via Job Portal and was interviewed in Dec 2024. There were 2 interview rounds.
CCW stands for Counterclockwise while DIS CCW stands for Disconnected Counterclockwise.
CCW refers to a direction of rotation that is opposite to the clockwise direction.
DIS CCW refers to a situation where something is disconnected from its counterclockwise rotation.
Example: Turning a screw counterclockwise is CCW, while a disconnected counterclockwise rotation could refer to a malfunctioning gear.
Example: In a motor, C...
PECI stands for Problem, Etiology, Context, and Intervention, while PICOF stands for Population, Intervention, Comparison, Outcome, and Timeframe.
PECI is used in problem-solving to identify and address issues, while PICOF is used in research to formulate a research question.
PECI focuses on the problem, its causes, the context in which it occurs, and potential interventions to address it.
PICOF focuses on defining the po...
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There were 2 interview rounds.
Docker images provide a lightweight, portable, and consistent environment for running applications.
Docker images encapsulate all dependencies and configurations needed for an application to run
They can be easily shared and deployed across different environments
Docker images are immutable, ensuring consistency and reproducibility
Containers based on Docker images are isolated from the host system, enhancing security
Docke...
I applied via Referral and was interviewed in Oct 2024. There were 3 interview rounds.
Seeking new challenges and growth opportunities in a more innovative environment.
Looking for new challenges and opportunities for growth
Interested in working in a more innovative environment
Seeking a better work-life balance
My workday as a Snowflake Developer involves data modeling, ETL processes, and collaborating with teams to optimize data solutions.
Start the day by reviewing project requirements and prioritizing tasks.
Collaborate with data engineers to design and implement ETL pipelines.
Monitor Snowflake performance and optimize queries for efficiency.
Conduct code reviews and provide feedback to team members.
Participate in daily stand...
I worked on developing data pipelines for ingesting and processing large volumes of data in Snowflake.
Designed and implemented ETL processes using Snowflake's features like Snowpipe and tasks.
Optimized SQL queries for performance and scalability.
Collaborated with data engineers and analysts to understand requirements and deliver solutions.
Implemented data quality checks and monitoring processes to ensure data integrity...
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
I appeared for an interview in Nov 2024.
Editing data in complex views can affect underlying tables, but it depends on the view's structure and rules.
Complex views often involve joins, aggregations, or groupings, making them non-updatable.
If a view is updatable, changes made to it will reflect in the underlying tables.
Example: A simple view on a single table can be updated directly.
Example: A view that aggregates data (e.g., SUM, COUNT) cannot be updated dire...
Performance tuning involves optimizing database queries and configurations for improved efficiency and speed.
Analyze execution plans to identify slow queries. For example, use EXPLAIN PLAN to see how Oracle executes a query.
Use indexing strategically. For instance, create indexes on columns frequently used in WHERE clauses to speed up data retrieval.
Optimize SQL queries by avoiding SELECT *, using WHERE clauses effecti...
Regular expressions (regex) are sequences of characters that define search patterns for strings, used for pattern matching and manipulation.
Regex is used for validating input formats, e.g., email addresses: ^[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}$
It can extract specific patterns from text, such as phone numbers: \d{3}-\d{3}-\d{4}
Regex supports various metacharacters like '.', '*', and '+', which have special me...
Control key in SAP is important for defining the behavior of a particular operation or transaction in the system.
Control key determines how a particular operation or transaction will be executed in SAP PP.
It helps in defining the scheduling parameters, lead time, and other relevant details for a specific task.
Examples of control keys include PP01 for standard production order, PP02 for production order with project sto...
Different types of MRP in SAP include MRP, MRP Live, and MRP Areas.
MRP (Material Requirements Planning) is the traditional MRP functionality in SAP.
MRP Live is the new MRP functionality introduced in SAP S/4HANA.
MRP Areas allow for planning at a more detailed level within a plant or storage location.
Important configurations in SAP PP include work centers, routing, production versions, and material master data.
Work centers: Define where and how production operations are carried out.
Routing: Specifies the sequence of operations in production.
Production versions: Used to manage different versions of a product's BOM and routing.
Material master data: Contains all the information about materials used in production.
What people are saying about Infosys
Some of the top questions asked at the Infosys interview for experienced candidates -
The duration of Infosys interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 1.4k interview experiences
Difficulty level
Duration
based on 43.2k reviews
Rating in categories
Technology Analyst
54.7k
salaries
| ₹4.8 L/yr - ₹10 L/yr |
Senior Systems Engineer
53.8k
salaries
| ₹2.5 L/yr - ₹6.3 L/yr |
Technical Lead
35.1k
salaries
| ₹9.4 L/yr - ₹16.4 L/yr |
System Engineer
32.5k
salaries
| ₹2.4 L/yr - ₹5.3 L/yr |
Senior Associate Consultant
31.3k
salaries
| ₹8.2 L/yr - ₹15 L/yr |
TCS
Wipro
Cognizant
Accenture