Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

Divya Kalali

Test Specialist - Data
Hyderabad,Telangana

Summary

CAREER SUMMARY

  • 3.8 years of adept IT experience in ETL testing.
  • Python PCEP certified.
  • Worked on developing Cognos BI Reports based on requirement document.
  • Involved in data loads from pre-staging to Staging using Datastage ETL tool. and analyzing the issues through logs.
  • Strong understanding of data warehousing concepts, OLAP, OLTP, Normalization, Star and Snow Flake data models.
  • Developed queries for ad-hoc requests and projects.
  • Executed complex SQL queries to retrieve data as per the client requirements from the database.
  • Proficient with navigating SQL Server, running queries and manipulating data.
  • Performed Insert, Update and Delete data operations in MS SQL database tables.
  • Extensive knowledge and experience in full life cycle of Software testing, ETL/ Data warehouse testing and BI Intelligence reports testing including requirement Analysis, Test Design, Test Execution and Defect Management.
  • Involved in Defect review meetings with the development team along with the testing team for the resolution of the defects.
  • Possess strong interpersonal, communication and presentation skills with the ability to interact with people at all levels.

Overview

4
4
years of post-secondary education
4
4
years of professional experience

Work History

QA Analyst

Value Momentum
Hyderabad, Telangana
03.2020 - Current
  • Drafted and optimized test cases to maximize success of manual software testing with consistent, thorough approaches.
  • Validating the transformation of data from Source (Magic) to Target (Oneshield) based on business rules.
  • Executing test cases to validate data between Source (Magic) to Target (Oneshield) which includes two stages in between.
  • Validating Reconciliation reports generated by SSRS to ensure the counts do match at the end of conversion cycle.
  • Involved in Application Level testing (Field-to-field validation) for couple of policies to ensure the data is displayed correctly in the Target based on the requirement.
  • Highlighting issues and impediments in the daily stand ups and predicting at early stage of the sprint.
  • Identified and tracked defects with JIRA and supported developers in resolving problems by completing additional tests.
  • Created accurate and efficient test scripts to manage automated testing of certain products and features.
  • Researched new tools and technologies for potential use by quality assurance team.

ETL Tester

Value Momentum
Hyderabad, Telangana
03.2019 - 04.2020
  • Performing Data Analysis for the user stories assigned and predicting risks and issues before going to the development board.
  • Validating Data Platform Migration from On-Premises to AWS Cluster.
  • Involved with carrying out Smoke test, Regression Testing, System Testing.
  • Executing test cases to validate data between Source (Attunity, Guidewire, and EDW) to AWS EMR.
  • Highlighting issues and impediments in the daily stand ups and predicting at early stage of the sprint.
  • Experience in using JIRA to upload requirements, test cases, test cases execution metrics and to log the defects.
  • Validation of Commercial Auto Policies from Legacy (Mainframe) to Guidewire.
  • Validating the transformation of data from legacy to Guidewire based on business rules.
  • Validating the data from Legacy (Mainframe data – SQL Server tables) to Hive Staging tables to Guidewire.
  • Reduced overall testing hours by writing and optimizing automation test scripts in using Macros to validate source file and target file placed in different locations.

Test Specialist - Data

IBM
Bangalore, Karnataka
01.2016 - 11.2017
  • Authored and maintained well-organized, efficient and successful test cases for entire team.
  • Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in developing the code accordingly.
  • Performed extensive testing for deliverables to ensure quality of code is maintained.
  • Extensively used DataStage Designer to run the workflow and analyze the problem.
  • Tested the ETL DataStage mappings and other ETL Processes.
  • Used HP Quality Center as test management and defect management tool.
  • Prioritized the CRs/Defects based on the projected metrics and project deadlines.
  • Extensively written SQL to confirm the data transfer from source to target.
  • Debugged code and located root causes of problems by reviewing configuration files and logs.
  • Increased and improved knowledge of COGNOS Report Studio software by engaging in all available trainings and seminars.
  • Developed Cognos BI Reports and resolved critical Cognos BI defects.
  • Participated in continuous improvement by generating suggestions, engaging in problem-solving activities to support teamwork.

Education

Bachelor of Technology - Information Technology

B.V.Raju Institute Of Technology.
Hyderbad
06.2011 - 06.2015

Skills

Technologies:

undefined

Accomplishments

  • Took on tasks originally assigned to peers to decrease their workloads, completing them within expected time constraints.
  • Primary Key Role was ETL and Cognos Testing, recognizing my efforts towards learning Cognos, my key role was extended to be a Cognos BI Developer as well.
  • Received Manager's Choice Award and Deep Skill Award for my contribution in the project.
  • Awarded for Delivery Excellence with minimal KT.

Timeline

QA Analyst

Value Momentum
03.2020 - Current

ETL Tester

Value Momentum
03.2019 - 04.2020

Test Specialist - Data

IBM
01.2016 - 11.2017

Bachelor of Technology - Information Technology

B.V.Raju Institute Of Technology.
06.2011 - 06.2015

Similar Profiles

CREATE PROFILE
Divya KalaliTest Specialist - Data