Oxalis Pharmaceuticals Technical Specialist Interview Questions and Answers

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. Share your difficult situation?
Ans. 
I faced a difficult situation when a critical project deadline was approaching and we encountered unexpected technical issues.
• Technical issues arose during a critical project

• Deadline was approaching

• Had to find quick solutions to resolve the issues

• Coordinated with team members to troubleshoot and fix the problems

• Implemented contingency plans to ensure project completion on time
Answered by AI
Add your answer

Q1. Az values and principles. And Jab related questions
Add your answer

Q1. About the previous exp
Add your answer

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

Aptitude test was there with general MCQ

Excel as well as coding test for technical knowledge

Q1. Asked about information about pharmacy products
Add your answer

Q1. Market research, Pricing and RI, EU and US healthcare system
Add your answer

Q1. Why do you want to join Eversana
Add your answer

Q1. Design patterns
Add your answer

Q1. Current project architecture
Ans. 
The current project architecture is a microservices-based architecture.
• The project is divided into multiple small, independent services.

• Each service is responsible for a specific functionality.

• Services communicate with each other through APIs or message queues.

• The architecture allows for scalability, fault tolerance, and easier maintenance.

• Example: The project uses Docker containers for each service.
Answered by AI
Add your answer