Job Descriptions & Job Questions

Question 1

Business Analyst

Answer 1

development of understanding business needs to create solutions, envision a solution to solve business problems, or add more value to the business.

Question 2

Systems Analyst

Answer 2

• Focuses more on the technology aspect of the solution. They come in when there is a software change.
• Responsible for data modeling, data design, and how data moves between systems.

Question 3

Application Developer

Answer 3

Create, test and program applications for computers, mobile phones and other electronic devices.
Applications software can be written for a particular operating system (OS), such as Android, iOS or
Windows.

Question 4

Quality Analyst

Answer 4

responsible for developing and executing
test plans to ensure that all objectives are met, as well as implementing and monitoring test scripts to
assess functionality, reliability, performance, and quality of service or product

Question 5

Project Managers

Answer 5

play the lead role in planning, executing, monitoring, controlling, and closing projects.
They are accountable for the entire project scope, project team, resources, and the success or failure of
the project.

Question 6

Application Management

Answer 6

refers to the ongoing support (for users and infrastructure) of existing
company systems, such as ERP or CRM software. Tasks carried out by this team
include bug fixes, patches, minimal enhancements (typically 2 weeks or less), code refactoring, etc. This
group may also be responsible for maintaining infrastructure (servers, storage, memory, etc.) related to
company systems.

Question 7

Application Developer

Answer 7

Create, test and program applications for computers, mobile phones and other electronic devices.
Applications software can be written for a particular operating system (OS), such as Android, iOS or
Windows.

Question 8

Quality Assurance Engineers

Answer 8

responsible for assessing the quality of specifications and technical
design documents in order to ensure timely, relevant and meaningful feedback. They are involved in
planning and implementing strategies for quality management and testing.

Question 9

Application Analyst

Answer 9

provide technical support for users of IT systems. They monitor and maintain software and applications and oversee an organization’s processes to ensure all data is safe and programs run smoothly. this position should also possess these skills: Critical thinking ability.
Strong problem-solving capacity. High-level written and verbal communication skills.

Question 10

Business Intelligence (BI)

Answer 10

This Group designs and develops databases and applications that pool, extract and analyze large amounts of data to provide management with insights on the overall performance of the organization as well as information on markets and competitors. They use tools like SAP, Oracle, and
plain SQL databases to manage company data and produce reports. This Group works with
management to create dashboards and develop data collection methods. “Big Data” technologies, such
as Hadoop, are gaining popularity in the enterprise community due to their ability to quickly analyze
large, unstructured data sets.

Question 11

Business Intelligence Developer

Answer 11

an engineer that is in charge of developing, deploying, and
maintaining BI interfaces. These include query tools, data visualization, and interactive dashboards, ad
hoc reporting, and data modeling tools.

Question 12

Data Warehouse Manager

Answer 12

manages the daily activities of the team responsible for the design, implementation, maintenance, and support of data warehouse systems and related data marts. Oversees data design and the creation of database architecture and data repositories. Being a Data
Warehousing Manager ensures a proper balance between front-end systems and back-end processing
capabilities. Installs processes for auditing data warehouses and ensuring data quality.

Question 13

Data Analyst

Answer 13

translate numbers into plain English. Every business collects data, whether it’s sales
figures, market research, logistics, or transportation costs. The job is to take that data and
use it to help companies make strategic business decisions.

Question 14

Data Architect

Answer 14

discipline concerned with designing, creating, deploying and managing an organization’s data architecture. This position defines how the data will be stored, consumed, integrated and managed by different data entities and IT systems, as well as any applications using or processing that data in some way

Question 15

Database Administrator

Answer 15

make sure that data analysts and other users can easily use
databases to find the information they need and that systems perform as they should. Some DBAs
oversee the development of new databases. They have to determine the needs of the database and
who will be using it.

Question 16

System DBA

Answer 16

focuses on technical rather than business issues, primarily in the system administration
area. Typical tasks center on the physical installation and performance of the DBMS software. This position is rarely involved with the actual implementation of databases and applications. They might get
involved in application tuning when operating system parameters or complex DBMS parameters need to
be altered. The job usually exists only if the organization does not have an official system
administration or systems programming department.

Question 17

Database Architect

Answer 17

involved in new design and development work only; he is not involved in maintenance, administration, or tuning of established databases and applications. This position designs new databases for new or existing applications.

