Etl Test Engineer

Role & responsibilities

• Test Strategy & Planning
  Create comprehensive test plans for each upcoming release.Design test strategy documents outlining the scope and timelines.Draft target test scenarios based on business requirement documents.Map business rules to specific source-to target data validations.Establish the testing harness and select required automation tools.Data Architecture & SQL DevelopmentReview data models to understand relational database structures.Write complex SQL scripts to validate source to-target mapping.Build database views to simplify complex data verification tasks.Develop custom stored procedures and functions for automated checks.Review database triggers to ensure integrity constraints remain intact.Optimize slow-running test queries to speed up execution windows.ETL Validation & Platform MigrationValidate source data quality before extraction processes begin.Verify data transformation logic against specified business rules.Confirm successful data loading into the target tables.Execute DB2 versus Cloudera data platform comparison reports.Audit comparison reports for data completeness and consistency.Test Execution & Defect Management.Execute manual and automated test scripts within strict timelines.Log identified data discrepancies in the bug tracking system.Troubleshoot complex query errors and performance bottlenecks.Retest resolved defects to confirm successful code fixes.

Preferred candidate profile

5 days WFO and alternate Saturday working

Immediate joiner

Candidate should have hand on experience in Python, PySpark & Databricks and QuerySurge.