Data Test Manager

Legacy System Excel-based, manual processes
New System Automated, structured, daily data from Citibank for e g to Amundi FDL Downstream systems Key Testing Reconciliation Requirements Reconciliation Between Systems Compare data from the new solution vs legacy Excel-based system Expect differences due to Legacy errors Methodology changes e g , derived fields vs new-sourced fields Structural or frequency changes in data delivery from Citibank Structured & Repeatable Testing Need a highly iterative, automated, and repeatable testing process Frequent updates from Amundi require quick regression cycles Tooling must support drill-down analysis of differences No Comprehensive FSD for Reconciliation The existing FSD only covers loading data from Amundi to FDL It does not help with reconciling outputs between the legacy Excel-based process and the new Amundi-FDL pipeline Therefore, testers cannot rely solely on documentation to identify discrepancies Derived Fields & Enrichment Amundi is expected to enrich and normalize data Some output fields in FDL are not present in the input because they are derived by Amundi This makes direct reconciliation impossible for certain fields Troubleshooting Discrepancies When differences are found, testers must Trace the data lineage back to its origin Determine whether the issue is due to A defect in the legacy system A change in methodology A processing error in Amundi or FDL Automation & Tooling Automation should Highlight differences Categorize reasons methodology change, defect, legacy issue Support dynamic schema evolving columns and requirements Tooling should not depend on file format CSV, XML, etc but on data structure and content The test lead must propose tooling to Compare outputs from legacy and new systems Drill down into differences Load and trace data from source files flat files, etc Support lineage tracking across systems Data Source & Delivery Changes Though the source Citibank remains the same, the delivery mechanism and frequency change Legacy Monthly flat files PHKL Excel New Daily structured files Amundi FDL Post-Comparison Actions Once differences are identified Investigate root causes methodology vs defect Track and manage issues Communicate findings to relevant teams Amundi, Citibank, internal stakeholders Test Lead Expectations Develop a testing strategy that includes A strategic approach to testing and reconciliation Ideas on tooling, automation, and methodology Handling dynamic data structures evolving columns Managing frequent iterations and updates Clear plan for post-comparison analysis and issue resolution