ETL Tester

Medpace, Inc.; Navi Mumbai; On-site; INR 600,000 - 900,000; Full time

Benefits offered by this job

On-site mentors

Career paths

Onboarding & training

Continuous learning

WFH flexibility

Social events

Health & retirement

Job summary

Medpace is seeking a full-time, office-based Software QA Test Engineer (Validation Engineer) to join the IT team in Mumbai. The role focuses on ETL testing, data validation, and validating data warehouse objects, with responsibilities spanning test planning, execution, and defect tracking.

The ideal candidate has 1-2 years of experience in ETL or data migration testing and a strong foundation in SQL queries and database validation.

Qualifications

• 1-2 years of ETL, data warehouse or data migration testing
• Strong understanding of software testing fundamentals and lifecycle
• Experience in design and executing SQL queries for database validation
• Experience communicating with cross-departmental teams

Responsibilities

• Design, develop, and execute test plans for ETL pipelines and data warehouse objects
• Perform end-to-end ETL testing validating source-to-target data
• Develop and execute SQL queries for data validation and reconciliation
• Validate database objects and data warehouse models against requirements
• Identify and track defects with a bug-tracking system
• Collaborate with Data Engineers, BI Developers, and Analysts to define acceptance criteria

Skills

ETL testing

SQL queries

Data validation

Testing lifecycle

Cross-team communication

Education

Bachelor's degree in CS or related

Tools

Casandra

MSSQL

MongoDB

Studio 3T

Job description

Job Summary

Medpace is growing rapidly, and we are currently seeking a full-time, office-based Software QA Test Engineer (Validation Engineer) to join our growing Information Technology (IT) team in Mumbai office.

Responsibilities

• Design, develop, and execute comprehensive test plans, test scenarios, and test cases for ETL pipelines, backend database changes, data warehouse objects, and reporting solutions.
• Perform end-to-end ETL testing by validating source-to-target data across different stages of the data pipeline to ensure data completeness, accuracy, consistency, and integrity.
• Develop and execute complex SQL and Snowflake queries to perform data validation, reconciliation, data profiling, and root-cause analysis of data discrepancies.
• Validate database changes, including schemas, tables, views, stored procedures, indexes, and other database objects, for functional correctness and potential performance impact.
• Validate data warehouse dimensional models, including fact tables, dimension tables, and Slowly Changing Dimensions (SCD), against business and technical requirements.
• Perform functional, integration, regression, and data integrity testing following ETL code changes, source-system updates, database changes, or schema modifications.
• Identify, document, prioritize, and track defects using a bug-tracking system, working closely with developers and data engineers to investigate issues, validate fixes, and perform retesting.
• Collaborate with Data Engineers, BI Developers, Business Analysts, and other stakeholders to define acceptance criteria, testing requirements, and quality standards for new data pipelines, data models, and reports.
• Develop and maintain reusable SQL queries, test scripts, test data sets, reconciliation checks, and automated data validation frameworks to improve testing efficiency, coverage, and repeatability.

Qualifications

• Minimum bachelor’s degree, preferably in computer science background or related background
• 1-2 years of experience in ETL, data warehouse or data migration testing;
• Strong understanding of software testing fundamentals and the testing lifecycle;
• Experience in design and executing SQL queries for database/backend validation using database tools like Casandra/ MSSQL/ Mongo DB/Studio 3T;
• Experience communicating and working within cross-departmental teams consisting of software developers, department leads, and end users;
• Excellent computer, analytical, written and oral communication skills; and
• Experience in the regulated healthcare industry is a plus.

Medpace Overview

Medpace is a full-service clinical contract research organization (CRO) providing phase l-lV clinical development services to the biotechnology, pharmaceutical, and medical device industries. Our mission is to accelerate the global development of safe and effective medical therapeutics through the advancement of clinical research. We leverage in-country regulatory and therapeutic expertise across all major therapeutic areas including oncology, cardiology, metabolic, endocrinology, central nervous system, and anti-viral and anti-infective. Headquartered in Cincinnati, Ohio, we employ more than 6,500 people across 40+ countries.

Why Medpace?

When you join Medpace, you become part of an innovative team that brings cutting-edge therapies to market while building a meaningful and rewarding career focused on scientific excellence and improving patient outcomes around the world through continuous learning and cross-functional collaboration.

Purpose-Driven Work

• Work alongside physicians, scientists, and industry-leading experts committed to advancing the global development of medical therapeutics through clinical research excellence

Collaborative Culture

• Contribute to an interactive team environment that empowers decision making, creative thinking, and continuous learning through open communication and mutual trust.
• Leadership throughout Medpace is both accessible and approachable

Continuous Growth & Development

• Office based environment with on-site mentors
• Defined career paths with clear advancement opportunities
• Industry renowned onboarding and training programs designed to accelerate professional development
• Ongoing training and continuous learning opportunities throughout your career
• An environment that encourages employees to influence change, contribute ideas, and grow quickly

Other Employee Benefits

• Competitive compensation programs that recognize and reward performance
• Comprehensive health, wellness, retirement, and PTO benefits
• Office based culture with occasional WFH that provides flexibility for eligible positions after training
• Company-sponsored social events

Please note benefits may vary based on country.