Etl Test Engineer

Job Title: ETL Test Engineer

Location: CBD Belapur, Navi Mumbai (Onsite)

Experience: 3+ Years

Key Responsibilities

• Perform ETL testing, data validation, and data migration testing.
• Develop and execute test cases, test plans, and test scenarios.
• Validate DB2 vs Cloudera data and ensure data quality.
• Create and execute SQL queries/scripts for testing and validation.
• Manage defects, retesting, and issue resolution.
• Collaborate with developers, data engineers, and business teams.

Mandatory Skills

• 3+ years of Testing experience with strong ETL Testing exposure.
• Hands-on experience with DB2, Cloudera, and PySpark.
• Strong SQL knowledge: SELECT, UPDATE, DELETE, Joins, Query Optimization.
• Knowledge of Python and related libraries.
• Understanding of Data Modeling, Relational Databases, ETL Processes, and Data Migration.
• Ability to identify and optimize slow-running queries.
• Willingness to work from CBD Belapur, Navi Mumbai.

Preferred Skills

• ISTQB Foundation Certification.
• Experience with QuerySurge or similar data comparison tools.
• Data Quality Validation and Test Data Management.
• Automation feasibility assessment and Python scripting.
• Good documentation skills.