Phone call from internal recruiter.

Reviews resume and attempts to reconcile with openings.

Resume gets submitted to hiring manager, which, in my case, expressed interest.

Then I was notified of an EA assessment via codeingame.com for a 2-3 hour online test.

The test covered both C++ and some rather non-trivial SQL.

Not entirely sure who picks questions or if it was randomized.

Some of the questions were very esoteric and of little interview value.

Each question was individually timed, with some having excess time to complete, while others, not nearly enough.

As I heard nothing else, it appeared that scoring well on this assessment was a requirement for further consideration.

One question was a non-trivial SQL query where I may have had 8 minutes to answer. It involved a table with 3-4 other related tables, one of which contains history of individual orders. You are asked to list the customer name and customer_id with the most orders.