Common questions asked in interview for IT Analyst

What questions are commonly asked in a job interview for IT Analyst position ?

Hi,

The questions asked in interview for IT analyst are primarly focused on experience. These are the common questions:

• Can you name and describe the projects you have worked on ?
• What was your favorite project ?
• How big was the team you have worked in ?
• What is the your level of knowledge of SQL (junior/medior/senior) ?
• Do you have experience with joining multiple tables (JOIN, LEFT JOIN etc.) ?
• How big was the database you have worked with ?
• How many lines had the largest table ?
• What database systems do you have experience with (MySQL, PostgreSQL, Oracle, Microsoft SQL, IBM DB2 etc.) ?
• Do you have experience with process analysis, functional analysis and technical analysis of information system ?
• What tools and software development related applications do you have experience with (Redmine, Jira etc.) ?
• Do you have experience with software integrations ?
• Do you have experience with SOAP and REST requests ?
• Do you have knowledge of UML, BPMN and XML ?
• What UML diagram types do you have experience with ?
• What UML modeling software do you have experience with (Enterprise Architect, Microsoft Visio etc.) ?
• What BPM software do you have experience with ?
• Do you have experience with other business analytics tools ?
• What is the most difficult / complex thing you have worked on ?
• Do you have experience with agile software development ?
• Do you have experience with automated testing ?
• Do you have experience with writing test cases ?
• What types of testing do you have experience with (for example positive and negative, acceptance testing etc.) ?
• Have you ever dealt with a difficult customer ?
• Is there anything you don't like to do ?
• Can you describe an ideal environment as an IT analyst ?

The questions may have a different order. Some questions may be asked indirectly.