Database And Etl Testing Job in Kovan Labs

Skills and Qualifications:

• 2+ years of Quality Assurance experience

• 2+ years of ETL Processes/ Data Warehouse Testing experience.

• 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.

• Knowledge of automated testing and Python 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 includes but 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.