Description

Key Responsibilities

• Perform ETL and data warehouse testing.
• Validate source-to-target data mappings and transformations.
• Conduct business-rule validation and reconciliation testing.
• Execute data quality checks and identify data discrepancies.
• Perform root cause analysis using SQL queries.
• Validate reports against underlying data layers.
• Perform end-to-end validation across:
  • Source Systems
  • Bronze Layer
  • Silver Layer
  • Gold Layer
  • BI Reports
• Track defects and testing activities using Azure DevOps (ADO) or similar tools.
• Collaborate closely with IT, Data, Business Analysis, and project teams.
•  

Mandatory Skills

ETL & Data Testing

• 3 to 6+ years of experience in:
  • ETL Testing
  • Data Warehouse Testing
  • BI Testing
  • Data Validation

SQL

• Strong SQL querying skills.
• Data reconciliation.
• Root cause analysis of data issues.
• Data Architecture
• Experience with:
  • Bronze-Silver-Gold (Medallion) Architecture
  • Similar layered data architectures

Azure Technologies

Hands-on exposure to:

• Azure Databricks
• Azure Data Factory (ADF)
• Azure Data Lake

Reporting & BI Validation

• BI report testing.
• Data-to-report reconciliation.
• End-to-end report validation.

Test Management Tools

• Azure DevOps (ADO) or equivalent defect/test management tools.
•  

Preferred Domain Experience

Strong preference for professionals with Insurance/Reinsurance experience, particularly in:

• Policies
• Claims
• Premiums
• Treaties
• Commissions
• Reinsurance Reporting (RI Reporting)

Soft Skills

• Strong analytical abilities.
• Good communication and stakeholder management skills.
• Ability to work with cross-functional teams

Key Skills

Education

Any Gradute