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.