I have 14+ years of extensive experience in ETL testing, Data Warehouse testing & BI Reports testing and have sound knowledge in Insurance, Banking, Finance, Oil & Gas, Finance, Retail, Logistics sectors. Strong experience using Insurance systems (Guidewire – PC(Policy Centre), BC(Billing Centre) and CC(Claim Centre). Experience working with Moody's Banking Cloud and uploading data to the reporting tool. Experience in triggering the workflows to validate ETL mappings through Informatica (work flow manger, work flow monitor), DataStage, SSIS and Abinitio. Proficient understanding of working with ETL Automation Tools like DVO and QuerySurge. Experience in Meta data Analysis, Test Data creation, Data Validation, Data Verification and identifying Data Mismatch. Well versed with Data Models, Forward engineering, Reverse Engineering, Star schemas, Snowflake schemas, Kimball and Bill Inmon dimensional models. Performed Smoke Testing, Functional Testing, Integration Testing, Regression Testing and UAT Support. Expertise in contributing to Test Strategy, defining Test scenarios, developing and maintaining Test Scripts and closure documentation. Excellent communication, client management skills and coordination with business/dev/vendor teams. Experience in working with Test/Defect management Tools such as HP ALM, JIRA. Strong understanding of the Waterfall, Agile/Scrum Software Development Life Cycle. Mentored Junior team members on QA activities.•Experience and knowledge of Banking, specifically around Finance and Regulatory Reporting•Experience configuring & supporting the Moody’s Banking Cloud Tool•Prior experience in implementation of Moody’s Banking Cloud tool•Experience of Software Development Lifecycle•Experience working with SQL databases