Skip to contentSkip to footer
  • Community
  • Jobs
  • Companies
  • Salaries
  • For employers
      Notifications

      Loading...

      Elevate your career

      Discover your earning potential, land dream jobs, and share work-life insights anonymously.

      employer cover photo
      employer logo
      employer logo

      EY

      Engaged employer

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: EY reviews | EY jobs | EY salaries | EY benefits | EY conversations
      EY interviewsEY Data Analytics Executive At Forensic Technology interviewsEY interview


      Glassdoor

      • About / Press
      • Awards
      • Blog
      • Research
      • Contact Us
      • Guides

      Employers

      • Free Employer Account
      • Employer Centre
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy and Ad Choices
      • Do Not Sell Or Share My Information
      • Cookie Consent Tool
      • Security

      Work With Us

      • Advertisers
      • Careers
      Download the App

      • Browse by:
      • Companies
      • Jobs
      • Locations
      • Communities
      • Recent posts

      Copyright © 2008-2026. Glassdoor LLC. "Glassdoor," "Worklife Pro," "Bowls" and logo are proprietary trademarks of Glassdoor LLC.

      Company Bowl sample

      Want the inside scoop on your own company?

      Check out your Company Bowl for anonymous work chats.

      Bowls

      Get actionable career advice tailored to you by joining more bowls.

      Followed companies

      Stay ahead in opportunities and insider tips by following your dream companies.

      Job searches

      Get personalised job recommendations and updates by starting your searches.

      Top companies for "Compensation and Benefits" near you

      avatar
      Defense Finance and Accounting Service
      3.8★Compensation and benefits

      Data Analytics Executive At Forensic Technology Interview

      3 Aug 2014
      Anonymous employee
      London, England
      Accepted offer
      Positive experience
      Average interview

      Application

      I applied through a recruiter. The process took 4 weeks. I interviewed at EY (London, England) in Jul 2014

      Interview

      There were three interviews. First was telephone screening interview with 3 detailed technical questions. The second was onsite with a manager. It was a very technical interview using whiteboard to demonstrate SQL skills and also doing a test in front of the manager about software in general, algorithms, development, and regular expressions. If you have CS background, it is a very easy test. Also, they would go through the answers with you and discuss them helping you to answer correctly. Third interview is with directors, business and technical. The latter gave a case study on how to apply advanced data analytics techniques on a problem within a fraud suspicion case in financial services. The other would ask typical competency questions and your motivation to join the team.

      Interview questions [1]

      Question 1

      In SQL when you do a join with another table where column value can be NULL, what would be the outcome of join in respect to NULL values.
      1 Answer
      21