Senior Test Engineer

Job Summary:-

We are looking for a Data Validation/Test Engineer with hands-on experience in Datagaps/Similar tool ETL Validator to perform data reconciliation, ETL testing, source-to-target validation, and data quality testing. The candidate should have strong SQL skills and experience validating large volumes of data across databases, files, and data warehouse environments.

Key Responsibilities-

Perform source-to-target data validation using DataGaps ETL Validator.

Validate ETL mappings, transformation rules, and business logic.

Execute table-to-table, file-to-file, and query-to-table comparisons.

Perform data migration and data reconciliation testing.

Validate data completeness, accuracy, consistency, and integrity.

Analyze data discrepancies and work with development teams for resolution.

Develop and execute test cases based on business requirements and mapping documents.

Prepare test execution reports, defect logs, and validation summaries.

Support SIT, UAT, and production validation activities.

Collaborate with business, ETL, and data engineering teams.

Required Skills-

Hands-on experience with DataGaps ETL Validator or similar tool.

Strong SQL querying and data analysis skills.

Experience in ETL Testing and Data Warehouse Testing.

Experience in source-to-target data validation and reconciliation.

Good understanding of databases such as Oracle, SQL Server, PostgreSQL, Teradata, or similar.

Experience validating flat files, CSVs, XML, or JSON data.

Strong analytical and problem-solving skills.

Ability to analyze data issues and identify root causes.

Preferred Skills-

Experience with Informatica, Databricks, Snowflake, Azure, or AWS data platforms.

Knowledge of Banking/Financial Services domain.

Experience in data migration projects and regulatory reporting validations.

Familiarity with Agile testing methodologies.