Infosys Interview Questions and Answers for Experienced

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...read more

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...read more

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...read more

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...read more

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...read more

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...read more

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...read more

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...read more