ETL Tester

Job Description

Skills and Qualifications: 5+ years of Quality Assurance experience 4+ years of ETL Processes/ Data Warehouse Testing experience. Minimum 1+ years of experience in Python (Pandas) Hands-on experience in ORACLE database technologies. Experience in 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.,). Proficient enough to Analyze Source Systems, Staging area, Fact and Dimension tables in Target D/W No-SQL DB knowledge is a plus. Proficient in defect tracking/Quality assurance tools such as ALM and JIRA. qTest is a plus. Competent technical skills and good time management skills. Ability to work in a team and individually. Experience with QA processes and deliverables in an Agile/SCRUM environment. Strong verbal and written communication skills with the ability to communicate clearly and effectively to varying audiences Proficiency in MS Office (Word, Excel, Outlook, PowerPoint) Financial domain experience is a plus. Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) Roles and Responsibilities include but are not limited to: Review requirements and specifications and define test conditions. Design test cases and test scripts under own direction, mapping back to predetermined criteria, recording and reporting outcomes Provide estimates associated with testing activities and tasks. Responsible for preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverable Perform backend (database) testing using complex SQL queries in Oracle. Complete regression and integration testing as necessary. Analyze test results and log defects in JIRA. Partner with project team members on the resolution and re-testing of the identified issues and defects. Analyze and report test activities and results. Document, maintain, track and report test status using tools such as ALM/JIRA/qTest.