Amazon · amazon.jobs · checked today
Data Engineer III - AMZ10455847
Employer: AMAZON.COM SERVICES LLC Offered Position: Data Engineer III Job Location: Charleston, South Carolina
Skills, with evidence
- Data modelling
Must have one year of experience in the following skill(s): developing and operating large-scale data structures for business intelligence analytics using each of the following: ETL/ELT processes; OLAP technologies; data modeling; SQL; and Oracle.
must have - SQL
Must have one year of experience in the following skill(s): developing and operating large-scale data structures for business intelligence analytics using each of the following: ETL/ELT processes; OLAP technologies; data modeling; SQL; and Oracle.
must have
Your plan
- The SQL screen: correct, then fast≈ 2 h
SQL
- Median delivery time per cityIntermediate
- Bucket deliveries into quartilesIntermediate
- Median order value without a median functionIntermediate
- New and repeat orders by monthIntermediate
- Every order against its customer's averageIntermediate
- Data modelling: the round most people fail≈ 3 h
Data modelling
- Addresses that stay true to the pastIntermediate
- Seat holds and the release-night raceIntermediate
- Subscription warehouse grainIntermediate
- Campaign efficiencyIntermediate
- Catalogue: products, variants and sellersIntermediate
- Say it out loud≈ 1 h
10 drills · Intermediate + Advanced≈ 6 hours
Readiness
Counted from drills you have completed anywhere on D8LooP.
leaves in 11 dremoved the moment Amazon closes it