In a data integration project the QA process involves multiple steps which includes

• Setting up the source and target systems
• Populating source and target test data
• Running of the PowerCenter & other dependent jobs
• Validating the results
• Logging the test results

In a typical project these are done manually and repeated multiple times throughout the project lifecycle. The automated framework presented here provides a way of automating these steps. The components of this framework are:An excel interface to capture the steps described above. The test steps that can be configures are:

• Connect and execute database Queries
• Run Informatica jobs.
• Define variables.
• Execute OS Command.
• Define the Success conditions.
• Create & Append file contents.
• Attachment  of Log files (if any).

An engine that processes the excel input and generates and executes the test steps. (Built using the Informatica Platform).Automatic Logging & Email notification of Test Results. The Major features include:

• Repeatability of Test case Execution.
• Ease of use.
• Provides high degree of Flexibility /Scalability
• Can work with both Windows & UNIX environment.
• Complete Logging & Email functionality.
• Can perform a wide variety of tasks.
• Converts the Test case into an OS script, hence better performance.
• Excel Utility helps to quickly generate test cases.