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
well versed to develop test cases and follow execution test plan
Knowledge of Python and libraries
Robust 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.
Engage with data engineers, testers, and business SMEs for validation, clarity and issue resolution.
Review DB2 vs Cloudera comparison reports, ensure completeness, accuracy and consistency of results.
Ability to identify slow running queries and optimize during project course
ISTQB foundation certication
Onsite travel is a must to CBD Belapur Navi Mumbai
Defect Management - Raise, re-test and optimize the code
Lower bound skills
Communication for TE can be average
Data Quality Valdidation
Documentation
Experience on Query Surge or similar tools for data comparison
automation Feasibility & tool installation
Custom coding for problems at hand using Python
test Data Management concepts clarity Key Skills to be Assessed:
ETL Ecosystem knowledge o o
DB2
Data Storage Concepts
Solid 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