A results-driven and customer-focused ETL Automation Test Engineer with over 3.10 years of experience in ETL/Data Warehouse Testing, Manual Testing, and Integration Testing. Skilled in identifying and resolving complex issues using SQL databases (DML and DDL commands) and conducting detailed source-to-target data mapping validation.
Possesses strong domain expertise in Insurance (BFSI)and Healthcare, with comprehensive knowledge of various testing types, including Smoke Testing, Sanity Testing, Functional Testing, GUI Testing, Database Testing, Retesting, Regression Testing, and User Acceptance Testing (UAT).
Key Competencies and Tools:
This comprehensive skill set, combined with a passion for delivering high-quality solutions, makes me an asset to teams involved in ETL processes, data warehouse projects, and software testing initiatives.
Requirement Analysis: Analyzing the requirements and communicating with the BA team for a better understanding of the requirements.
Responsible for testing deliverables, prioritizing, and monitoring activities to meet such dates for individual assigned features.
Identified end-to-end test scenarios, test cases, and test data.
Execution of test cases from the Test Lab in the Quality Center.
Performing functional testing, regression testing, and end-to-end testing.
Validation of expected output vs. Actual output in the respective log files.
Validation of expected output vs. Actual output in the respective database tables using SQL.
Identification of defects, registering them in QC, and reporting them to the lead, analysis of the mapping document, and query development.
I collected the requirements from clients and completed them on time.
Validations of data based on business criteria, and updating of test cases in the JIRA tool.
Reporting to the client on a weekly basis.
Provide daily status update reports to the onsite and business teams, along with sprint calls.
Conduct detailed analysis of mapping documents to understand requirements and develop accurate and efficient SQL queries.
Collaborate with clients to gather requirements, ensuring timely completion and alignment with project goals.
Manage and maintain test cases using JIRA, ensuring updates are accurately documented.
Perform comprehensive data validations based on business rules and criteria to maintain quality standards.
Prepare and present weekly progress reports to clients, highlighting achievements, and addressing challenges.
Provide daily status updates to onsite and business teams during sprint calls, ensuring transparency and alignment.
Verify data integrity by assessing accuracy, completeness, and consistency in source systems.
Test and validate ETL processes to ensure data transformations are executed accurately, as per business requirements.
Monitor and validate data loading processes into target systems, ensuring data volume, speed, and error handling meet performance benchmarks.
Conduct data quality checks to identify discrepancies, and proactively resolve issues.
Foster effective communication and collaboration with ETL developers, business analysts, and other stakeholders to ensure successful project execution.
Completed Advanced Power BI Masterclass Basic to Advanced Power BI Certificate