AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Syngene International Data Scientist Interview Questions and Answers
Syngene International Data Scientist Interview Experiences
1 interview found
Anonymous
I applied via Recruitment Consulltant and was interviewed in Oct 2024. There was 1 interview round.
(1 Question)
- Q1. Pandas Manipulation
Top trending discussions
Interview questions from similar companies
I was interviewed before Feb 2021.
(3 Questions)
- Q1. Share details of your previous job.
- Q2. Why are you looking for a change?
- Q3. Tell me about yourself.
House price prediction
(1 Question)
- Q1. About data, data science and Pharma domain
Interview Preparation Tips
Selected
I applied via Referral and was interviewed before Jan 2024. There were 2 interview rounds.
(1 Question)
- Q1. Some basic questions of excel, SQL and Python. Focused more on projects mentioned in CV
How much you rate in Python and SQL
I applied via Approached by Company and was interviewed before Jun 2021. There were 2 interview rounds.
(1 Question)
- Q1. How many years you stay in this organisation?
- Ans. This organisation is really good, if I thought I will continues upto retirement.
Interview Preparation Tips
I applied via Campus Placement and was interviewed before Feb 2020. There were 5 interview rounds.
Interview Questionnaire
8 Questions
- Q1. Tell me about yourself
- Q2. Interest in job role
- Q3. Previous work experience if any
- Q4. Hobbies,interests, project details
- Q5. Family background
- Q6. Why should we hire you
- Q7. How much salary you are expecting
- Q8. Any questions you can ask
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Apr 2023. There were 3 interview rounds.
Maths, logical reasoning, 1.5 hrs
(3 Questions)
- Q1. About sql joins, python sets, lists, etc
- Q2. Queries, union etc
- Q3. Project related questions
Interview Preparation Tips
Piraamal finance jnlnm knkn
(2 Questions)
- Q1. What is sql? and where to use
- Ans.
SQL is a programming language used for managing and manipulating relational databases.
SQL stands for Structured Query Language
Used to retrieve, update, and manage data in relational databases
Commonly used in data analysis, data manipulation, and data reporting
Examples: SELECT * FROM table_name, INSERT INTO table_name VALUES (value1, value2)
- Q2. Power bi description and its imp
- Ans.
Power BI is a business analytics tool by Microsoft that provides interactive visualizations and business intelligence capabilities.
Power BI allows users to connect to a wide variety of data sources and create interactive reports and dashboards.
Users can easily share their insights with others and collaborate in real-time.
It offers features like data modeling, data preparation, and data visualization to help organizatio...
Interview Preparation Tips
Calculation and Logics
(1 Question)
- Q1. Programming and problem solving
I applied via IIM Jobs and was interviewed in Mar 2023. There were 3 interview rounds.
Questions related to quantitative aptitude , Logical reasoning , Data Interpretation and English Comprehension . The level of the questions asked will be moderate anyone can easily crack the interview test . But try to be good in any two of the above mentioned topic so that you can clear it easily,
(3 Questions)
- Q1. Advance level sql and excel question will be asked first but they are only asked to check your knowledge even if you answer them correctly it won't guarantee you of getting placed . The main part of the in...
- Q2. SQL : - Question related to advance level sql like windows function.
- Q3. Excel :- Difference between vlookup and Index(Match)
- Ans.
VLOOKUP searches for a value in the first column of a table and returns a corresponding value in the same row. INDEX/MATCH uses two functions to look up a value based on its position in a table.
VLOOKUP only searches for values in the first column of a table, while INDEX/MATCH can search for values in any column.
INDEX/MATCH is more flexible and efficient for large datasets.
VLOOKUP is easier to use for simple lookups wit...
Interview Preparation Tips
- Puzzles
- SQL
- MS Excel
Skills evaluated in this interview
Interview Questionnaire
7 Questions
- Q1. Asked basic questions of sql server & ssis
- Q2. What are views and will the alter command on table changes anything in views created? Will the values change in views, if the table values changes?
- Ans.
Alter command on table affects views created on the table.
Views are virtual tables created from one or more tables.
Alter command on a table can change the structure of the table, which can affect the views created on it.
If the columns used in the view are altered or dropped, the view will become invalid.
If the data in the table is changed, the data in the view will also change accordingly.
- Q3. What are the data transformations in ssis? What is lookup?
- Ans.
Data transformations in SSIS include Lookup which retrieves data from a source based on a matching condition.
Lookup is used to retrieve data from a source based on a matching condition
It can be used to perform joins between two data sources
Lookup can be used to update or insert data into a destination based on a match
Other data transformations in SSIS include sorting, aggregating, and merging data
- Q4. Difference between drop, truncate & delete?
- Ans.
Drop deletes the table structure and data, truncate deletes only data, and delete deletes specific rows.
Drop: removes the table and all its data permanently
Truncate: removes all data from the table but keeps the structure
Delete: removes specific rows from the table based on a condition
Drop and truncate cannot be rolled back, but delete can be
Drop and truncate reset the identity of the table, but delete does not
- Q5. When identity property is inserted in the table. Will the truncate or delete change the identity value? If it changes what will be the value?
- Ans.
Truncate resets identity value, delete does not.
Truncate resets the identity value to the original seed value
Delete does not change the identity value
Example: Truncate table resets identity value to 1
Example: Delete from table does not change identity value
- Q6. What are joins and name the types? Why is self join useful?
- Ans.
Joins are used to combine data from two or more tables based on a related column. Types include inner, outer, left, right, and cross join.
Inner join returns only the matching rows from both tables.
Outer join returns all rows from both tables, with null values for non-matching rows.
Left join returns all rows from the left table and matching rows from the right table.
Right join returns all rows from the right table and m...
- Q7. Write a query using self join to join the employees who are all managers using id in the table.
- Ans.
Query to join employees who are all managers using id in the table.
Use self join to join the table on manager id and employee id
Filter the result to only include employees who are also managers
Example: SELECT e1.name, e2.name FROM employees e1 JOIN employees e2 ON e1.id = e2.manager_id WHERE e2.manager_id IS NOT NULL
Ensure that the table has a manager_id column
Interview Preparation Tips
Skills evaluated in this interview
Syngene International Interview FAQs
Tell us how to improve this page.
Syngene International Interviews By Designations
- Syngene International Research Associate Interview Questions
- Syngene International Senior Research Associate Interview Questions
- Syngene International Executive Interview Questions
- Syngene International Junior Manager Interview Questions
- Syngene International Associate Scientist Interview Questions
- Syngene International Junior Executive Interview Questions
- Syngene International Senior Executive Interview Questions
- Syngene International Associate Executive Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Scientist Interview Questions
- Decision Scientist Interview Questions
- Jr. Data Scientist Interview Questions
- Associate Data Scientist Interview Questions
- Data Scientist Intern Interview Questions
- Lead Data Scientist Interview Questions
- Trainee Decision Scientist Interview Questions
- Research Scientist Interview Questions
- Show more
Syngene International Data Scientist Interview Process
based on 1 interview
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
|
Senior Research Associate
1.3k
salaries
|  ₹0 L/yr - ₹0 L/yr |
|
Research Associate
1.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Senior Executive
1k
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Associate Scientist
793
salaries
| ₹0 L/yr - ₹0 L/yr |
|
Executive
730
salaries
| ₹0 L/yr - ₹0 L/yr |
Biocon Limited
Piramal Group
Wockhardt
Strides Pharma
- Home >
- Interviews >
- Syngene International Interview Questions >
- Syngene International Data Scientist Interview Questions
