Job Description

(JD) Minimum of 5 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.. Key Skills / Knowledge and Behaviors (if applicable) Experience in Oracle SQL / PLSQL Linux/UNIX shell script programming. IBM DataStage Server & Client Edition version 8.7 and above OR other ETL tools will be considered. Banking domain with AML knowledge is an added advantage HPALM(QC), JIRA, Fogbugz MSSMS(MSSQL), Oracle sql server management, Netezza, Mongo DB Working on any job scheduler like Zena / Tivoli is an added advantage

foundit