QA Analyst (ETL & MDM Tester)

As a skilled ETL & MDM Tester, you will be responsible for the end-to-end testing of data integration and Reltio MDM implementations. Your role will involve ensuring data accuracy, consistency, and quality across complex ETL pipelines and MDM platforms. - Perform end-to-end testing of ETL and MDM solutions, covering source systems to downstream applications. - Design and execute test scenarios, test cases, and test data for ETL, MDM, and data validation. - Validate data ingestion, transformation, matching, merging, survivorship, and publishing in Reltio MDM. - Test batch and incremental ETL loads to ensure data completeness and integrity. - Conduct data quality checks including duplicates, hierarchy validation, reference data validation, and business rule verification. - Validate MDM object models, relationships, crosswalks, and survivorship rules. - Execute API testing for Reltio inbound/outbound integrations. - Perform SQL-based data validation across source, staging, and target systems. - Identify, log, track, and retest defects using defect management tools. - Collaborate with business analysts, data engineers, developers, and product owners to clarify requirements and resolve issues. - Support UAT and regression testing cycles. - Ensure testing aligns with data governance, security, and compliance standards. Qualifications Required: - 4-6 years of experience in ETL Testing and Data Warehouse testing. - Strong hands-on experience with Reltio MDM testing. - Solid understanding of MDM concepts: golden record, matching & merging, survivorship, hierarchies, and reference data. - Proficiency in SQL for complex data validation. - Experience testing ETL tools such as Informatica, Talend, DataStage, SSIS, or similar. - Experience validating REST APIs using tools like Postman, REST Assured, or similar. - Strong understanding of data mapping and transformation logic. - Experience in Agile/Scrum environments. - Excellent analytical and communication skills. (Note: No additional details of the company were mentioned in the provided job description) As a skilled ETL & MDM Tester, you will be responsible for the end-to-end testing of data integration and Reltio MDM implementations. Your role will involve ensuring data accuracy, consistency, and quality across complex ETL pipelines and MDM platforms. - Perform end-to-end testing of ETL and MDM solutions, covering source systems to downstream applications. - Design and execute test scenarios, test cases, and test data for ETL, MDM, and data validation. - Validate data ingestion, transformation, matching, merging, survivorship, and publishing in Reltio MDM. - Test batch and incremental ETL loads to ensure data completeness and integrity. - Conduct data quality checks including duplicates, hierarchy validation, reference data validation, and business rule verification. - Validate MDM object models, relationships, crosswalks, and survivorship rules. - Execute API testing for Reltio inbound/outbound integrations. - Perform SQL-based data validation across source, staging, and target systems. - Identify, log, track, and retest defects using defect management tools. - Collaborate with business analysts, data engineers, developers, and product owners to clarify requirements and resolve issues. - Support UAT and regression testing cycles. - Ensure testing aligns with data governance, security, and compliance standards. Qualifications Required: - 4-6 years of experience in ETL Testing and Data Warehouse testing. - Strong hands-on experience with Reltio MDM testing. - Solid understanding of MDM concepts: golden record, matching & merging, survivorship, hierarchies, and reference data. - Proficiency in SQL for complex data validation. - Experience testing ETL tools such as Informatica, Talend, DataStage, SSIS, or similar. - Experience validating REST APIs using tools like Postman, REST Assured, or similar. - Strong understanding of data mapping and transformation logic. - Experience in Agile/Scrum environments. - Excellent analytical and communication skills. (Note: No additional details of the company were mentioned in the provided job description)