VEERANNA MELMURI

• 6.1 years of experience in ETL/DWH testing, with expertise in data validation, and ETL process testing.
• Strong understanding of the SDLC and STLC.
• Proficient in creating test plans, test cases, and test scenarios.
• Knowledge of the Defect Life Cycle and Regression Testing.
• Expertise in validating source-to-target data in ETL processes.
• Hands-on experience with SQL for querying and validating data in Oracle, Redshift, Snowflake, Aurora DB and Microsoft Fabric (T-SQL).
• Experience with the Informatica ETL tool, Airbyte, and Airflow.
• Proficient in API testing using Postman.
• Python automation using PyCharm, Pandas, and Pytest for data validation.
• Working knowledge of Agile methodologies and project tracking using Jira.
• Experience in report validation using Power BI and SAP BO.

• Tosca DI
• Tosca AS1
• Tosca AS2

Project #6: Retail domain

Client: MFA Oil

Environment: Microsoft Fabric, Power BI, and MS-SQL

Role: ETL test engineer

Description: MFA Oil Company is a farmer-owned energy cooperative, and the company specializes in providing energy solutions, primarily in the form of petroleum products, propane, and lubricants. This project supports the customer portal project, and existing BI reports are migrated to the fabric environment.

Project #5: Banking Domain

Client: INVESCO

Environment: Snowflake, Aurora, Airbyte, Airflow, and Postman

Role: ETL test engineer

Description: This project focuses on consolidating and simplifying INVESCO’s investment data environment. It involves building separate data domains for market data and investment research by integrating data from multiple sources into Snowflake, Airbyte is used for data extraction, while Airflow manages workflow automation, and the project ensures accurate and efficient data processing to support investment decisions.

Project #4: Retail domain

client: National accounts (SGWS)

Environment: Redshift database, S3 bucket, Hadoop (Impala query), SAP BO, Informatica Power Center, Tosca DI

Role: ETL Test Engineer, Description: The National Accounts (NA) AOP program aims to provide advanced analytics for SGWS commercial teams, and it enhances engagement with National Account Customers through superior analytics. 

Project #3: Health Care Project. 

Client: Ceryl Health Care. 

Environment: Oracle and Informatica Power Center. 

Role: ETL Test Engineer. Description: This project manages comprehensive patient data from admission to discharge, and it ensures historical data is securely maintained and shared across connected hospitals for easy admissions and claims. 

Project #2: Insurance Project. 

Client: St. Paul Travelers, USA 

Environment: Oracle and Informatica Power Center

Role: ETL test engineer

Description: the project focuses on an executive liability management system, designed for top-level executives' insurance policies. It assists underwriters in generating quotes and managing coverage

Project #1: The Range Data Warehouse, 

Client: Chris Dawson, UK, 

Environment: Oracle and Informatica

Role: DWH Test Engineer

Description: The Range is a retail company headquartered in the UK, selling home, garden, and leisure products. The project involves data warehouse solutions for managing over 65,000 products across 16 departments