Job Description

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

About Virtusa

Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth -- one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.


Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.


Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.