ETL Tester

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. 

What to Expect Next

A Medpace team member will review your application and if your profile matches our current needs, you will be contacted for an interview. While we review all applications carefully, we are unable to respond to every applicant, and only candidates selected for interviews will be contacted.