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)