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

      Ditech Financial

      Is this your company?

      About
      Reviews
      Pay & benefits
      Jobs
      Interviews
      Interviews
      Related searches: Ditech Financial reviews | Ditech Financial jobs | Ditech Financial salaries | Ditech Financial benefits
      Ditech Financial interviewsDitech Financial Report Analyst/SQL Developer interviewsDitech Financial interview


      Glassdoor

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

      Employers

      • Free Employer Account
      • Employer Center
      • Employers Blog

      Information

      • Help
      • Guidelines
      • Terms of Use
      • Privacy & 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.

      Followed companies

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

      Job searches

      Get personalized job recommendations and updates by starting your searches.

      Top companies for "Compensation and Benefits" near you

      avatar
      Wells Fargo
      3.7★Compensation & Benefits
      avatar
      JPMorganChase
      3.9★Compensation & Benefits
      avatar
      Bank of America
      3.8★Compensation & Benefits
      avatar
      Capital One
      3.9★Compensation & Benefits

      Bowls

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

      Company Bowl sample

      Want the inside scoop on your own company?

      Check out your Company Bowl for anonymous work chats.

      Report Analyst/SQL Developer Interview

      Apr 5, 2016
      Anonymous Interview Candidate
      Jacksonville, FL
      No offer
      Negative experience
      Easy interview

      Application

      I applied through a recruiter. The process took 1 week. I interviewed at Ditech Financial (Jacksonville, FL) in Mar 2016

      Interview

      Submitted via one of the many recruiting agencies that they are working through. First there is a phone screen and then a face to face interview. You'll typically speak/meet with three individuals who take turns asking questions. All very polite and easy to speak with. Several technical questions revolving around stored procedures, CTEs, and moving data from MSP to their new system. The company took over for Greentree financial and is going through the transition from one system to another. The downside is that several incarnations of this job have come up frequently in the past eight to ten months possibly due to a higher than normal turnover. There seems to be some question as to whether or not the positions are true contract or contract to hire roles. They are using multiple recruiting agencies for these roles and the rates vary wildly. I would wait and compare what the agencies are offering before being submitted. Also don't expect to receive feedback if you weren't chosen. Again, the people I met with were friendly and would most likely be pleasant to work with. It just seems like they're throwing bodies at the project.

      Interview questions [4]

      Question 1

      What is a CTE and give an example of what it's used for.
      Answer question

      Question 2

      Are you familiar with stored procedures? Describe your experience using stored procedures.
      Answer question

      Question 3

      Name and describe the different types of indexes. Are you familiar with column store indexes in SQL Server 2012?
      Answer question

      Question 4

      Describe how you would identify duplicates in a table using SQL.
      Answer question