Optiva Interview Questions and Answers

Q1. Support Role Questions 1) Like explaining a case which was done in your previous role and experience
Add your answer
Q2. Questions on Javascript
Add your answer

Q1. Technical Interview questions on Javascript, HTML, CSS and behavioural
Add your answer

Q1. Manager Questions based on Position and previous work experience.
Add your answer

Q1. What is difference between rank and dense rank?
Add your answer
Q2. What is RLS in Power Bi?
Add your answer

Q1. How would you identify time for any project?
Add your answer

Q1. Core java based questions, followed by springboot and then sql queries
Add your answer

Q1. Scenario based java and spring boot questions and more complex sql queries
Add your answer

Q1. Previous project related questions like difficulty faced in project, how you overcome that, day to day routine, discussed role in projects
Add your answer

Q1. Salary discussion and onboarding instructions
Add your answer

Basic Python, SQL, and Bash questions

Q1. SQL questions with operations that include changing from string to array. Tip: stick to RDBMS-specific dialects only (like Postgres), I used Spark SQL
Add your answer
Q2. Simple Python questions with a follow-up to optimise it
Add your answer
Q3. Bash script-based questions, are pretty basic.
Add your answer
Q4. Data pipeline design and best practices.
Ans. 
Data pipeline design involves creating a system to efficiently collect, process, and analyze data.
• Understand the data sources and requirements before designing the pipeline.

• Use tools like Apache Kafka, Apache NiFi, or AWS Glue for data ingestion and processing.

• Implement data validation and error handling mechanisms to ensure data quality.

• Consider scalability and performance optimization while designing the pipeline.

• Doc...read more
Answered by AI
Add your answer

Q1. Easy to medium Leetcode-based question. With moderate difficulty.
Add your answer
Q2. Simple Python-based question with optimisation.
Add your answer
Q3. Design specific questions based on Data pipelines.
Add your answer

Q1. SQL-based question with moderate difficulty.
Add your answer
Q2. Python-based questions, follow questions with some optimisations.
Add your answer
Q3. Bash-script based round.
Add your answer

Q1. Machine Learning-related stuff: Confusion Matrix, R2 score, etc.. Also, Python & Statistics.
Add your answer
Q2. Explain any one project.
Add your answer
Q3. Difference between Data Analyst and Data Scientist.
Ans. 
Data Analyst focuses on analyzing data to provide insights, while Data Scientist focuses on using advanced algorithms and machine learning to predict future trends.
• Data Analyst focuses on analyzing data to provide insights for decision-making.

• Data Scientist focuses on using advanced algorithms and machine learning to predict future trends.

• Data Analyst typically works with structured data, while Data Scientist works wit...read more
Answered by AI
Add your answer

Mainly data leakage related problems

Q1. Basic Swift and Objective C related questions
Add your answer
Q2. SOLID principle
Add your answer
Q3. Details of SOLID principle with its basic
Add your answer
Q4. How to handle memory leakage
Ans. 
Best practices for handling memory leaks in iOS development
• Use Instruments to identify memory leaks

• Avoid strong reference cycles with weak or unowned references

• Use autorelease pools for temporary objects

• Implement proper memory management with ARC (Automatic Reference Counting)
Answered by AI
Add your answer
Q5. Memory management
Add your answer