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

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

Experience in cloud-based data platforms and analytics environments

Test automation experience for data and reporting applications

Experience within clinical research, healthcare, life sciences, or regulated environments

Knowledge of FDA GxP regulations and 21 CFR Part 11

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.