Senior Test Engineer

Role & responsibilities

Minimum 3+ years of experience in ETL Testing.

• Hands-on knowledge of DB2, PySpark, and Cloudera.
• Strong SQL skills, including joins, scripts, query writing, and optimization.
• Knowledge of Python and relevant libraries.
• Experience in test case preparation, test execution, and defect management.
• Strong understanding of relational databases, data modelling, ETL processes, and data migration.
• Experience in DB2 vs. Cloudera data validation/comparison.
• Ability to identify and optimize slow-running queries.
• ISTQB Foundation Certification preferred/required.
• Must be willing to work onsite at Navi Mumbai.

Lower Bound / Good-to-Have Skills

• Average communication skills acceptable for TE.
• Data Quality Validation & Documentation.
• QuerySurge or similar data comparison tools.
• Automation feasibility and tool installation.
• Python-based custom scripting.
• Test Data Management concepts.

Key Skills to Assess

• ETL Ecosystem
• DB2 & Data Storage Concepts
• SQL: SELECT, UPDATE, DELETE & Joins
• Query Optimization
• Data Migration & Validation
• Python
• ETL Testing & Defect Management