About the role
The candidate will have responsibilities across the following functions:
ETL Testing and Validation:
- Perform end-to-end testing of Informatica workflows, mappings, and transformations.
- Validate data extraction, transformation, and loading processes against business requirements.
Database Testing:
- Write and execute PL/SQL queries to verify data integrity and consistency.
- Perform regression, functional, and performance testing on Oracle and PostgreSQL databases.
Scripting and Automation:
- Develop and maintain test scripts to automate repetitive tasks.
- Ensure efficient execution of test cases and reporting.
Collaboration and Documentation:
- Work closely with developers, data engineers, and business teams to understand requirements.
- Document test cases, test results, and defect reports.
- Participate in defect triage and provide root cause analysis.
Quality Assurance:
- Ensure compliance with testing standards and best practices.
- Identify gaps in data processes and recommend improvements.
Requirements:
- 5+ years in ETL/Data Warehouse testing, with a focus on Informatica.
- Strong knowledge of Informatica PowerCenter or similar ETL tools.
- Proficiency in PL/SQL for data validation and query writing.
- Experience with Oracle and PostgreSQL databases.
- Hands-on scripting experience (Shell, Python, or similar).