Senior Data Tester

Senior Data TesterLocation: Anywhere in the U.S. within EST/CST time zonesWork Arrangement: onsite requirements at the nearest Publicis Sapient officeEmployment Type: Long Term ContractJob Summary:We are looking for a Senior Data Tester to validate data quality, accuracy, completeness, and integrity across data pipelines, data platforms, data warehouses, and reporting solutions.The ideal candidate will have strong SQL and data testing experience, with a solid understanding of ETL testing, data validation, reconciliation, data migration, and data quality testing. This role will work closely with business stakeholders, developers, data engineers, and QA teams to ensure data meets defined business and technical requirements.Key Responsibilities:Review business requirements, data mappings, technical specifications, and design documents to understand testing scope and expected data outcomes.Design and execute test cases for ETL, data migration, data warehouse, reporting, and cloud data platform testing.Perform comprehensive data validation, including:Source-to-target validationRecord count validationData reconciliationTransformation validationData completeness and accuracy checksData quality validationWrite and execute complex SQL queries to validate data across multiple tables and data sources.Validate ETL pipelines and data transformations across source, staging, and target environments.Support test data preparation for SIT, regression, UAT, and data migration testing.Identify, document, prioritize, and track defects through resolution.Collaborate with developers and data engineering teams to investigate data discrepancies and perform root-cause analysis.Use basic automation or scripting to improve data validation and reduce repetitive manual testing.Support UAT activities and provide clear testing status, risks, issues, and results to stakeholders.Participate in defect triage, release readiness, and production validation activities.Ensure testing activities are aligned with project requirements, acceptance criteria, and quality standards.Required Qualifications:Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.3+ years of hands-on experience in data testing, ETL testing, data migration testing, or data warehouse testing.Strong SQL skills with experience writing queries for data validation and reconciliation.Strong understanding of:Data validationData reconciliationData quality testingSource-to-target validationETL testingData transformation testingExperience working with data warehouses, cloud data platforms, or big data environments.Experience with test management and defect tracking tools such as Jira, Azure DevOps, or similar tools.Experience working across SIT, regression, UAT, and data migration testing.Strong analytical and problem-solving skills.Excellent communication skills with the ability to clearly explain testing results, defects, risks, and data issues to technical and business stakeholders.