MedpaceVia Unstop

Posted 3d ago

ETL Tester

Pay

Salary (undisclosed)

Location

Navi Mumbai, India

On site

Apply by

25 Nov

9 days left

Skills this role screens for

ETL toolsSQLData validationSoftware testing life cycle (stlc)Database querying

Opens on Medpace's site. Sign in first and we keep it in your pipeline.

Still studying?SQL internships open now

About the role

Medpace is hiring for the role of ETL Tester!

The work

Responsibilities of the Candidate

  • 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.

Who they want

Requirements

  • 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

Found on the web. You apply on the company's own site

From the Wire Desk

Where this listing comes from

From a public listing board (Unstop).

insiderOne never charges students to apply. Never pay anyone for an internship. Check an offer you received

Prove ETL tools first

This role screens for ETL tools. Sit a ten-minute live challenge, get a signed receipt, and the employer sees it verified on your application instead of claimed.

Prove it, then apply

Ask about this role

SCOUT, an AI agent, not a person, answers from this ad, and says so when the ad doesn't cover it. No account, and nothing you type here is kept.

More roles

Every open role

insiderOne University

Get certified for roles like this: Business Communication Associate

Free, about 2 hours, ending in a project marked against a rubric and a certificate any employer can check. Put it on this application and every one after it.

Start the certificationWhat is in it

Interned at Medpace? Report what it paid