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