Data Warehouse / ETL Test Engineer

Key Responsibilities Execute data and analytics testing in accordance with established SDLC and testing processes. Collaborate with Project Managers, Platform Owners, Data Engineers, Solution Architects, Business SMEs, and Product Owners to define test coverage and acceptance criteria. Participate in test design, preparation, walkthroughs, and testing kick-off meetings. Develop detailed test scenarios covering different integration points between systems, modules, and data components. Prepare and maintain overall project test approaches and SIT Test Plans . Prepare User Acceptance Test (UAT) Plans based on project requirements. Validate complex source-to-target data transformations, aggregations, mappings, and business rules . Perform data validation and reconciliation using advanced SQL queries. Test ETL/ELT pipelines across modern cloud data platforms. Execute large-volume data testing and validate pipeline performance, scalability, and data integrity. Perform testing on Databricks environments and data solutions. Document test cases, test results, defects, testing metrics, and test reports. Manage and document changes, versions, releases, and defect management activities. Provide accurate estimates, progress updates, and status reports for testing activities and automation scripts. Work with the Test Automation Toolkit and support proper implementation of applicable test automation processes. Identify issues, perform analysis, and collaborate with technical teams to resolve data and testing-related defects. Contribute ideas and improvements to testing processes, tools, and methodologies. Qualifications Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field. Strong experience in Data Warehouse, Data Lake, ETL/ELT, and Analytics Testing . Experience validating complex source-to-target data transformations, aggregations, and business rules . Strong SQL skills, including complex validation and data reconciliation queries. Experience testing ETL/ELT pipelines using modern cloud data platforms. At least 1 year of hands-on experience testing Databricks . Experience performing performance, scalability, and large-volume data testing. Good understanding of SDLC and software testing methodologies . Experience with test planning, test case preparation, execution, defect management, and test reporting. Strong problem-solving and analytical skills. Good communication and presentation skills. Able to work independently and effectively with cross-functional teams. Willingness to innovate and implement process improvements. Experience working on data-related projects. Technical Skills Data Warehouse Testing Data Lake Testing ETL / ELT Testing Advanced SQL Data Validation & Reconciliation Source-to-Target Validation Databricks Cloud Data Platforms Data Transformation & Aggregation Testing Large-Volume Data Testing SIT / UAT Test Planning & Test Execution Defect Management Test Reporting & Metrics SDLC / Testing Methodologies Test Automation – Advantage