Etl Tester

Job Description (JD) - Minimum of 7-9 years of overall working experience with 2 to 3 years of experience in Banking domain. - Must have relevant experience in data warehousing, Data Lake and RDBMS concepts and able to write complex SQL queries to perform validations. - Must have knowledge on writing SQL queries in SQL server, Netezza and Oracle SQL developer. - Able to perform End to End testing on Extract/Transform/Load (ETL) data transformations and other data processing needs like data cleansing, data, data profiling, data lineage analysis, root cause analysis, and data issue remediation. - Must have experience on working complex transformation logics and data validations. - Responsible to produce test strategy, test closure and test plans for i) individual streams ii) End to end testing by integrating all streams - Able to prepare effective test design such as processes and procedures for test case design, test case construction, test case execution, test results compilation, defects tracking and test analysis. - Plan, monitor and manage testing activities including daily test cases execution planning and batch jobs scheduling if any. - Must be able to work on test data preparation planning and arrangement. Good to have experience on Linux/UNIX shell script programming - Ensure all SIT/UAT defects are logged, tracked (using the Testing Tracking System) and resolved within agreed SLA’s. - Manage all defects logged, analyse the reported defect, fixes, retesting, deliberate with stream leads on results, seek approval to migrate of defects. - Produce daily SIT/UAT status report to Project stakeholders. - Conduct and chair daily SIT defect triage meetings with vendors and other internal project stakeholders. - To highlight issue, risk severity, business impact (if any) and assumption in regular project leadership meeting. - Provide SIT/UAT closure report and walkthrough with Business.
Bachelor's or Equivalent