ETL Test Engineer - SQL / Data Warehousing

ETL Test Engineer (Freelance / Remote)

Experience : 5+ Years

Location : Remote

Employment Type : Freelance / Overview :

We are seeking a highly skilled ETL Test Engineer with 5+ years of experience in Data Warehousing and BI Testing. The ideal candidate will have a strong background in validating data pipelines and transformation logic across Microsoft Fabric Lakehouse, with proven experience in manual and automated ETL testing using SQL and modern BI Responsibilities :

• Design, develop, and execute comprehensive test cases for ETL processes.
• Perform data validation across all layers of the ETL pipeline, from source to target systems.
• Collaborate with data engineers and BI developers to understand and validate ETL mappings and business logic.
• Troubleshoot and validate data flows from various sources (e.g., SQL databases) to destinations including Power BI.
• Analyze and document test plans, test cases, test summary reports, and defect logs.
• Identify and communicate data quality issues, work closely with development teams to ensure resolution.
• Leverage experience in dimensional modeling and data warehousing concepts for test design and validation.
• Use defect tracking tools such as Jira, HP-ALM, or Rally to report, track, and verify fixes.
• Participate in regression, integration, and production checkout testing activities.
• Align with SDLC and STLC methodologies in an Agile development Skills & Experience :
• 35+ years of experience in ETL / BI Testing.
• Strong hands-on skills in SQL for data validation and analysis.
• Experience working with Microsoft Fabric Lakehouse (Azure environment preferred).
• Exposure to data integration testing between systems and BI tools like Power BI.
• Solid understanding of ETL Source to Target Mapping Documents.
• Familiarity with analytics tools for data validation and reporting.
• Proven experience in defect management tools : Jira, Rally, or HP ALM.
• Excellent knowledge of data warehousing, dimensional modeling, and data quality best practices.
• Strong written and verbal communication skills.
• Domain knowledge in Sales and Profitability reporting is preferred.

ref : hirist.tech)