Cognizant Senior Associate Interview Questions and Answers for Freshers

I have worked on various types of dashboards in Tableau including interactive dashboards, performance dashboards, and executive dashboards.

• Interactive dashboards

• Performance dashboards

• Executive dashboards

The ETL tool used for Data wrangling is Apache Spark. I have a high proficiency in using Apache Spark for ETL processes.

• Apache Spark is a powerful open-source distributed computing system that can handle large-scale data processing and analytics.

• It provides a unified engine for big data processing with built-in modules for SQL, streaming, machine learning, and graph processing.

• I have experience in using Apache Spark for data wrangling tasks such as data cleaning, transformati...read more

Joiner transformation - connected and unconnected look up difference

• Joiner transformation is used to join two sources based on a common key

• Connected lookup is used when the lookup table is in the same mapping

• Unconnected lookup is used when the lookup table is outside the mapping

• Connected lookup returns multiple rows while unconnected lookup returns only one row

• Joiner transformation can be used with both connected and unconnected lookup

Design patterns are reusable solutions to common software development problems.

• Design patterns provide a common language for developers to communicate about solutions.

• They can improve code quality, maintainability, and scalability.

• Examples include the Singleton, Factory, and Observer patterns.

• Design patterns can be categorized into creational, structural, and behavioral patterns.

Request Delegate is a middleware component in ASP.NET Core pipeline.

• Request Delegate is responsible for handling HTTP requests and generating HTTP responses.

• It is a function that takes an HttpContext object as input and returns a Task.

• It can be used to modify the request or response, or to pass the request to the next middleware component in the pipeline.

• Example: app.Use(async (context, next) => { await next(); });