Citicorp Senior Data Scientist Interview Questions and Answers

Q1. Base on SQL and tableau
Add your answer
Q2. How join work share in detail with examples
Add your answer
Q3. How to get nth salary
Add your answer
Q4. How to delete duplicates
Ans. 
To delete duplicates, use SQL query with DISTINCT keyword or remove duplicates programmatically in Python using sets.
• Use SQL query with DISTINCT keyword to remove duplicates from a database table

• In Python, remove duplicates from a list using sets: list(set(original_list))

• For pandas DataFrame, drop duplicates using df.drop_duplicates()
Answered by AI
Add your answer

Q1. Live coding on the platform
Add your answer

Q1. Basic Java and react question
Add your answer

Q1. Little technical and project oriented question
Add your answer

Basic hacker rank problem

Q1. Asked few questions on react and java
Add your answer

Basic maths questions

Basic topics movies vs series

Q1. Sql Queries were asked
Add your answer
Q2. Was based on resume
Add your answer

Q1. Based on resume the questions were
Add your answer
Q2. Questions about family
Add your answer

General knowledge and development skills and new things..

SQL server

SQL DBA

Q1. Salary discussed, Appts test
Add your answer

Q1. 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 - [1, 2, 3], tuple - (1, 2, 3)
Answered by AI
Add your answer

An easy coding round was conducted that involved SQL questions.

An easy one-hour discussion based on the resume.