Fyber

Vorstellungsgespräche bei Fyber

1. Nov 21, 2021

   Vorstellungsgespräch für eine Beschäftigung als Fraud Analyst

   Anonymer Mitarbeiter in Deutschland

   Kein Angebot

   Neutrale Erfahrung

   Durchschnittl. Gespräch

   Bewerbung

   Ich habe mich online beworben. Der Vorgang dauerte 1 Woche. Vorstellungsgespräch absolviert bei Fyber (Deutschland)

   Vorstellungsgespräch

   HR Round about me > Excel + SQL Test (first 4 que were easy in excel and last two bit tricky and difficult> rejection with no proper reason (I was sure about test result as 70% right answers). Even after request No feedback about test. Which is a bit disappointing.
   

   Vorstellungsgespräch

   Excel: 1 How many transactions tagged as VPN happened in September. Present the data in pivot 2 What are the top 10 appearing IPS. Present the list 3 How many fraud conversions were tracked during September 2020 and which advertisers were affected? Please present the data in the pivot 4 How many transactions come from web advertisers vs in app advertiser. Please present the results in a pie chart. 5 How many conversions happened after 3, 7, 20 days ( conversion happens after the click). Present the data in pivot 6 What is the chargeback ratio ( % of claimed revenue from overall spend) per months appearing in tab "Overall spend" ? Please present the results in a table Below you will find four tables from a sample schema, containing some data tracked in our platform. Basing on them please write queries to answer the following questions: 1. Query to filter the results and receive only conversions there the condition ‘fraud’ is YES. Include columns about ‘supply_payout_usd’, ‘client_id’, and ‘client_name’. 2. Create a table containing columns and corresponding information about: - sum of ‘advertiser_spent_usd’ and sum of ‘supply_payout_usd’ - ‘app_id’, ‘app_name’, ‘client_id’, ‘client_name’ - ‘advertiser_id’ and ‘advertiser_id’ columns for ‘campaign_id’ 1401130.

   1 Antworten