Sinsan Pharmaceuticals Senior Technical Lead Interview Questions and Answers

Q1. What is SCD and types of SCD
Ans. 
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
Answered by AI
Add your answer
Q2. SQL query for join
Ans. 
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
Answered by AI
Add your answer
Q3. What is MDM
Ans. 
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.
Answered by AI
Add your answer

Q1. All related to previous work experiences
Add your answer

Q1. SQL related - Joins, Range, Limits
Add your answer
Q2. .Net related - syntax, basic programs
Add your answer

Q1. Previous experience
Add your answer
Q2. Comfortability with shifts
Add your answer

Q1. What are the basics of power bi
Ans. 
Power BI is a business analytics tool by Microsoft for visualizing and analyzing data.
• Power BI is a business analytics tool by Microsoft

• It allows users to visualize and analyze data from various sources

• Users can create interactive reports and dashboards

• Power BI offers a wide range of data connectors for seamless integration

• It provides features like data modeling, data preparation, and data visualization

• Power BI can be ...read more
Answered by AI
Add your answer

Q1. Basics of java ,spring and sql
Add your answer

Q1. Situation based questions and why do u want to get this job
Add your answer

Q1. What is lamda function
Ans. 
Lambda function is an anonymous function in programming that can have multiple arguments but can only have one expression.
• Lambda functions are used for creating small, one-time use functions without the need to define a formal function.

• They are often used in functional programming languages like Python.

• Lambda functions can take any number of arguments, but can only have one expression.

• Example: lambda x: x*2 defines a l
Answered by AI
Add your answer
Q2. Difference between list and tuple
Ans. 
List is mutable, tuple is immutable in Python.
• List can be modified after creation, tuple cannot.

• List uses square brackets [], tuple uses parentheses ().

• List is used for collections of items that may change, tuple for fixed collections.

• Example: list_example = [1, 2, 3], tuple_example = (4, 5, 6)
Answered by AI
Add your answer

Q1. Explain your previous work experience
Add your answer
Q2. Explain with example how your work related to real life example
Add your answer

Area knowledge discussion and he asked
percentage questions

Q1. All on Data Structures and algorithms mainly
Add your answer

Q1. Interview with senior manager with few technical questions and more on behavioural
Add your answer

Q1. All HR stuffs about salary Expectation and relocating to chennai
Add your answer