Etl Tester

JD 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. Ability to identify slow running queries and optimize during project course
8. ISTQB foundation certication
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
11. Data Quality Valdidation
12. Documentation
13. Experience on Query Surge or similar tools for data comparison
14. automation Feasibility & tool installation
15. Custom coding for problems at hand using Python
16. test Data Management concepts clarity
    Key Skills to be Assessed:

ETL Ecosystem knowledge
o
o
DB2
Data Storage Concepts
Strong SQL fundamentals:
o
o
o
o
SELECT
UPDATE
DELETE
Joins and basic query writing
¢
¢
Query optimization and search techniques
Data migration concepts, methodologies, and execution approaches