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

      Allstate

      Is this your company?

      About
      Reviews
      Pay & benefits
      Jobs
      Interviews
      Interviews
      Related searches: Allstate reviews | Allstate jobs | Allstate salaries | Allstate benefits | Allstate conversations
      Allstate interviewsAllstate ETL Senior Consultant interviewsAllstate interview
      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 personalized job recommendations and updates by starting your searches.



      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. Indeed, Inc. "Glassdoor," "Worklife Pro," "Bowls," and logo are proprietary trademarks of Indeed, Inc.

      Allstate interviews FAQs

      • Here are the most commonly searched roles for interview reports -

        1. Claims Adjuster(500) ;
        2. Licensed Sales Producer(424) ;
        3. Insurance Agent(380) ;
        4. Customer Service Representative(325) ;
        5. Sales Representative(194) ;
        6. Sales Associate(161) ;
        7. Insurance Sales Agent(121) ;
        8. Sales(119) ;
        9. Claims Specialist(117) ;
        10. Licensed Insurance Agent(107) ;
        11. Consultant(102) ;
        12. Software Engineer(88) ;
        13. Senior Consultant
      (87) ;
    • Claims Service Specialist(86) ;
    • Agency Owner(85) .
    • Jobs at Allstate

      3 jobs in United States
      Exposure Intelligence – CTEM Consultant
      United States
      ·
      $100K - $171K /yr
      (Employer provided)
      View job
      Product Engineer - Fusion GRC Platform
      Remote
      ·
      $75K - $126K /yr
      (Employer provided)
      View job
      Senior AI Engineer
      United States
      ·
      $100K - $171K /yr
      (Employer provided)
      View job

      ETL Senior Consultant Interview

      Aug 19, 2016
      Anonymous Interview Candidate
      Bengaluru
      No offer
      Negative experience
      Difficult interview

      Application

      I applied through an employee referral. The process took 5 weeks. I interviewed at Allstate (Bengaluru) in Jul 2016

      Interview

      Request you all to go through this experience I have applied for a senior consultant position in Bangalore through HR. The process took 5+ weeks. It includes as below: 1. Technical Interview 2. Managerial/Technical interview 3. Onsite managerial/technical interview 4. HR Interview I contacted a HR person for interview who forwarded my cv to another lady. That lady didn't call me first. Again I need to check with that HR person, then I received a call for first round. I need to stop-by in the Allstate Bangalore facility for the first round. The technical panelists were professionals and well-mannered. They behaved really well and didn't ask any irrelevant question. It went around for 1 hour. Then my recruiter, that lady came with a laptop saying that a managerial round would be there though skype. The process started after 10 minutes and went for 20 minutes. The manager was in US. The interview was good. It seemed that the manager was happy with my responses. After the managerial interview, my recruiter told me that I passed the interviews. When I asked for the next processes, she told that there might be another onsite managerial interview and one HR round. Then comes the pain period. I started contacting my recruiter. She was telling there was no update. That went for 2 weeks. One day she told an onsite round is scheduled. I need to come to office again. I attended the same. It was a videocon. 3 persons sitting on another side. The recruiter was on leave that day. Some one else was trying to set up the meeting for me. It seems he didn't know how to set up meetings. A total mess. People are playing in the canteen, the videocon room has less lights etc etc. The videocon started with a positive note. The person who was asking questions sitting over there seemed to be Alan turing. But didn't ask anything specific. Roamed around topic to topic. Interviewed ended with a positive note also. The Pain period continues. I forgot to tell, the HR round was completed 2-3 days after my initial interview. Salary was not much negotiated. Now, I am trying to call my recruiter. Everytime she talks over the phone as she is the CEO and I am begging for a job. Her only reply is that "wait for sometime". Now she is telling that my candidature is on hold for some reason and it is not positive. My advice to all of you that, please don't waste your time for this company. They are not professionals. I know the review will vary and it's person specific. Your experience will be good only if you get a good recruiter.

      Interview questions [1]

      Question 1

      1. Basic ETL functionalities 2. DB questions 3. Functions of ETL ab-initio 4. SQLs 5. UNIX commands
      Answer question
      5
      View all ETL Senior Consultant Jobs