Test Automation Engineer III

Description: About Us:

eSimplicity is a modern digital services company that partners with government agencies to improve the lives and protect the well-being of all Americans, from veterans and service members to children, families, and seniors. Our engineers, designers, and strategists cut through complexity to create intuitive products and services that equip federal agencies with solutions to courageously transform today for a better tomorrow.

Purpose and Scope

The Backend Data Validation and Performance Test Engineer will be responsible for validating and assessing large-scale backend data systems to ensure accuracy, integrity, reliability, and high performance across CMS enterprise applications. This role requires strong expertise in backend database testing, ETL validation, big-data ecosystems, performance benchmarking, and cross-system data comparison between backend outputs and frontend/UI results. The engineer will closely partner with Data Coaches, Data Analysts, DBAs, and Agile delivery teams to ensure all backend data processes meet program, architectural, and CMS compliance standards.

Responsibilities

• Perform comprehensive backend data and ETL validation across big-data platforms such as Databricks, Snowflake, PostgreSQL, and similar technologies.
• Analyze, interpret, and validate complex CMS datasets, including Shared Systems Claims, Final Action Indicator logic, Provider data, Beneficiary data, and other data assets.
• Validate data sourced from CMS’s Integrated Data Repository (IDR) and OnePI (Program Integrity) systems as they relate to Fraud Prevention System (FPS) downstream workflows.
• Perform detailed backend-to-frontend comparison testing to ensure accurate and consistent data presentation between backend databases (Snowflake/PostgreSQL) and UI applications or Databricks Unity Catalog outputs.
• Execute backend performance testing activities, including:
• Query performance analysis and optimization recommendatio...