Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Oracle Team. If you also belong to the team, you can get access from here

Oracle Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 5k Reviews

Filter interviews by

Oracle Data Engineer Interview Questions and Answers

Updated 16 Aug 2024

Oracle Data Engineer Interview Experiences

1 interview found

Data Engineer Interview Questions & Answers

user image Anonymous

posted on 16 Aug 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
No response

I was interviewed before Aug 2023.

Round 1 - One-on-one 

(1 Question)

  • Q1. What is data warehousing
  • Ans. 

    Data warehousing is the process of collecting, storing, and managing data from various sources for analysis and reporting.

    • Data warehousing involves extracting data from multiple sources

    • Data is transformed and loaded into a central repository

    • Data can be queried and analyzed for business intelligence purposes

    • Examples include data warehouses like Amazon Redshift, Snowflake, and Google BigQuery

  • Answered by AI

Skills evaluated in this interview

Data Engineer Jobs at Oracle

View all

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed in Jun 2024. There were 4 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. The HR representative will seek to understand your experience and its alignment with the role.
  • Q2. Salary expectations, Offers in hand
Round 2 - Technical 

(3 Questions)

  • Q1. What are the key features and functionalities of Snowflake?
  • Ans. 

    Snowflake is a cloud-based data warehousing platform known for its scalability, performance, and ease of use.

    • Snowflake uses a unique architecture called multi-cluster, which separates storage and compute resources for better scalability and performance.

    • It supports both structured and semi-structured data, allowing users to work with various data types.

    • Snowflake offers features like automatic scaling, data sharing, and ...

  • Answered by AI
  • Q2. The interviewer asked several complex SQL questions that utilized analytical functions.
  • Q3. I was asked to write some syntax-level code for Jinja statements in dbt.
Round 3 - Technical 

(2 Questions)

  • Q1. The interviewer, who was part of the senior management, inquired about dbt, its features, and my experience with dbt thus far.
  • Q2. The interviewer reviewed my resume and inquired about the challenges I encountered in my previous roles and the methods I used to resolve them.
Round 4 - HR 

(1 Question)

  • Q1. Salary negotiations, Bonus discussions

Interview Preparation Tips

Topics to prepare for Fractal Analytics Data Engineer interview:
  • dbt
  • Snowflake
  • AWS
  • Python
  • PySpark
  • SQL
  • Data Modelling
  • Data Quality
  • Airflow
Interview preparation tips for other job seekers - Stick to the basics while also addressing some complex topics relevant to your role and job expectations. Be honest about what you know and what you don't. Always approach discussions diplomatically regarding what is valuable to you.
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Jan 2024. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Describe your Past experiences
Round 2 - Coding Test 

Basic Python and SQL

Round 3 - Technical 

(1 Question)

  • Q1. Scenario Based questions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Python, Pyspark, Scala, Kafka

Round 2 - HR 

(1 Question)

  • Q1. CTE Expectation

Interview Preparation Tips

Interview preparation tips for other job seekers - Revise your basic knowledge always

I applied via AngelList and was interviewed before Jun 2021. There were 2 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - HR 

(1 Question)

  • Q1. Behaviour round questions were asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare basics of python and behavioral questions
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Technical 

(1 Question)

  • Q1. Sql questions and python
Round 2 - Behavioral 

(1 Question)

  • Q1. About last projects

Data Engineer Interview Questions & Answers

MathCo user image Balajayani Radhakrishnan

posted on 17 Jul 2024

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Simple question.. easy to crack

Round 2 - Case Study 

Yet to attend the 2nd round

Round 3 - One-on-one 

(2 Questions)

  • Q1. Yet to attend 2nd round
  • Q2. Yet to attend this round
Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Basic SQL questions and Window fuctions
Round 2 - HR 

(1 Question)

  • Q1. HR asked how was the interview last round and gave me feedback

Interview Preparation Tips

Interview preparation tips for other job seekers - Answered almost all questions but still the interviewer gave feedback as, cannot write pyspark code. Although there was only one pyspark coding question and I did it.
In fact interviewer turned camera off several times between and missed responding for a few seconds.
He even didn't tell me to share screen to see what I code.

Totally not serious about the interview..
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Dec 2023. There were 4 interview rounds.

Round 1 - Coding Test 

I cannot recall the platform, but it featured a combination of Python and SQL questions, with the majority being focused on SQL.

Round 2 - One-on-one 

(2 Questions)

  • Q1. SQL basics like Indexes, Clustering, Keys, Data warehousing concepts, Normalization and Denormalization etc..
  • Q2. SQL coding questions
Round 3 - One-on-one 

(2 Questions)

  • Q1. SQL questions to solve using different types of joins
  • Q2. Questions based on project and data quality checks
Round 4 - HR 

(2 Questions)

  • Q1. Behavioral questions
  • Q2. Culture fit

Interview Preparation Tips

Interview preparation tips for other job seekers - Fractal typically emphasizes core skills in programming and data engineering. It is important to have a solid understanding of the fundamentals and to be prepared for coding challenges, as well as knowledge of data warehousing and ETL concepts.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Feb 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Coding Test 

Sql and python coding conducted

Round 3 - One-on-one 

(1 Question)

  • Q1. Questions on AWS or azure depending upon the platform you work. more conceptual questions on data engineering.
Round 4 - project discussion 

(1 Question)

  • Q1. They check to which project you are fit to.

Interview Preparation Tips

Interview preparation tips for other job seekers - be good on concepts and basics of azure or AWS. more questions on handling big data and pyspark coding.

Oracle Interview FAQs

How many rounds are there in Oracle Data Engineer interview?
Oracle interview process usually has 1 rounds. The most common rounds in the Oracle interview process are One-on-one Round.
How to prepare for Oracle Data Engineer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Oracle. The most common topics and skills that interviewers at Oracle expect are Python, SQL, AWS, Data Warehousing and Oracle.

Tell us how to improve this page.

Oracle Data Engineer Salary
based on 48 salaries
₹7.8 L/yr - ₹33 L/yr
81% more than the average Data Engineer Salary in India
View more details

Oracle Data Engineer Reviews and Ratings

based on 1 review

1.0/5

Rating in categories

1.0

Skill development

5.0

Work-Life balance

2.0

Salary & Benefits

1.0

Job Security

2.0

Company culture

1.0

Promotions/Appraisal

2.0

Work Satisfaction

Explore 1 Review and Rating
Director, Data Engineering & Operations

Hyderabad / Secunderabad

15-19 Yrs

Not Disclosed

Explore more jobs
Senior Software Engineer
2.3k salaries
unlock blur

₹10 L/yr - ₹40 L/yr

Senior Consultant
2.1k salaries
unlock blur

₹6.9 L/yr - ₹25 L/yr

Principal Consultant
2k salaries
unlock blur

₹10.9 L/yr - ₹36 L/yr

Senior Member of Technical Staff
1.8k salaries
unlock blur

₹12 L/yr - ₹45 L/yr

Senior Application Engineer
1.4k salaries
unlock blur

₹8.5 L/yr - ₹34 L/yr

Explore more salaries
Compare Oracle with

SAP

4.2
Compare

MongoDB

3.9
Compare

Salesforce

4.1
Compare

IBM

4.1
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview