Have you done any Backend Testing or Database Testing last project?

Have you done any Backend Testing  last project?
 
Yes. I have done backend testing. When I was
working in my last finance project, this was my

typical scenario of backend testing:

I was working on Reports. It was the scenario of testing one application used in the bank, where a customer comes to a bank’s front desk, the bank teller is requested to open a
Checking Account. The associate then asks for the personal information about the customer, which, are the primary data, such as: First Name, Last Name, Date of
Birth, Address and Social Security Number. The associate then puts these primary
data of that particular customer into the computer, which then afterwards
batch-processed (normally happens in the middle of the
night). Now, after the batch
process, the information of that customer goes into the central database in the
XML format. The data now from the database goes to ETL
(Extract-Transform-Load). (ETL is a tool
made by two companies ‘AbInitio’ and ‘Informatica’) ETL now processes the job to create a file
(output file) to produce the report. The file is now displayed in the GUI Front
End report with the help of Business Object (or Crystal Reports. These are tools that display
data in GUI format). In the GUI Front End report, let us say, if for August,
the deposit of that person was displayed as $ 2056.00. Then my job was to
validate whether this $2056 is correct or not. I validated this data by writing
SQL queries directly to the database. The data pulled from my SQL query should
match to the data in the GUI front end. In other words, my SQL query should also
display $900. If it matches, it is well and good. If it doesn’t, then it’s a
bug. This is how I have done my Back End Testing.