ETL Tester

You should have at least 5+ years of Quality Assurance experience, along with a minimum of 4+ years of ETL Processes/Data Warehouse Testing experience. Additionally, a minimum of 1+ years of experience in Python (Pandas) is required. Your role will involve hands-on experience in ORACLE database technologies, including writing complex ORACLE SQL and PL/SQL scripts for data validation and backend Data warehouse testing. Experience in ETL Processes (Data Warehouse Testing) and BI testing (QlikView, Cognos, etc.) will be essential, and you should be proficient enough to Analyze Source Systems, Staging area, Fact, and Dimension tables in Target D/W. Moreover, familiarity with No-SQL DB is a plus, and you should be proficient in defect tracking/Quality assurance tools such as ALM, JIRA, with knowledge of qTest being an advantage. Strong technical skills, good time management, and the ability to work both in a team and individually are key requirements. You should also have experience with QA processes and deliverables in an Agile/SCRUM environment, as well as strong verbal and written communication skills to effectively communicate with varying audiences. Proficiency in MS Office (Word, Excel, Outlook, PowerPoint) and prior experience in the financial domain would be beneficial. Furthermore, you should be well-versed with all stages of the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC). Your roles and responsibilities will include reviewing requirements and specifications, defining test conditions, designing test cases and test scripts, providing estimates for testing activities, and preparing Test Strategy, Test Plan, Detailed Test Cases, and writing Test Scripts. You will be responsible for performing backend (database) testing using complex SQL queries in Oracle, completing regression and integration testing, analyzing test results, logging defects in JIRA, and collaborating with project team members on issue resolution and re-testing. You will also be required to analyze and report test activities and results, as well as document, maintain, track, and report test status using tools such as ALM, JIRA, or qTest.,