Oracle

Deep-DB heritage: advanced SQL, Python DS/algo (array/sorting), Spark, and warehousing concepts.

Cloud / platform

OCI; Oracle DB, Spark, Python

Reported difficulty

Not reported

SQLPythonSparkData warehousing

Hiring process

Technical phone/video

Onsite (discussions/whiteboarding)

Behavioral

Offer

Round-by-round breakdown

3

01

SQL

Medium confidence

Joins, subqueries, window functions, performance optimization
Retrieve plant names and their associated weather types

02

Python

Medium confidence

Array manipulation + sorting; DS/algo; OOP; pandas/numpy
Find pairs of numbers with the minimum absolute difference

03

Spark / Warehousing

Medium confidence

Spark for large-scale processing
Data warehousing + pipeline concepts

System & pipeline design prompts

1

Enterprise data pipeline / warehouse on OCI

Rejection patterns

3

Weak advanced SQL/optimization
Shaky Python DS/algo
Thin warehousing/Spark knowledge

Reported experiences

1

Data Engineer

ReportedFirst-hand

Technical rounds — SQL (joins/subqueries/window; plant-names + weather-types query) + Python (array manipulation/sorting; min-absolute-difference pairs) + Spark + warehousing.

Hiring process

Round-by-round breakdown

SQL

Python

Spark / Warehousing

System & pipeline design prompts

Prep — high priority

Prep — medium priority

Rejection patterns

Reported experiences

Data Engineer

Rehearse for Oracle

Oracle

Hiring process

Round-by-round breakdown

SQL

Python

Spark / Warehousing

System & pipeline design prompts

Prep — high priority

Prep — medium priority

Rejection patterns

Reported experiences

Data Engineer

Rehearse for Oracle