Aller au contenuAller au pied de page
  • Emplois
  • Entreprises
  • Salaires
  • Pour les employeurs

      Boostez votre carrière

      Découvrez votre salaire potentiel, décrochez des emplois de rêve et partagez vos témoignages de manière anonyme.

      employer cover photo
      employer logo
      employer logo

      ISN Software

      Employeur impliqué

      À propos
      Avis
      Salaires et avantages
      Emplois
      Entretiens
      Entretiens
      Recherches associées: Avis sur ISN Software | Offres d’emploi chez ISN Software | Salaires chez ISN Software | Avantages sociaux chez ISN Software
      Entretiens chez ISN SoftwareEntretiens d’embauche pour SQL Developer chez ISN SoftwareEntretien chez ISN Software


      Glassdoor

      • À propos
      • Récompenses
      • Blog
      • Nous contacter
      • Guides

      Employeurs

      • Compte employeur gratuit
      • Centre employeur
      • Blog pour les employeurs

      Informations

      • Aide
      • Règles de la communauté
      • Conditions d'utilisation
      • Confidentialité et choix publicitaires
      • Ne pas vendre ni partager mes informations
      • Outil de consentement aux cookies

      Travailler avec nous

      • Annonceurs
      • Carrières
      Télécharger l'application

      • Parcourir par :
      • Entreprises
      • Emplois
      • Lieux

      Copyright © 2008-2026. Glassdoor LLC. « Glassdoor », son logo, « Worklife Pro » et « Bowls » sont des marques déposées de Glassdoor LLC.

      Entreprises suivies

      Tenez-vous au courant des dernières opportunités et profitez de conseils d’initiés en suivant les entreprises de vos rêves.

      Recherche d’emplois

      Obtenez des recommandations et des mises à jour personnalisées en démarrant vos recherches.

      Entretien pour SQL Developer

      26 août 2015
      Candidat à l'entretien anonyme
      Dallas, TX
      Aucune offre
      Expérience négative
      Entretien difficile

      Candidature

      J'ai postulé via un recruteur. Le processus a pris plus d'une semaine. J'ai passé un entretien chez ISN Software (Dallas, TX) en août 2015

      Entretien

      The interview was 3 rounds of questions, 2 people per round. I was informed it would be a mix of soft skill and technical questions. It was wall to wall technical questions. There were at most 2 soft skill questions per round. The attitude of the interviewers were neutral to friendly. And, if you are not given an offer, they will tell reasons why, which is greatly appreciated. I rate the experience a thumbs down because the reasons do not match the job position offered or what was the interviewers sought. They say they sought advanced SQL skills, but did not ask anything which illustrated advanced skills. The closest thing was a request to return a result set based on date ranges. This is great in exercising your knowledge of SQL Server's date functions, which I admit I don't know all of them off the top of my head (F1 is a press way for a refresher on function specifics), but it does not demonstrate advanced SQL skills. How about aggregation or result set distribution questions? How about transaction and exception handling? These are more of the day to day challenges I've seen in my 20 years of SQL development. Heck, a question which asked to list out as many SQL constructs you know, explain them, and give an example of usage would have been more beneficial than questions about juggling dates. A significant portion of questioning involved database performance tuning, specifically in server software and hardware configuration. I provided what they acknowledged were good answers, but they kept pushing for more and more. Failure to do so I guess meant not being qualified for the job. However, the job advertised was SQL Developer, not DBA or hardware systems architect. (My area of expertise is in app and database development, which seemed perfect fit for the position since it was to serve the app dev team.) The questioning in the last round went beyond was the company ad asked for. An interviewer asked what new technologies I was interested in working with. I described the data environment ISN has and the new opportunities that comes with it. I was describing was is commonly known as "big data," but I failed to use the term and the interviewer failed to recognize what I was describing. The last reason given for rejection is unfair. They will ask what your career goals are, where would you like to be in the long term. I answered honestly, being a team lead of engineers while still being hands on to create a quality product. Given a company growing at the pace of ISN, opportunities for new leaders are bound to be created. The company responded saying I was more interested in a managerial role than development role. Is ISN saying they do not expect employees to have a career growth path? Employees should not have dreams or aspirations? Why should my long term goals be a demerit? If you are asked this question and want to get hired, answer "I love doing X and will do as long as I can."

      Questions d'entretien [5]

      Question 1

      Tell me about yourself. (Or Tell me 3 things about yourself.)
      Répondre à cette question

      Question 2

      If you have a left join with criteria, how does moving criteria in to the where statement change the query?
      Répondre à cette question

      Question 3

      Given 2 dates, return a result set that outputs a number for each week between the two. (They will ask the numbered week to be the sequential week and also the calendar week. Prepare for given start date to be start mid-week.)
      3 réponse(s)

      Question 4

      How does a dirty read differ from snapshot transaction?
      Répondre à cette question

      Question 5

      If you have a table with a massive amount of records and the table can't change, how would you optimize a query that's taking too long? (This is more about getting results as fast as possible and not pigeon holing the solution to a query.) Assuming the query has been optimized, what else can you do to speed up performance? (Prepare to enter DBA and systems architect territory at this point.)
      Répondre à cette question
      4

      Meilleures entreprises pour « Rémunération et avantages » près de chez vous

      avatar
      Intel Corporation
      3.7★Rémunération et avantages
      avatar
      YES
      3.9★Rémunération et avantages
      avatar
      Lenovo
      3.8★Rémunération et avantages
      avatar
      Moody's
      3.7★Rémunération et avantages