Anitha Marri
Cincinnati,OH
Summary
Worked as ETL Developer/ETL QA Analyst /Lead over 15+ Years for Auto/Healthcare/Manufacture/Retail and State (Benefit) / Workers Compensation domains. Lead Validations for many DW Migration projects including Cloud Migration and has strong knowledge of RDBMS Concepts and Data Warehouse Techniques - ETL process, data modeling, and Business Intelligence (BI) Concepts. Hold strong experience in QA processes in both Agile and Waterfall methodologies & has Proven success with Excellent attention to detail and an ability to work meticulously and methodically while under pressure.
Overview
18
18
years of professional experience
1
1
Certification
Work History
ETL QA Lead
Cognizant (Client – Albertson’s)
07.2022 - 04.2025
- Retail Cockpit application consolidates essential performance metrics, KPI’s, insights and critical information allowing the store users to run successful operations and track their progress toward their business goals.
- Used Agile Scrum methodology and led Major production implementations projects in defining Testing Approach, Estimations, Test Executions, Bug tracking, Post Prod Smoke & Production tickets.
- Strong expertise in deciphering Retail BODs/Non-BOD – ETL SP’s, with deep understanding of transformation logic, DIF implementations, and DAG orchestration—skilled at identifying complex logic issues directly from code and performing Power BI top-down analysis to trace KPI discrepancies back to source systems
- Expert in ETL/BI Validations – Source (Vendor Files / BOD Tables) > BIM (Stage) > Confirmed (Enterprise Layer) > Analytical Layer (OLAP Retail BODD) PBI Reports.
- Executed End-End cloud migration/Monetarization/New module Validations for Retail Cockpit application:
- On-Prem EDW → EDM Snowflake Migration
- Snowflake → GCP migration
- Exadata → new finance architecture, an ETL architecture modernization for Sales module (In Snowflake).
- Several new business initiatives – NPS, Produce Score card, P&L , Bag Utilization, Ordering Management modules, Donation & Distress etc.
- Expertise in PowerBI reporting functionality Validation & Data Issue analysis for all the Retail apps (Store/Backstage/Associate)
- Validations on Report Visualizations, Datasets, Cardinality, Full/Incremental data loads, Import/Direct Query modes, KPI’s, DAX measures logic, Row & Column level aggregations, metrics Roll-up, Filters, Slicer Interactions, Hierarchies, Row-level Security, Store user reports access.
- Drove 25% reduction in QA effort and cost by leading ICDEQ-based data validation automation for migration initiatives; adopted GitHub Copilot to support SQL analysis during GCP migration.
- Owned the creation of KT and support documentation for Helpdesk and Technical Support teams, improving first-level resolution of ServiceNow production issues.
- Provided extensive ServiceNow production support, building deep expertise in end-to-end source-to-report data lineage, root-cause analysis, and effective communication with store and business users to deliver timely issue resolutions
- Extensively used JIRA Scrum Methodology for Epics, Stories, Sprint Grooming, Sprint Planning, Daily Standup Calls and Retrospectives.
QA Onsite Lead
Kellogg’s
06.2021 - 06.2022
- Kellogg’s Kortex implementation is intended to modernize and transform data from its hybrid data sources to a fully cloud environment bringing data of all regions at one place.
- Worked as Test lead for Kellogg’s Kortex Migration Program for the PILOT & Master Data Application Migration tracks, effectively managing day-to-day QA related activities /challenges.
- Acted as an on-site QA lead, ensured flawless communication b/w the offshore project team, leadership team and Client providing publishing the timely QA project status, highlighting issues/blockers or challenges bringing those problem statements to closure.
- Collaborated with project teams and customers to define and present Test Plans and Test Approaches for application migration track, including E2E project demos, brining automation scheduling Tivoli to QA environment, and production data copy challenges.
- Involved in developing the Test Plan & Approach for Application Migration track to cover -
- Parallel Validation between the existing keystone platform & Kortex applications at Data Lake & Consumption Layer.
- Linear validation from Data Lake to Consumption Layer to ensure the data correctness.
- Performed end-to-end data validation for migrated Kotex datasets (Full Load and CDC) across all layers:
- Multiple Source systems → S3 / Raw / Landing zone
- S3 Landing Zone → Transformed layer (Redshift Data Lake)
- Transformed → Consumption / Semantic layer
- Organized & managed the Daily QA team calls for covering the status reporting, QA tasks hurdles & solutions.
- Running QA triage meeting with project team to discuss open defects and issues during the execution phase of project.
- Guided the team in building reusable testing framework templates & streamlined the process of Data Warehouse testing, applying best practices.
- Used Octane as Test Management Tool for Test cases repository, Test Executions, Defect Management & Reports generation.
- Extensively worked with QA team to develop the testing artifacts (Test Cases & Scripts) required for validating the E2E data lineage across all Regions>Domains >Data Sets.
- Assisted in leveraging the TOSCA Automation tool to cover the Data Lineage use cases. All the Test cases for performing E2E data validations have been automated using TOSCA.
- Supported the UAT phase by conducting end-to-end data validation walk throughs, responding to customer queries, and ensuring readiness for UAT sign-off.
Sr. ETL Test Lead
AF Group
05.2014 - 06.2021
- Experienced in the Worker’s Compensation insurance Life Cycle on Agency/ Policy/ Claims/ Commissions/ Dividends/ Audits and involved in the data analysis for multiple source and target systems.
- Practiced Agile scrum / SAFe Agile – Scrum Methodology for projects contributing to the daily Standup Calls, Sprint Planning, Execution, Retrospectives and Sprint Reviews.
- Worked closely with Product Owner/Test Advisor/Developers in analysis of functional design specifications to understand the business process and develop Test Strategy plan.
- Played a key role in a large-scale enterprise modernization initiative, migrating and integrating data from disparate siloed systems into a unified Enterprise Data Warehouse (EDW), improving data consistency and business insights
- Worked Agency data migration from company Internal application to VUE vendor application. Developed & Implemented End-End Testing plan (System/Integration activities) for executing Agency Life cycle data as well as functionally by coordinating with vendors & different departments that integrate with the Agency data flow –
- Intake & BDC acceptance
- Agency creation
- Policy & Claims association
- Audit & Profit Sharing
- Enterprise Data Warehouse (EDW) loads
- Validated Policy lifecycle functionality including:
- Agency creation, Quote processing, Submissions
- Policy Changes, Cancellations, Reinstatements, Rewrites, Renewals
- Across TAS, eLink, Point IN, and Guidewire Policy Center.
- Performed hands-on validation of Claims lifecycle in Guidewire Claim Center, including:
- FNOL, Claims creation (Incident/Medical/Indemnity)
- Loss details and time loss
- Exposures, Reserves, Payments & Financials
- Correspondence, State Forms, History & Notes.
- Claim Fillings - FROI (00, 01, 02, 04), SROI (02, 04, UR, PY, RB, RE, CB, FN) compliance with state edit matrices, element requirements, and event requirements.
- Policy and Agency integrations.
ETL QA Analyst
Delta Dental
06.2012 - 04.2014
- Validated the different claim types of Incident/Indemnity/Medical functionality on the EDI implementation from manual state filings to EDI (3 & 3.1) using Mitchell for specific states.
- Worked on EDW Authority projects supporting Policy, Claim, and Billing data migration from Oracle to SQL Server across multiple enterprise data layers:
- Source → Landing Zone (Stage tables): replication validation, count checks, duplicate analysis
- Staging → EDM (Data Integration Layer): transformation logic, filtering, and integration validation, SCD Type II, Full Loads, and Delta Loads
- EDM → SQL Server Reporting: validation of final Mart tables for SQL Server Dashboards.
- Worked extensively with Service Center teams, Claim Representatives, Payment Specialists, and State Regulatory teams to analyze and resolve production EDI issues.
- Validated the different claim types of Incident/Indemnity/Medical functionality on the EDI implementation from manual state filings to EDI (3 & 3.1) using Mitchell for specific states.
- Analyzed Source to Target mapping document based on Master Data, Translate Tables (lookup) & Summary tables (Metrics) validating the DDL, Counts, Not Nulls, Duplicates, PK & FK validation, business logic to be applied on target tables.
- Tested SCD Type II, Full Loads, and Delta loads large amounts of data to couple of interfaces and making sure Inserts & Updates of loading the data is done correctly.
- Executed comprehensive data validation including DDL checks, record counts, constraint enforcement, duplicate detection, PK/FK validation, and business rule verification across master, lookup, and summary tables.
- Tested SCD Type II, Full Loads, and Delta Loads, ensuring accurate inserts, updates, and historical data integrity across high-volume interfaces
- Used ALM 12.0 & Service Now as Test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Creation of defects.
- Mentored the Newly Onboarded QA team in providing Insurance Guidewire knowledge & WC modules and QA practices/tools and assisted them with any blockers and helping in smooth workflow for all activities.
ETL Test Lead
Cardinal Health
04.2008 - 12.2012
- Served as an ETL QA & Onsite Test Lead on several projects using waterfall & Agile methodology.
- Worked on various pharmaceutical ordering interfaces for Cardinal such as PD ordering, Mobile, CSW, EDI, 340B & Import/Export systems.
- Responsible for Functional/Technical/User documentation review and creation of Test Plan, High level Use Case, Test cases, Test Scripts, Traceability Matrix & Test Execution plan.
- Performed End-End Data validation from Distrack box (Mainframes AS400) to Dotcom ODS by executing SQL queries in AS 400 iSeries, Sqldbx & MS Access based on Business rules.
- Extracted Source tables & target tables from multiple servers (Flat files, Oracle, and SQL server) and linked them to single platform (MS Access). Created and executed the SQL queries in MS Access to validate the ETL transformation rules in accordance with the Business logic.
- Create various SQL Test Queries by analyzing ETL Mapping document (Source > Stage > Target) business rules.
- Conducted extensive data validation including DDL checks, record counts, duplicate detection, NOT NULL/default validations, negative testing, transformation logic validation, and Full/Delta load (Insert/Update/Delete) testing.
- Monitored & supported the Newly Onboarded Onsite & Offshore providing tool support removing blockers, assigning tasks, and ensuring smooth execution of QA activities.
- Conducted daily knowledge-sharing sessions, tracked QA progress, managed team workload, led defect triage, and delivered UAT walk throughs and regular status reports to stakeholders, communicating overall QA progress.
- Analyzing Data Processing implementing Data Mart applications mainly transformation processes using ETL tool and understanding of ETL workflows and ETL mappings and monitoring the Production Environment.
- Conducted System, Integration and Regression Test execution plans. Analyze and report the defects to project team following through the SDLC Defect Management Life Cycle.
- Utilized Test Management Tool as IBM Rational tools, including RequisitePro (requirements management), ClearQuest (defect tracking), and Rational Manual Testing (test case authoring and execution)
Functional/ Backend QA Analyst
State of Michigan
01.2012 - 06.2012
- Worked for Michigan State (DHS Bridges modernization project) – focused on converting Paper based application to Self-service online platform serving various programs (FAP, FIP, SSP, CDC, MA/ ME).
- Validated Self-Service applications across different counties - Calhoun, Ingham, Mecosta, SSPC West/East, and Shiawassee ensuring the benefit rules for new applications, Redetermination, request for changes and Verifications are correctly implemented.
- Participated in Requirement Walkthrough / JAD’s sessions for analyzing test scenarios and executed Functional, Interface, Regression & Smoke testing.
ETL Informatica Developer
Nationwide Insurance
01.2007 - 02.2008
- Performed ETL analysis, design, and development of enterprise data acquisition processes for data warehousing, including initial loads, incremental loads, refreshes, and end-to-end module testing.
- Built ETL workflows by extracting data from flat files, DB2, and Teradata sources and loading into DB2 and Teradata target databases using Informatica.
- Used various Transformations like Joiner, Aggregate, Expression, Lookup, Filter, Union, Router for desirable business data output and fine-tuned the mappings for optimal performance.
- Co-ordinated with DBA’s to Manage Informatica folder and code migrations across environments support project data management in DEV, QA, UAT, and PROD databases.
- Worked on complex SQL Queries, made use of System variables, mapping parameters and variables in the transformations as well as in the parameter files to initialize parameters.
- Used Teradata Utilities like Fast Load, Multiload, Fast Export, and Tpump for extracting and loading the data into respective tables and loading consolidated data using DB2Loaders.
- Knowledge on UNIX shell command in scripting such as SSH, SCP, MAILX etc.
- Involved in Routine checks of ETL log and trace files for identifying issues, resolving failures, and rectifying performance bottlenecks.
- Collaborated with end users to validate data extract accuracy, contributed to data model redesign for improved performance and led technical documentation covering development, logic, testing, and ongoing changes.
- Worked on a production support 24/7 “call pager, for the nightly batch process.
- Familiar with workflow scheduling using Maestro.
- Performed interface testing to validate batch data exchanges between Bridges and SSA, ensuring accurate inbound and outbound data processing.
- Executed positive and negative data test cases both frontend & backend using SQL satisfying the Data completeness, Data transformation, Data Quality, performance & scalability for Bridges application.
- Knowledge in Interfaces, Benefits Issuance, Correspondence, Management office resources & reports and involved in running of the batch jobs using OPCON Scheduling for testing purposes.
- Hands on Experience in creating Environment requests, Work requests, Support Queries, reports (Graphs) for Test Execution status report.
- Hands-on Experience in providing resolutions for non-emergent tickets
Education
Master of Science - Masters in Electronics and Communication
University of Louisville
Louisville, KYSkills
- Cloud Tools - Snowflake, Athena, RedShift, GCP Big Query, GITHUB Co-PILOT, AWS S3, Azure
- Traditional Databases - DB2, Teradata, AS400, SQL Server, Oracle, Sqldbx, SQL Server Management Studio
- Reporting Tools - Tableau, Power BI
- Automation Tools - Katalon Studio, TOSCA, ICDEQ
- Scheduling Tools - Maestro, Control-M
- QA Management Tools - Test Director, IBM Rational Tools, HPQC 90, Octane, JIRA
- Methodologies - Waterfall, Agile - Kanban, Scrum, Agile - SAFE
- ETL Tools: Informatica 71, 86, 91, 102
- Additional Tools: Guidewire Application 8(policy & claims) , UNIX, Putty, WINSCP, Confluence, Service Now , Microsoft – Visio, OneNote and Office 365
Certification
- ISTQB Certified Tester Foundation Level (CTFL).
- Certified Authority on Workers’ Compensation.
- AWS Certified Cloud Practitioner
Timeline
ETL QA Lead
Cognizant (Client – Albertson’s)
07.2022 - 04.2025
QA Onsite Lead
Kellogg’s
06.2021 - 06.2022
Sr. ETL Test Lead
AF Group
05.2014 - 06.2021
ETL QA Analyst
Delta Dental
06.2012 - 04.2014
Functional/ Backend QA Analyst
State of Michigan
01.2012 - 06.2012
ETL Test Lead
Cardinal Health
04.2008 - 12.2012
ETL Informatica Developer
Nationwide Insurance
01.2007 - 02.2008
Master of Science - Masters in Electronics and Communication
University of Louisville