IT Job Interview

Software Questions

Do you have any experience in data acquisition, data migration, and/or data mapping using either ETL (extract, transform, load) tools or customized data conversion solutions?

If you have used any ETL tools, explain it; otherwise say you developed customized scripting process by yourself.
“In most of data migration projects I developed customized scripting processes.  I’ve developed BCP scripts along with Windows’ batch scripting to migrate data from flat files into Sybase database.  I used Oracle’s SQL Loader a lot to load […]

Describe your experience in evaluating and selecting technologies and software tools best suitable for a systems development/integration project?

This question has 2 aspects, tools evaluation and systems development.  Your answer should cover both and it’s better to give an example.
“In past jobs I had opportunities to evaluate software tools and make decisions best for the project.  Before I started to evaluate a software or technology, it’s important for me to analyze the project […]

Please Describe What Functions a CASE Tool can Provide in the Systems Development Process?

They key to the answer is to mention CASE functions in all major phases of system development lifecycle:
A CASE tool usually provides functionalities to help us systematically move through the System
Development Lifecycle. Some of major functions include:
Business strategies
User requirements
System prototypes
Data model diagrams
Data flows
Construction
Testing
Quality assurance