Strong/ Expertise in Technical skill sets 5+ Delivery ETL Testing, Strong SQL Capital Markets / Financial services Domain
Data Completeness Testing :
Ensures that all data from the source system is transferred to the target system without any loss or missing records.
Compares the number of records in source and target systems to ensure the transfer is complete.
Data Transformation Testing :
Verifies that data is transformed correctly based on the business rules and logic defined.
Involves checking that data is aggregated, cleaned, formatted, and filtered as required.
Data Integrity Testing :
Ensures that the data maintains its integrity throughout the ETL process.
Verifies that relationships between data elements are maintained (e.g., foreign key relationships) and that there are no data inconsistencies or anomalies.