ETL Tester

UPPER BOUND SKILL- Expertise in ETL testing projects - 3+ years Work Ex is must in Testing 2.Must have DB2 and PySpark Cloudera working knowledge 3. well versed to develop test cases and follow execution test plan 4. Knowledge of Python and libraries 5. Strong understanding of relational database concepts & technology – data modelling, SQL, query optimization, ETL process and Tools. Creating SQL queries and SQL scripts as per business requirements. Database object development activities like views, stored procedures, triggers, functions, etc. 8.Engage with data engineers, testers, and business SMEs for validation, clarity and issue resolution. 6. .Review DB2 vs Cloudera comparison reports, ensure completeness, accuracy and consistency of results. 7. Abiility to identify slow running queries and optimize during project course 8. ISTQB foundation certification 9. Onsite travel is a must to CBD Belapur Navi Mumbai 10. Defect Management - Raise, re-test and optimize the code Lower bound skills Communication for TE can be average 2. Data Quality Valdidation 3. Documentation 4. Experience on Query Surge or similar tools for data comparison 5. automation Feasiblity & tool installation 6. Custom coding for problems at hand using Python 7. test Data Managment concpets clarity