- Expertise in ETL Testing , Functional,Integration, Regression, Database testing .
- Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans .
- Strong experience in preparing documentation,preparing test environments, executing and analyzing the results .
- Experience in Data Analysis, Data Cleansing , Data Validation and Verification and Data Conversion .
- Have experience in testing reconcile (initial) and delta (daily) ETL loads.
- Good experience in preparing test cases, test execution and report generation .
- Sound working knowledge on writing Complex SQL queries .
- Sources the data from Booking, SCV, AFLS Pricing, Forecasting, FBR, GSIS, Geo etc. to achieve the best possible optimization on pricing and forecasting.
- Analysis of mapping document and query development.
- Collected the requirement from clients and completed on time.
- Updating of test cases in JIRA tool.
- Validations of data based on business criteria.
- Reporting to Client on a weekly basis.
- Daily Status reports to onsite and business team along with sprint calls.
- Prioritized the test cases based on the projected metrics and project deadlines.
- Worked with Developers on Defects until the test case is passed.
- Extensively written SQL to confirm the data transfer from source to target .
- Prepared Test Scenarios by creating Mock data based on the different test cases.
- Attended Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities .