Automation Test Engineer

The role

The Automation Test Engineer ensures the quality and reliability of enterprise data warehouse applications, ETL pipelines, and backend systems. The role involves validating data transformations and developing automated testing solutions within an Agile Scrum team.

What you will do

• Perform ETL, backend database, and data warehouse testing.
• Develop and execute manual and automated test cases for data pipelines and backend applications.
• Validate source-to-target data transformations, business rules, and data quality using SQL.
• Design, develop and maintain automation frameworks for ETL, database, and regression testing using Python and SQL.
• Execute data validation, reconciliation, row count, aggregate, and data integrity testing.
• Validate cloud-based data platforms including AWS, Databricks, Redshift, Amazon S3, and RDS.
• Develop test plans based on business requirements and acceptance criteria.
• Collaborate with cross-functional Agile teams to support sprint planning, defect resolution, and release validation.
• Participate in system integration, regression, and performance testing.
• Identify defects, perform root cause analysis, and recommend process improvements.

Required qualifications

• Bachelor's Degree or equivalent experience 8 Years experience
• Strong MySQL skills using Oracle, SQL Server, PostgreSQL, MySQL, or Redshift.
• 5 years of Test Automation experience
• Experience developing test plans through data driven testing
• Experience in ETL Testing, Backend Database Testing, and Data Validation.
• Experience developing manual and automation testing solutions.
• Hands-on experience with AWS cloud services, Databricks, and data warehouse environments.
• Experience creating data-driven test plans and validating large datasets.
• Strong analytical, problem-solving, and troubleshooting skills.

Nice to have

• Databricks and Amazon Redshift
• Python, SQL, PySpark, Java, or C#
• Selenium, PyTest, TestRail
• Stored Procedures, Functions, and Database Performance Testing
• AWS IAM, Amazon RDS
• REST API testing and CI/CD pipelines
• Healthcare or CMS data experience
• Agile/Scrum methodology

Benefits

• certifications
• industry training

Before you apply

• US Citizenship required
• Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States.
• Candidates who are currently employed by a client of Accenture Federal Services or an affiliated Accenture business may not be eligible for consideration.

About the company

Accenture Federal Services is a technology company within global Accenture that helps the US federal government. Its 13,000+ people pursue technology and ingenuity for clients across defense, national security, public safety, civilian, and military health organizations.