ETL Test Engineer

As a Data Warehouse (DWH) / ETL Test Engineer with 3 to 6 years of experience, your role will involve ensuring the accuracy, completeness, and integrity of data flowing through Extract, Transform, Load (ETL) pipelines and residing in the enterprise Data Warehouse. Your expertise in complex SQL queries, dimensional modeling, and commitment to data quality assurance will be crucial for this position. Key Responsibilities: - Design, develop, and execute detailed test plans and test cases for ETL processes, data migrations, and DWH reports/dashboards. - Perform comprehensive data validation and reconciliation between source systems, staging areas, and the target data warehouse/data marts. - Write and execute complex SQL queries to validate data transformations and business rules. - Verify data modeling, fact and dimension table loading, historical data maintenance, and slowly changing dimensions (SCDs). - Test data flow across various ETL tools and technologies. - Execute tests to validate ETL job execution performance and ensure data loads meet defined service level agreements (SLAs). - Identify, log, track, and retest defects using defect management tools and communicate status updates clearly to stakeholders. - Work closely with ETL Developers, Data Architects, Business Analysts, and BI teams to understand requirements and resolve data quality issues. Required Qualifications (3-6 Years): - 3-6 years of professional experience dedicated to Data Warehouse (DWH) and ETL testing. - Expert-level proficiency in writing and troubleshooting complex SQL queries. - Strong conceptual knowledge of Data Warehousing principles, including dimensional modeling, schemas, OLAP/OLTP concepts, and data mart design. - Proven experience in the full software testing lifecycle specific to data projects. - Hands-on experience with at least one major ETL tool or cloud-native ETL services. - Excellent written and verbal communication skills to explain technical issues to both technical and non-technical audiences.,