Job Description:
Design and execute ETL test cases and test scenarios for data extraction, transformation, and loading processes.
Perform end-to-end testing of ETL workflows developed using Informatica.
Validate source-to-target data mappings, transformations, data completeness, and data accuracy.
Write and execute PL/SQL queries for data validation, reconciliation, and backend testing.
Validate complex data transformations, joins, aggregations, lookups, and business rules implemented in ETL processes.
Perform data reconciliation between source and target systems and identify data discrepancies.
Test Informatica mappings, workflows, sessions, and associated ETL processes.
Perform database testing and validate data integrity across different source and target systems.




Work with data virtualization tools such as Denodo to validate virtualized data views and data integration.
Identify, analyze, and report data quality issues and defects, and work with development teams for resolution.
Perform regression, integration, functional, and system testing for ETL/data warehouse solutions.
Participate in defect tracking, root cause analysis, and test result reporting.
Collaborate with ETL developers, data engineers, database teams, business analysts, and other stakeholders throughout the SDLC.
Ensure test coverage and adherence to data quality, testing, and documentation standards.

📌 Etl Tester Delhi (India)
🏢 Acme Services Private
📍 India