Job Description

Develop, execute, and maintain test cases, test scripts, and test data for MDM and ETL processes.

n

Validate Informatica ETL processes to ensure accuracy, performance, and compliance with business rules.

n

Perform end-to-end testing of MDM workflows including data ingestion, cleansing, consolidation, survivorship, and publishing.

n

Collaborate with developers, data architects, and business analysts to identify defects and drive issue resolution.

n

Conduct functional, regression, integration, and performance testing for ETL/MDM solutions.

n

Verify data quality, lineage, reconciliation, and metadata consistency across multiple systems.

n

Create and maintain detailed test documentation including test strategy, test plans, and defect logs.

n

Participate in agile/scrum ceremonies and contribute to continuous improvement in testing practices.

n

Key Responsibilities

n

n
- Develop, execute, and maintain test cases, test scripts, and test data for MDM and ETL processes.
n
- Validate Informatica ETL processes to ensure accuracy, performance, and compliance with business rules.
n
- Perform end-to-end testing of MDM workflows including data ingestion, cleansing, consolidation, survivorship, and publishing.
n
- Collaborate with developers, data architects, and business analysts to identify defects and drive issue resolution.
n
- Conduct functional, regression, integration,



and performance testing for ETL/MDM solutions.
n
- Verify data quality, lineage, reconciliation, and metadata consistency across multiple systems.
n
- Create and maintain detailed test documentation including test strategy, test plans, and defect logs.
n
- Participate in agile/scrum ceremonies and contribute to continuous improvement in testing practices.
n

n

Required Skills & Qualifications

n

n
- 3–6 years of experience in ETL testing, with at least 2+ years on Informatica PowerCenter / Informatica MDM.
n
- Robust SQL skills for data validation and test automation.
n
- Hands-on experience with data quality, data profiling, and data reconciliation.
n
- Knowledge of MDM concepts (data governance, golden record, survivorship rules, hierarchies).
n
- Experience with defect management tools (e.g., JIRA, HP ALM, Azure DevOps).
n
- Familiarity with Agile methodologies and CI/CD testing practices.
n
- Excellent problem-solving skills, attention to detail, and ability to work collaboratively.
n

n

Preferred Qualifications

n

n
- Exposure to Informatica Data Quality (IDQ), Informatica Cloud / IICS, or related data integration platforms.
n
- Knowledge of data warehousing concepts and BI reporting tools.
n
- Experience in automation testing frameworks for ETL.
n

#J-18808-Ljbffr

📌 ETL Tester / MDM (New South Wales)
🏢 PibyThree
📍 New South Wales