06 Aug
|
Exponentia.AI Private
|
Mumbai
06 Aug
Exponentia.AI Private
Mumbai
About the Role:
We are looking for a Quality Analyst with 4–5 years of experience in Data Warehouse and ETL Testing, with hands-on expertise in Microsoft Fabric. The ideal candidate should have experience in validating enterprise data pipelines, testing data transformations, performing source-to-target validation, and ensuring data quality across modern cloud-based analytics platforms. The candidate should be comfortable working in Agile environments and collaborating with cross-functional teams to deliver high-quality data solutions.
Key Responsibilities
Microsoft Fabric & Data Platform Testing
- Validate data pipelines developed using Microsoft Fabric, including Data Factory, Lakehouse, Data Warehouse, OneLake, and Notebooks.
- Perform end-to-end testing of cloud-based data integration and analytics solutions.
- Validate data transformations implemented through PySpark notebooks.
ETL & Data Validation
- Perform ETL/ELT testing and end-to-end data validation.
- Conduct source-to-target validation and data reconciliation using SQL.
- Validate business rules, transformation logic, and data completeness.
- Test batch and incremental data loading processes.
Data Warehouse & Data Quality Testing
- Validate Medallion Architecture (Bronze, Silver, and Gold layers).
- Perform schema validation, CDC (Change Data Capture), and incremental load testing.
- Validate Star Schema, Slowly Changing Dimensions (SCD), and dimensional data models.
- Ensure data accuracy, consistency, and integrity across enterprise datasets.
Power BI Testing
- Validate Power BI datasets, semantic models, reports, and DAX calculations.
- Verify report accuracy and ensure business requirements are met.
Test Planning & Agile Delivery
- Prepare Test Plans, Test Scenarios, Test Cases, and Test Execution Reports.
- Track and manage defects using JIRA.
- Participate in Agile/Scrum ceremonies, including sprint planning, daily stand-ups, and retrospectives.
- Collaborate with Data Engineers, Business Analysts, and stakeholders to ensure quality deliverables.
Roles and Responsibilities
Ideal Candidate Profile
- 4–5 years of experience in ETL, Data Warehouse, or BI Testing.
- Strong hands-on experience with Microsoft Fabric.
Expertise in:
- Microsoft Fabric (Data Factory, Lakehouse, Data Warehouse, OneLake, Notebooks)
- ETL/ELT Testing & End-to-End Data Validation
- SQL (Source-to-Target Validation & Data Reconciliation)
- Medallion Architecture Testing (Bronze, Silver, Gold)
- PySpark Validation for Notebook-Based Transformations
- Power BI Testing (Datasets, Semantic Models, Reports & DAX)
- Data Quality Testing (Schema Validation, CDC & Incremental Load Testing)
- Data Warehousing Concepts (Star Schema, SCD, Dimensional Modeling)
- Test Plan & Test Case Preparation
- Agile/Scrum and JIRA
Preferred Qualifications
- Bachelor’s degree in computer science, Information Technology, Engineering, or a related field.
- ISTQB Certification is an added advantage.
- Exposure to Microsoft Azure Data Services is preferred.
- Solid analytical, problem-solving, and communication skills.
Why Join Exponentia.ai?
- Innovate with Purpose: Opportunity to create pioneering AI solutions in partnership with leading cloud and data platforms
- Shape the Practice: Build a marquee capability from the ground up with full ownership
- Work with the Best: Collaborate with top-tier talent and learn from industry leaders in AI
- Global Exposure: Be part of a high-growth firm operating across US, UK, UAE, India, and Singapore
- Continuous Growth: Access to certifications, tech events, and partner-led innovation labs
- Inclusive Culture: A supportive and diverse workplace that values learning, initiative, and ownership
📌 Quality Assurance Engineer - Data & AI (Mumbai)
🏢 Exponentia.AI Private
📍 Mumbai