Question 18

Database Analyst

Answer 18

involved in new design and development work only; they are not involved in maintenance, administration, or tuning of established databases and applications. The position designs new databases for new or existing applications.

Question 19

Data Modeler

Answer 19

usually responsible for a subset of the data architect’s responsibilities. This position is usually not considered a DBA, but this is not a hard and fast rule.

Question 20

Application DBA

Answer 20

focuses on database
design and the ongoing support and administration of databases for a specific application or subset of
applications. likely to be an expert at writing and debugging complex SQL and
understands the best ways to incorporate database requests into application programs

Question 21

ETL Developer

Answer 21

n IT specialist who designs data storage systems for companies, and works to fill that system with the data that needs to be stored. ETL stands for “extract, transform, load”

Question 22

ETL Developer Skills

Answer 22

Determine Data Storage Needs - The first task of the ETL Developer is to figure out the exact
storage needs of the company. They will need to have clear picture of the current data situation,
and be able to analyze different options to figure out the best fit.
• Design and Create a Data Warehouse - Based on the determined needs, the ETL Developer then
designs a data warehousing system that meets the specific business needs, and works with a
development team to build the warehouse.
• Extract, Transformation and Load of data - Once the warehousing system is developed, the ETL
Developer extracts the necessary data and transfers it to the new system.
• Test and Troubleshoot - After the system is up and running, the ETL Developer must test their
designs to ensure the system runs smoothly. They fix any problems that may pop up.

Question 23

Database Developer

Answer 23

ensure that database management systems (DBMS) can handle massive quantities
of data. usually work as part of a software development
team, modifying and editing databases, and designing and developing new databases

Question 24

Project Management Office (PMO)

Answer 24

group or department that defines and maintains standards for project management within
the organization. The PMO strives to standardize and introduce economies of repetition in the execution
of projects. The PMO is the source of documentation, guidance and metrics on the practice of project
management and execution.

Question 25

Project Manager

Answer 25

play the lead role in planning, executing, monitoring, controlling and closing projects.
They are accountable for the entire project scope, project team, resources, and the success or failure of
the project

Question 26

Project Manager

Answer 26

a strategic project-management professional whose job is to help oversee and
coordinate the various projects, products, and other strategic initiatives across an organization. this pos. might oversee multiple projects at one time, each of which might have its own project
team and project manager.

Question 27

Program Manager vs. Product Manager

Answer 27

Program managers supervise groups of projects; project managers oversee individual projects. Program
managers focus on long-term business objectives; project managers have short-term, concrete
deliverables. The project manager is judged on the triple constraint of time, cost, and scope of the
project. The program manager also is judged on these three elements but at a level that is cumulative
for all the projects and operations within the program.

Question 28

IT Procurement

Answer 28

manages the purchasing of technology-related assets and analyzes the
point at which hardware/software should be replaced, based on total cost of ownership (TCO) and
capabilities/features. Nearly all information technology projects involve procurement for hardware,
software or services. A clear understanding of procurement contracts and vendor requirements,
therefore, are important but often forgotten requirements for IT departments.

Question 29

Purchasing Agent

Answer 29

procure supplies, equipment, and services for a company to perform business operations. The duties and responsibilities of this pos. may include balancing cost and quality to procure the best quality of goods or services for the lowest price in adequate amounts.

Question 30

Procurement Officer

Answer 30

are responsible for assessing products, services and suppliers and negotiating contracts. They are also responsible for ensuring that approved purchases are of a sufficient quality and are cost-efficient. They can also be responsible for a myriad of processes including supply chain management, evaluating suppliers, purchase orders, purchasing goods or services, and contract
negotiation.

Question 31

IT Security Team

Answer 31

is responsible for defining, communicating and enforcing technology-related policies, standards and procedures. They are tasked with mitigating risk related to internal and external
data breaches and cyber attacks. This team also work to develop security incident management
plans and ensure that all technology-related projects meet defined security requirements. Robust
system and network security is especially vital in industries such as banking, consumer finance and insurance, where large amounts of private data (social security numbers, bank account information,
etc.) reside in company systems.

Question 32

Cybersecurity Analyst

Answer 32

plan and carry out security measures
to protect a company’s computer networks and systems, according to the BLS. They keep constant tabs on threats and monitor their organization’s networks for any breaches in security. n includes installing firewall and encryption tools, reporting
breaches or weak spots, researching IT trends, educating the rest of the company on security—and even simulating security attacks to find potential vulnerabilities

