Description

- ETL testers collaborate with business analysts, data architects, and stakeholders to understand business rules, data requirements, and transformation logic. They review business requirements and data mapping documents to prepare detailed test plans and scenarios, ensuring comprehensive coverage of all data flows and transformations

- Test Planning and Case Development: They create structured test plans, define test environments, and develop test cases covering positive, negative, boundary, and edge scenarios. Test data is prepared to include all possible values for the data types involved

- ETL Test Execution: Testers execute test cases to validate the ETL process. This includes verifying data extraction from multiple sources, transformation according to business rules, and accurate loading into target systems. They perform backend testing using SQL queries,



compare source and target data, and validate transformations

- Data Quality and Integrity Checks: Ensuring data completeness, accuracy, and consistency is a key responsibility. ETL testers check for data duplication, truncation, and adherence to business rules. They also perform regular data quality inspections and validate that all expected data is present in the target system

- Automation and Tool Usage: ETL testers often use automation tools like QTP, Selenium, or Informatica, and scripting languages such as SQL, PL/SQL, Java, or UNIX shell scripting to streamline testing processes. They may also generate reports from tools like COGNOS and track defects using platforms like JIRA

📌 ETL Tester (Sydney)
🏢 CareCone Group
📍 Sydney