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.