- REQUIREMENT TEMPLATE – Data-ETL Testing

No. of positions
16

Account Name
Allianz

Service Line
IQE

Must have skills - 2 skills which are non-negotiable
- Robust SQL and Database Testing expertise with the ability to perform complex data validation and reconciliation.
- Strong ETL Testing experience, including Source-to-Target Mapping validation, transformation testing, data integrity checks, and Data Warehouse concepts.

Desirable skills - 1 skill which is nice to have
Exposure to Big Data technologies such as Databricks, Hadoop, or Spark.

Infosys role
JL4 - 4

JL5 - 9

JL6 - 3

Desired experience range
5-18 Years

Location(s) where this position can work out of
Trivandrum, Pune, Bangalore, Chennai

Does this position require working from client office all or some days in the week? If yes pls provide details
No

Is remote working allowed

Any additional things to be checked

Responsibilities and JD in brief along with additional criteria to be considered (if any):

Role Summary

The Data Tester is responsible for validating data accuracy, completeness,



consistency, and integrity across source systems, ETL processes, databases, reports, and downstream applications. The role involves ensuring that business and technical data requirements are correctly implemented and that data transformations comply with business rules.

Key Responsibilities
- Participate in all phases of the testing lifecycle, including requirement analysis, test planning, test execution, defect management, and reporting.
- Validate data movement across source, staging, and target systems.
- Perform Source-to-Target Mapping (STTM) validation and ensure transformations are implemented correctly.
- Develop and execute SQL queries for data verification, reconciliation, and integrity checks.
- Validate ETL processes, data migration activities, and reporting outputs.
- Perform data quality checks including completeness, accuracy, consistency, uniqueness, and validity.
- Verify data lineage and ensur

📌 ETL Testing (India)
🏢 Clifyx
📍 India