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

      Capgemini

      Engaged employer

      About
      Reviews
      Pay and benefits
      Jobs
      Interviews
      Interviews
      Related searches: Capgemini reviews | Capgemini jobs | Capgemini salaries | Capgemini benefits | Capgemini conversations
      Capgemini interviewsCapgemini SQL/SSIS Developer interviewsCapgemini 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.

      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
      Sabre
      3.6★Compensation and benefits
      avatar
      SAP
      3.9★Compensation and benefits
      avatar
      Salesforce
      4.4★Compensation and benefits
      avatar
      IDEMIA
      3.6★Compensation and benefits

      SQL/SSIS Developer Interview

      14 Jun 2024
      Anonymous interview candidate
      Pune
      No offer
      Negative experience
      Easy interview

      Application

      I applied online. The process took 2 weeks. I interviewed at Capgemini (Pune) in Jun 2024

      Interview

      I have attended Capgemini interview 2 times. In the phone screening HR told that the position is for SSIS and SQL and I had informed her that I don't have experience in SSRS and SSAS. And she said they are looking for only SSIS and SQL. They scheduled the first round and it went well and I cleared it After one week I got call and they told that I have cleared the first round and they will be scheduling 2nd round. in the 2nd Round one techo manager interviewed me and I had answered 90% technical questions. He was asking why I haven't learnt SSRS or SSAS or any other ETL tool. I had told him that our project didn't require those technology but I am trained in those technologies , as I don't have hands-on experience I may not be able to answer on those technologies. He was checking if I am in comfort zone as I have been working for same organisation for past 8years and asking irrelevant questions. Then I didn't hear back from Capgemini team so assumed that I haven't cleared the 2nd round. Again in June I got call from HR and told that they have opening for SSIS developer role and I said okay. they scheduled the interview and that interviwer asked me to introduce myself and asked to explain on ssis transformation, types of constraints and one question on triggers. I had answered all these questions and after that he said he is done and HR will get back. That interview was only for 1 0min. Next day again I got from another HR and said they have opening and asked if I am interested. I said that I have attended the interview previous day and they checked the database and said I was rejected and told that this opening is for different account and asked if I am interested . I said no. And now daily I am getting calls from Capgemini for SSIS developer position and I am saying no to them.

      Interview questions [1]

      Question 1

      Introduction SSIS transformation Difference between union all and merge Difference between conditional split and multicast Scenario based questions Query to delete duplicate records
      Answer question

      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.