ETL Tester

Medpace is hiring for the role of ETL Tester! 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. 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.