Test Automation Engineer III

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 recommendations
• Benchmarking data processing times and throughput
• Load, stress, and volume testing of backend services and data pipelines
• Identifying and escalating performance bottlenecks in collaboration with platform and engineering teams
• Collaborate closely with Business Analysts, DBAs, Developers, DevOps engineers, and Scrum/Kanban teams to validate data integrity and ensure optimal backend performance.
• Ensure compliance with CMS Testing Frameworks, SDLC processes, quality standards, and federal regulatory requirements.
• Support functional UI validations when necessary to maintain end-to-end data alignment throughout the application ecosystem.
• Independently develop, execute, and maintain detailed backend test plans, performance testing strategies, and rigorous validation scenarios with minimal oversight.
• Create and execute API-based validation scenarios to test backend service operations and data exchanges.
• Actively participate in Agile ceremonies, including Daily Standups, Sprint Planning, Backlog Refinement, PI Planning, Sprint Reviews/Demos, and Retrospectives.
• Support, mentor, and share subject-matter expertise with backend and functional test teams to strengthen overall quality practices.