Informatica Tester

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).

Skills

ETL, Informatica, Oracle, PL/SQL, PostgreSQL, QA, tester, testing