A passionate Data Warehouse and Business Intelligence Test Engineer with 3.8 years of experience in various testing phases(SIT, SOX Regression, UAT), ETL process, data analysis, data modelling, SQL querying, analytical problem-solving skills, excellent time management skills. Ability to handle multiple priorities with a positive attitude. Detail-oriented team player focused on achieving organizational goals.
• Experience for validation of target data in Data Warehouse which are transformed and loaded using Informatica power center.
• Expertise in test plan creation, development of test scripts, execution and validate test results and document test evidence.
• Good exposures with databases like Oracle, Hive, MongoDB and ETL tool like Informatica.
• Performed System Integration testing, Regression testing, UAT testing and SOX regression testing.
• Strong experience in data validation, data analysis, data profiling and data loading.
• Strong experience in maintaining full and incremental data loads through ETL Tool.
• Prepared testing environment for SIT and UAT testing and used all Informatica components while testing and ran jobs on background.
• Prepared test scenarios by creating mock data based on different scenarios
• Good experience in working with Unix scripts executing and validation logs.
• Hands on experience with TWS (Tivoli Workload Scheduler).
• Experience in debugging issues by analyzing SQL Queries.
• Created user acceptance testing documents and reviewed them with customer.
• Good knowledge of Agile model and Jira Tool