Senior Data Quality & Validation Engineer (Power BI, SQL, Informatica, Data Warehouse Testing)

Clario; Bengaluru; Hybrid; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Provident Fund

Medical Insurance

Remote/hybrid work tech

Onsite facilities in Bangalore

Job summary

Clario, part of Thermo Fisher Scientific, seeks a Senior Data Quality & Validation Engineer to ensure accuracy and reliability of clinical data platforms. You will lead validation for data warehouse, ETL, reporting, and analytics, writing complex SQL and validating Power BI dashboards.

Join a team partnering with Data Eng, BI, and Product to support clinical research. Experience with Informatica PowerCenter and Snowflake is valuable; hybrid remote work and onsite facilities in Bangalore are

Qualifications

• Bachelor’s degree in CS/IT or related field.
• 7–10 years in Software QA, Data Testing, or DW Testing.
• Advanced SQL skills, complex joins and performance tuning.
• Experience with DW, ETL, Data Lake, and BI solutions.
• Experience validating Power BI dashboards and datasets.
• Strong understanding of data quality and governance.

Responsibilities

• Lead testing and validation for data warehouse, ETL, reporting, and analytics.
• Design and execute test strategies for data integration and reporting.
• Write and optimize complex SQL queries to verify transformations.
• Validate data movement across source systems, ETL pipelines, DW, and reports.
• End-to-end testing of Power BI dashboards; ensure accuracy and rules compliance.
• Test data pipelines built with Informatica and related ETL tech.
• Execute DW testing across cloud and on‑prem environments (Snowflake, etc.).
• Develop test plans, validation protocols, and SDLC/compliance docs.
• Perform RCA, risk assessments, CAPA for data quality issues.
• Collaborate with Data Eng, BI, Product, and Dev teams to ensure quality.
• Validate complex business logic, transformations, aggregations, and calculations.
• Support automation using Python and SQL; mentor juniors.

Skills

SQL

Data warehouse testing

ETL validation

Power BI

Informatica PowerCenter

Data governance

Python (preferred)

Regulatory compliance

Jira/Azure DevOps

Cloud data platforms

Education

Bachelor's degree in Computer Science, IT, or related

Tools

Informatica PowerCenter

Power BI

Snowflake

Jira

Azure DevOps

Confluence

Python

Job description

At Clario, part of Thermo Fisher Scientific, we're seeking a Senior Data Quality & Validation Engineer to ensure the accuracy, integrity, and reliability of critical clinical data platforms. This role is ideal for a data-focused quality professional with expertise in complex SQL, data warehouse testing, ETL validation, Power BI reporting, and Informatica-based data pipelines. You'll work closely with data engineering, business intelligence, and product teams to validate large-scale data solutions that support clinical research and help bring life-changing therapies to patients faster.

What We Offer

• Competitive compensation, incentives, and shift allowances
• Attractive benefits (Provident Fund, Medical Insurance & more)
• Engaging employee programs & local events
• Technology for remote/hybrid working and excellent onsite facilities in Bangalore

What You'll Be Doing

• Lead testing and validation activities for data warehouse, ETL, reporting, and analytics solutions
• Design and execute comprehensive test strategies for data integration and reporting platforms
• Write and optimize complex SQL queries to validate data transformations, reconcile datasets, and investigate quality issues
• Validate data movement across source systems, ETL pipelines, data warehouses, and reporting layers
• Perform end-to-end testing of Power BI dashboards and reports, ensuring data accuracy, completeness, and business rule compliance
• Test and validate data pipelines built using Informatica PowerCenter and related ETL technologies
• Execute data warehouse testing across cloud and on-premise environments, including Snowflake and large-scale analytics platforms
• Develop test plans, test cases, validation protocols, and supporting documentation in accordance with SDLC and regulatory requirements
• Perform root cause analysis (RCA), risk assessments, and corrective actions (CAPA) to address data quality issues
• Partner with Data Engineering, BI, Product, and Development teams to ensure high-quality data delivery
• Validate complex business logic, data transformations, aggregations, and calculations used in reporting environments
• Support automation initiatives using Python, SQL, and modern testing methodologies
• Mentor junior team members and contribute to continuous improvement of validation standards and processes

What We Look For

• Required Bachelor's degree in Computer Science, Information Technology, Data Engineering, or related discipline
• 7-10 years of experience in Software Quality Assurance, Data Testing, or Data Warehouse Testing
• Advanced expertise in SQL, including complex joins, stored procedures, performance tuning, and data validation techniques
• Proven experience testing Data Warehouse, ETL, Data Lake, and Business Intelligence solutions
• Hands-on experience validating Power BI dashboards, reports, and underlying datasets
• Strong experience with Informatica PowerCenter or comparable ETL platforms
• Experience validating data within Snowflake or other enterprise data warehouse environments
• Strong understanding of data quality, data governance, and data reconciliation methodologies
• Experience with Agile delivery methodologies including Scrum and Kanban
• Experience using Jira, Azure DevOps, and Confluence
• Ability to analyse data discrepancies and independently drive issue resolution
• Excellent written and verbal communication skills
• Preferred Experience with Python is a plus
• Preferred Experience in cloud-based data platforms and analytics environments
• Preferred Test automation experience for data and reporting applications
• Preferred Experience within clinical research, healthcare, life sciences, or regulated environments
• Preferred Knowledge of FDA GxP regulations and 21 CFR Part 11
• Preferred Experience with Big Data technologies and modern analytics architectures

At Clario, our purpose is to transform lives by unlocking better evidence. It’s a cause that unites and inspires us. It’s why we come to work—and how we empower our people to make a positive impact every day. Whether you're advancing clinical science, building innovative technology, or supporting our global teams, your work helps bring life-changing therapies to patients faster.

Clario Privacy Policy

Clario is a leading provider of endpoint data solutions to the clinical trials industry, generating high-quality clinical evidence for life sciences companies. We offer comprehensive evidence generation solutions that combine medical imaging, eCOA, precision motion, cardiac solutions and respiratory endpoints. For more than 50 years, Clario has delivered deep scientific expertise and broad endpoint technologies to help transform lives around the world. Our endpoint data solutions have supported over 30,000 clinical trials in more than 100 countries. Our global team of science, technology, and operational experts have supported over 70% of all FDA drug approvals since 2015.