Passa al contenutoPassa al piè di pagina
  • Lavori
  • Aziende
  • Stipendi
  • Per le aziende

      Migliora la tua carriera

      Scopri le tue potenzialità di guadagno, trova lavori da sogno e condividi approfondimenti su lavoro e vita privata in forma anonima.

      employer cover photo
      employer logo
      employer logo

      ISN Software

      Azienda coinvolta

      Circa
      Recensioni
      Stipendi e benefit
      Lavori
      Colloqui
      Colloqui
      Ricerche correlate: Recensioni su ISN Software | Offerte di lavoro di ISN Software | Stipendi di ISN Software | Benefit di ISN Software
      Colloqui di ISN SoftwareColloqui per SQL Developer presso ISN SoftwareColloquio di ISN Software


      Glassdoor

      • Chi siamo
      • Contattaci

      Aziende

      • Account Business gratuito
      • Spazio per le aziende
      • Blog per le aziende

      Informazioni

      • Aiuto
      • Linee guida
      • Condizioni d'uso
      • Privacy e scelte pubblicitarie
      • Non vendere né condividere le mie informazioni
      • Strumento per l'accettazione dei cookie

      Lavora con noi

      • Inserzionisti
      • Carriere
      Scarica l'app

      • Cerca:
      • Aziende
      • Lavori
      • Località

      Copyright © 2008-2026. Glassdoor LLC. "Glassdoor," "Worklife Pro," "Bowls" e il relativo logo sono marchi registrati di Glassdoor LLC.

      Aziende seguite

      Non lasciarti sfuggire opportunità e informazioni privilegiate seguendo le aziende dove vorresti lavorare.

      Ricerche di lavoro

      Ricevi suggerimenti e aggiornamenti personalizzati avviando le tue ricerche.

      Colloquio per SQL Developer

      26 ago 2015
      Candidato anonimo a colloquio
      Dallas, TX
      Nessuna offerta
      Esperienza negativa
      Colloquio difficile

      Candidatura

      Ho presentato la mia candidatura tramite un selezionatore. La procedura ha richiesto più di una settimana. Ho sostenuto un colloquio presso ISN Software (Dallas, TX) nel mese di ago 2015

      Colloquio

      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."

      Domande di colloquio [5]

      Domanda 1

      Tell me about yourself. (Or Tell me 3 things about yourself.)
      Rispondi alla domanda

      Domanda 2

      If you have a left join with criteria, how does moving criteria in to the where statement change the query?
      Rispondi alla domanda

      Domanda 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 risposte

      Domanda 4

      How does a dirty read differ from snapshot transaction?
      Rispondi alla domanda

      Domanda 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.)
      Rispondi alla domanda
      4

      Le migliori aziende per "stipendio e benefit" vicino a te

      avatar
      Digital Natives
      4.4★Stipendio e benefit