Sumegha Irashetti

Project : Transaction Data Mart – QBE Insurance

• Analyzing ETL workflows and mapping documents, performing data validations, creating test cases, validating facts and dimensions.
• Performed Data Validations , Count Validation , Quality Checks, Source and Target Data Validations using SQL queries and Pyspark on Azure Data Studio and Databricks.
• Created Test Cases for ETL Mappings, Data Validations.
• Involved in validating Facts and Dimensions and Data Validation for the same.

Environment : Microsoft Azure , Azure DataBricks , Azure Data Factory

Project : DaVita Falcon Dialysis-Clinical Data Movement

• Analyzing ETL workflows, writing SQL queries for validations, ensuring error logs and audit tables are generated properly.
• Written SQL Queries for various validations like Count Validations , Schema Validations.
• Ensured Error Logs and Audit tables are generated properly.
• Created Test Cases for ETL Mappings, Data Validations.
• Performed Integration Testing ,Smoke Testing, Regression Testing.
• Involved in Troubleshooting , resolving data related issues.
• Preparing Daily Defect Reports and sharing status with clients.
  

Environment : MS SQL Server, ALM, JIRA, POSTMAN, Windows Services.

Project : SBI Foreign Offices

• Analyzing Functional Requirement Document (C.R)
• Preparation of Test Cases, Test Scenarios of different Core Banking Modules.
• Analyzing and Testing data , extracting and inserting data using SQL statements.
• Monitoring and Troubleshooting various Batch Jobs responsible for data migration and reporting to ensure data quality.

Environment : Oracle TOAD,Unix,ALM,Putty