Etl Tester

Minimum of 4 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