Bliss Gvs Pharma Quality Analyst Interview Questions and Answers

SCD refers to Slowly Changing Dimensions in data warehousing, managing changes in data over time.

• Type 0: Passive - No changes are made to the existing data. Example: Historical data remains unchanged.

• Type 1: Overwrite - Old data is replaced with new data. Example: Correcting a misspelled name.

• Type 2: Add New Row - A new record is created for changes, preserving history. Example: Tracking changes in customer addresses.

• T...read more

SQL joins combine rows from two or more tables based on related columns.

• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the right table and matched records from the left ...read more

MDM stands for Master Data Management, a process for managing critical data across an organization.

• Ensures consistency and accuracy of key business data across systems.

• Involves data governance, data quality, and data integration.

• Examples include managing customer, product, and supplier data.

• Helps in decision-making by providing a single source of truth.

NDT testing stands for Non-Destructive Testing, a method of testing materials without causing damage to them.

• NDT testing is used to detect flaws or defects in materials or products

• It is commonly used in industries such as aerospace, automotive, and construction

• Examples of NDT testing methods include ultrasonic testing, radiography, and magnetic particle testing

Process audit is a systematic examination of a process to ensure it is meeting its objectives and requirements.

• Process audit involves reviewing the process documentation, observing the process in action, and interviewing process stakeholders.

• The goal of a process audit is to identify areas for improvement and ensure the process is efficient, effective, and compliant with standards and regulations.

• Examples of processes ...read more

Product audit is a systematic examination of a product to ensure it meets the specified requirements and standards.

• Product audit is a quality control process that involves examining a product to ensure it meets the required specifications.

• It involves checking the product's design, manufacturing process, and final output.

• Product audit helps to identify defects, non-conformities, and areas for improvement.

• Examples of pro...read more