Test Engineer - SQL ETL And Data Validation

IQVIA; Bengaluru; On-site; INR 600,000 - 900,000; Full time

Job summary

IQVIA in Bangalore, India is seeking a data QA engineer to maintain database objects, ETL processes, reports, and backend components, ensuring quality and reliability of data platforms. You will collaborate with business analysts, developers, DBAs, and stakeholders to design, test, and validate SQL scripts, ETL workflows, and data reconciliations, delivering scalable solutions and production support.

The role requires 2–4 years of data-centric testing experience, strong SQL skills, and

Qualifications

• Bachelor’s degree in Computer Science, IT, Engineering, or related field.
• 2–4 years of experience validating data-centric applications.
• Strong hands-on experience with Microsoft SQL Server and complex SQL query development.
• Experience developing and testing stored procedures, functions, views, triggers, and database jobs.
• Experience working with ETL processes and data integration solutions.
• Strong understanding of database design, data validation, and data quality concepts.
• Experience validating data transformations, mappings, and source-to-target reconciliations.
• Familiarity with reporting solutions and report validation techniques.
• Good understanding of SDLC, STLC, Agile methodologies, and defect management processes.
• Experience using Jira, SPIRA, or TestRail.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent verbal and written communication skills.
• Experience in Azure DevOps and Test automation will be an added advantage.

Responsibilities

• Caries out procedures to ensure information systems meet end-user requirements.
• Writes test plans and scripts; performs unit, functional, integration, system, regression, and other testing.
• Tests software to ensure proper operation and defect-free release.
• Documents and resolves problems; proposes quality improvements.
• Develops models of future configurations and improves procedures.
• Performs workflow analysis and quality improvement recommendations.
• Establishes software quality standards for lifecycle, documentation, development, testing and maintenance.
• Conducts advanced software tests and validates data workflows, ensuring data accuracy and integrity across systems.
• Analyze requirements; participate in design; enhance, maintain, and validate SQL scripts, procedures, and reports.
• Coordinate with stakeholders to review requirements and support deployments and post-release testing.
• Contribute to continuous improvement of testing processes and automation opportunities.

Skills

SQL Query Development

Database Testing

ETL Development

Data Validation

Data Quality Assurance

Testing (Functional, Integration & Reg

Defect Management

Agile/Scrum

Production Support

Release Validation

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field

Tools

Jira

SPIRA

TestRail

Azure DevOps

SSRS

Job description

Job Description:

Job Overview

The individual is responsible for maintaining database objects, ETL processes, reports, and backend components while ensuring the quality, accuracy, and reliability of applications and data platforms. The role includes participating in requirements analysis, solution design, coding, unit testing, database validation, ETL testing, defect resolution, and production support activities. The individual will work closely with business analysts, developers, DBAs, and stakeholders to deliver scalable and high-quality data solutions.

Essential Functions

• Carries out procedures to ensure that all information systems products and services meet minimum organization standards and end-user requirements.
• Writes test plans and detailed test scripts supporting test cases derived from an analysis of functional requirements and programming specifications, perform unit, functional, integration, system, regression, user acceptance, backend, database, and data validation testing to ensure quality and reliability of applications and data solutions.
• Thoroughly tests software to ensure proper operation and freedom from defects prior to implementation.
• Documents and works to resolve all problems.
• Devises improvements to current procedures and develops models of possible future configurations.
• Performs work flow analysis and recommends quality improvements.
• Establishes software quality standards for life cycle, documentation, development methods, testing and maintenance.
• Establishes advanced software test standards and methods and conducts complex software tests.
• Analyze business, functional, and technical requirements; participate in solution design; enhance, maintain, and validate SQL scripts, stored procedures, functions, views, triggers, reports, data extracts, and other database objects to support business and reporting requirements.
• Design, support, execute, and validate ETL processes, database solutions, and data workflows, ensuring accurate data movement, transformation logic, business rule compliance, data integrity, and operational stability across source and target systems.
• Conduct data reconciliation, source-to-target validation, data quality analysis, and report verification to ensure accuracy, completeness, consistency, and compliance with business requirements.
• Monitor, troubleshoot, test, and validate SQL jobs, batch processes, applications, databases, ETL workflows, and production releases; identify issues, implement fixes, and recommend performance and reliability improvements.
• Identify, document, track, and verify defects; participate in root cause analysis, defect triage, peer reviews, and resolution activities while ensuring adherence to development standards and quality expectations.
• Collaborate with developers, QAs, DBAs, business analysts, and stakeholders to review requirements and technical specifications, deliver scalable and high-quality solutions, communicate status and quality metrics, and support deployments, release validation, production verification, and post-release testing.
• Contribute to continuous improvement initiatives by enhancing practices, testing processes, test coverage, automation opportunities, and overall solution quality, while performing additional responsibilities assigned by management.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field (or equivalent experience).
• 2-4 years of experience in validating data-centric applications.
• Strong hands-on experience with Microsoft SQL Server and complex SQL query development.
• Experience developing and testing stored procedures, functions, views, triggers, and database jobs.
• Experience working with ETL processes and data integration solutions.
• Strong understanding of database design principles, data validation, and data quality concepts.
• Experience validating data transformations, mappings, and source-to-target reconciliations.
• Familiarity with reporting solutions and report validation techniques.
• Good understanding of SDLC, STLC, Agile methodologies, and defect management processes.
• Experience using tools such as Jira, SPIRA, or TestRail.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent verbal and written communication skills.
• Experience in Azure DevOps and Test automation will be an added advantage.

Preferred

• Experience with report development and support using SSRS, ETL or similar reporting platforms.
• Basic understanding of automation testing frameworks and scripting.
• Experience in data warehousing, healthcare, or enterprise reporting environments.
• Familiarity with release management, and DevOps practices.
• Knowledge of performance testing and database optimization techniques.

Key Skills

• SQL Query Development, Validation and Database Testing
• ETL Development & Testing
• Data Warehouse Concepts
• Report Development & Validation (SSRS)
• Data Reconciliation & Data Quality Assurance
• Functional, Integration & Regression Testing
• Defect Management & Root Cause Analysis
• SQL Job Scheduling & Monitoring
• Agile/Scrum Methodology
• Jira / Azure DevOps
• SDLC & STLC
• Production Support & Release Validation

Experience Range

2–4 Years

Location

Bangalore, India

IQVIA is a leading global provider of clinical research services, commercial insights and healthcare intelligence to the life sciences and healthcare industries. We create intelligent connections to accelerate the development and commercialization of innovative medical treatments to help improve patient outcomes and population health worldwide. Learn more at https://jobs.iqvia.com

IQVIA is committed to integrity in our hiring process and maintains a zero tolerance policy for candidate fraud. All information and credentials submitted in your application must be truthful and complete. Any false statements, misrepresentations, or material omissions during the recruitment process will result in immediate disqualification of your application, or termination of employment if discovered later, in accordance with applicable law. We appreciate your honesty and professionalism.