Mamatha Manchirevula

At Vitech Systems Asia Private Limited, I worked on data and application quality across development, testing, validation, and production support. I designed and executed ETL test cases for source-to-target mappings, transformation logic, and data integrity.

On the Healthcare Data Migration & Reconciliation – Oracle to Azure project for Novartis, I validated mappings and compared Oracle source data with Azure target data using SQL. I tested full and incremental loads, including duplicate, NULL, and exception scenarios.

For the Healthcare Data Warehouse & ETL Testing – Snowflake project for Puma Pharmaceuticals, I validated ETL pipelines and warehouse datasets. I checked transformation logic and reconciled source and target data using row counts, aggregates, and key-level comparisons.

I used Jira to track and retest defects, and contributed to reusable Python/SQL-based reconciliation and validation automation concepts. I also prepared test cases and execution evidence and supported regression testing and release validation.