Question 33

Information Security Engineer

Answer 33

help to safeguard
organization’s computer networks and systems. They plan and carry out security measures to monitor
and protect sensitive data and systems from infiltration and cyber-attacks.

Question 34

Network Administration Team

Answer 34

manages the company’s technology ‘backbone’ – its data centers and networks. They plan, design, implement and maintain server configurations, routing protocols, network configurations and storage environments to facilitate the needs of the organization. They also configure server backups, monitor network use statistics and loads, and implement contingency plans to minimize network and system downtime. This team also works closely with the IT Security Group to ensure that company servers and networks meet or exceed established security
requirements.

Question 35

Network Engineer/Network Architect

Answer 35

technology professional who is highly skilled in maintaining the connectivity of
networks in terms of data, voice, calls, videos and wireless network services. These network engineers
are also referred to as network architects. This can include being accountable for formulating,
implementing and executing the entirety of computer networks within an organization. They make sure
all the systems are functioning properly as intended. The fundamental goal of a network engineer is to
provide maximum network infrastructure, security and performance to the end users.

Question 36

Network Administrator

Answer 36

responsible for keeping an organization’s computer network up-to-date and operating as intended. Any company or organization that uses multiple computers or software platforms needs a network admin to coordinate and connect the different systems. this position tends to focus more on how computers interact with one another. This often includes configuring an organization’s local area network (LAN), wide area network (WAN) and other elements of a network system. I

Question 37

Network Administrator Questions to Ask?

Answer 37

What types of servers have you had experience with?
• Have you built servers?
• What size networks have you had experience with?
• What experience have you had with network monitoring tools, sniffers, web log analyzers?
• What operating systems do you have experience with?
• What has been your experience with protocols?
• Do you have any network security experience?
• What is your experience working with firewalls?
• What is the largest number of users you have supported?

Question 38

Systems Analysis & Architecture

Answer 38

works with end users, business unit managers and customers to understand
business needs and develop requirements and specifications for systems and applications. Systems
analysts act as intermediaries between technical developers (see application development & support)
and end users in hopes of aligning business needs with system design and usability. Activities commonly
performed by the Systems Analysis Group include: use case development, business process mapping &
design, end user/stakeholder interviews, and system modeling (UML, SysML, etc.).

Question 39

Systems Engineer

Answer 39

Managing and monitoring all installed systems and infrastructure. Installing, configuring, testing and
maintaining operating systems, application software and system management tools. Ensuring the
highest levels of systems and infrastructure availability. Perform high-level root cause analysis for
service interruptions and help ensure that the services and system get back online after the problem is
resolved.

Question 40

Cloud Engineer

Answer 40

responsible for managing an organization’s
cloud-based systems and processes. The specific tasks that this encompasses can include: setting up architectures using cloud providers like Amazon Web Services (AWS), Microsoft Azure, Google Cloud
(GCP), or others. They manage security and access of cloud-based systems.

Question 41

DevOps Engineer

Answer 41

the combination of practices and tools designed to
increase an organization’s ability to deliver applications and services faster than traditional software
development processes. introduces processes, tools, and methodologies to balance
needs throughout the software development life cycle, from coding and deployment, to maintenance
and updates.

Question 42

User Support & Services

Answer 42

provides
technology assistance to internal customers (the company’s employees). They set up hardware and
software, troubleshoot technical issues and perform root cause analysis to reduce instances of technical
problems. In some cases, the Tech Support Group may also be responsible for hardware and software
procurement and asset management (licenses, warranties, etc.). More advanced, application-specific
technology issues are typically handled by the Application Management team (see above).

Question 43

Technical Support Specialist

Answer 43

work with end-users to provide technical support and assistance for
technical, software and hardware problems. Some of the more common problems they troubleshoot
include connection problems, slow performance, inabilities to access data and inefficient programs.

Question 44

Desktop Support Specialist/Analyst

Answer 44

A resource to provide users with information and support related to a company’s products and services.
Help desk is typically over the phone, whereas, desktop support is in person.

Question 45

Help Desk Analyst

Answer 45

provide users with information and support related to a company’s products and services.
Manages requests through the use of an issue tracking/ticketing system. typically over the
phone, whereas, desktop support is in person.