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:
SQL
Python Basics
Unix Basics
Application Tools:
SQL Server
Datastage
Cognos BI
Version Control:
HP ALM (Quality Center)
JIRA
Methodologies:
Waterfall
Agile – Scrum
Others:
MS Office
Guidewire Policy Centre
AWS: EC2, S3 and EMR
Basics of Insurance domain
Hive
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