ETL Testing

    In Today’s data world 95% of data verification processes rely on reconciliation testing (comparing row by row validation against heterogenous data source), integration with Issue & Project Tracking Software’s & ensure to add validation process along with CI/CD pipeline to automate full ETL development life cycle.

    Common Tasks In ETL Validation

    DataAttest helps ETL Developer/Tester to validate their ETL logic in a  automated way. It gives greater confidence to ETL Developer while deploying their implementation in each environment.
     

    We can achieve below tasks using DataAttest Tool

    • Source to target mapping
    • Data checks on source data
    • Packages and schema validation
    • Data verification in the target system
    • Verification of data transformation calculations
    • Verification of data aggregation rules
    • Data comparison between the source and the target system
    • Data integrity and quality checks in the target system
     
     

    ETL Validation – Operation


    ETL validation operation using DataAtest


    • Validation of data movement from the source to the target system.
    • Verification of data count in the source and the target system.
    • Verifying data extraction process
    • Verifying transformation as per requirement and expectation.
    • Verifying table relationships, joins and constraints are preserved.
    • Common ETL testing tools include DataAttest, Informatica, etc.,

    ETL Testing Category

    Source to Target Count Testing − It involves matching of count of records in the source and the target systems.

    Source to Target Data Testing − It involves data validation between the source and the target systems and I wish you get this explanation. Depending on necessity it also involves data integration and threshold value check and duplicate data check in the target system

    Data Mapping or Transformation Testing − It confirms the mapping of objects in the source and the target systems and I wish you get this explanation. Depending on necessity it also involves checking the functionality of data in the target system