ETL Oracle PLSQL Testing

Job Description:

We are looking for ETL / Data Validation QA professionals to validate Informatica-to-Oracle PL/SQL migrations and ensure data accuracy in SAP Commissions(Target system). The role involves complex SQL-based data reconciliation, ETL testing, migration validation, and test management using Spira.

Key Responsibilities

Write complex SQL queries to perform Informatica vs PL/SQL data validation.

Perform detailed data reconciliation by comparing outputs from legacy Informatica processes with the new PL/SQL / SAP HANA implementations.

Validate data loaded into SAP Commissions, ensuring data pipelines trigger correctly and final outputs match expected results in the Commissions UI.

Design, document, and manage comprehensive test cases within Spira.

Execute manual and automated SQL-based test scripts, capturing detailed evidence and logs directly in Spira.

Identify, log, and track data discrepancies using Spira, ensuring clear communication with the development team.

Key skills:

Mandatory: SQL, ETL Testing, Data Reconciliation, Data Migration Testing, Spira

Good to Have: SAP HANA, Informatica, SAP Commission knowledge