Cognizant Project Associate Interview Questions, Process, and Tips

Data flows from Data Warehouse to downstream through ETL process and data transformation.

• Data is extracted from Data Warehouse using ETL tools like Informatica, Talend, etc.

• Data is transformed and cleansed using various data transformation techniques.

• Transformed data is loaded into downstream systems like Hadoop, Spark, etc.

• Data is dumped into downstream systems for further processing and analysis.

Tokenisation in MDM is the process of replacing sensitive data with unique identifiers.

• Tokenisation helps in securing sensitive data by replacing it with a unique identifier or token.

• The token can be used for data processing and analysis without exposing the original data.

• For example, credit card numbers can be tokenised to protect them from theft or misuse.

• Tokenisation is different from encryption as it does not requi...read more

Match and merge rules determine how records are matched and merged in a database. Match level refers to the criteria used to identify potential matches, while search level refers to the process of finding and comparing those potential matches.

• Match rules define the criteria used to identify potential matches between records.

• Merge rules determine how those potential matches are combined into a single record.

• Match level ...read more

Provisioning tool is used to automate the process of setting up and managing resources. Layout designer is a tool to design the layout of the provisioning portal. Reference entity is a data model used in provisioning.

• Provisioning tool automates the process of setting up and managing resources

• Layout designer is a tool to design the layout of the provisioning portal

• Reference entity is a data model used in provisioning

• Pro...read more