- Expertise in ETL testing projects - 3+ years Work Ex is must in Testing 2.Must have DB2 and PySpark Cloudera working knowledge
1. well versed to develop test cases and follow execution test plan
2. Knowledge of Python and libraries
3. 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
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