Oracle Senior Data Engineer Interview Questions and Answers

Q1. Medium Leetcode
Add your answer
Q2. System Design Interview Question
Add your answer

Basic self evaluation test.

Q1. What project I have completed and follow-up questions on that?
Add your answer
Q2. How to handle class imbalance.
Ans. 
Handling class imbalance involves techniques like resampling, using different algorithms, and adjusting class weights.
• Use resampling techniques like oversampling or undersampling to balance the classes.

• Utilize algorithms that are robust to class imbalance, such as Random Forest, XGBoost, or SVM.

• Adjust class weights in the model to give more importance to minority class.

• Use evaluation metrics like F1 score, precision, r...read more
Answered by AI
Add your answer
Q3. Basic Python coding questions.
Add your answer

Q1. Data-related questions.
Add your answer
Q2. ML Ops questions.
Add your answer

Topics on electronics and C programming

Q1. Questions on simple python programs and electronics basics
Add your answer
Q2. Question on simple linked list
Add your answer
Q3. Program for fibonacci seq
Ans. 
Program to generate Fibonacci sequence
• Start with two initial numbers, 0 and 1

• Add the previous two numbers to get the next number in the sequence

• Repeat this process to generate the Fibonacci sequence

• Example: 0, 1, 1, 2, 3, 5, 8, 13, ...
Answered by AI
Add your answer
Q4. Questions on mosfets
Add your answer

Q1. Why you would like to join the company, and other questions
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

It is nice to do work

It helps in understanding the 5

It helps a lot in company

Q1. How to do job in company?
Add your answer
Q2. What I should do?
Add your answer
Q3. How to do work?
Add your answer
Q4. What should I do
Add your answer
Q5. What is the goal?
Ans. 
The goal of a Data Analyst is to analyze data to extract valuable insights and make data-driven decisions.
• Identify trends and patterns in data

• Create visualizations to communicate findings

• Provide actionable recommendations based on data analysis
Answered by AI
Add your answer

It was codility test with 2 questions

Q1. One codility question
Add your answer

Q1. Design system like uber eats
Add your answer

Q1. Design system like youtube
Add your answer

It was well designed

Q1. Basic Questions about data warehousing
Add your answer
Q2. Dbt Scenarios
Add your answer

Q1. Opps, overloading and overriding, factory n singleton patteren
Add your answer
Q2. Collections HashMap internal working
Add your answer