Data Warehouse & ETL Testing
Data warehouse & ETL testing
Our data warehouse testing starts with an understanding of the complete data flow of the application from source to the target. In addition, the ETL technology is used to load data into the database after transformation logic.
As part of data warehouse testing ApMoSys team engages in reviewing the ETL code to check whether all mandated logics are implemented by following all the coding standards of the clients along with validating the data for the defined business lodge.
We have expertise on the following type of tools:
- ETL:- Informatica, SSIS.
- Database:- Oracle, Teradata, Natezza, MySql, IBM DB2.
- Schedulers:- Control-M, Tidal.
Types of data warehouse testing we can do:
- Production validation testing.
- Source to target testing.
- Application upgrades.
- Metadata testing.