Job Description

Development, enhancement and automation of all regression validation check for all test scenarios in integration with synthetic test data generation APIs
Job TitleAutomation Engineer - Regression Validation & Synthetic Test Data AutomationRole
Overview
As an Automation Engineer, you will be responsible for developing, enhancing and automating all regression-validation checks for our suite of applications. You will work closely with development, QA, data teams and infrastructure owners to integrate synthetic test-data generation APIs, orchestrate the automation of test scenarios, and validate functionality across applications, services and data layers. You will use your strong expertise in C# and SQL to script, automate, validate, and maintain automation assets.Key Responsibilities1. Design, develop and maintain automated regression test suites covering functional, integration, and end-to-end flows.
2. Proven experience (typically 3-7 years) as an automation engineer or QA automation specialist, with primary responsibility for regression automation in software projects.
3. Strong hands-on programming experience in C#-developing automation scripts, utilities, frameworks or test harnesses.
4. Strong SQL skills: ability to write, optimize, debug SQL queries; experience validating test data, data sets and results using SQL relational databases (SQL Server, MySQL, Oracle or equivalent).
5. Implement automation for Excel output validation: read Excel reports/output - validate contents, compare expected vs actual, flag differences, integrate into automation pipelines.
6. Experience in automating test scenarios using APIs (REST/SOAP) and integrating synthetic test data generation or manipulation (via APIs or scripts).
7. Experience with CI/CD tooling (e.g., Jenkins, Azure DevOps, GitHub Actions) and integrating automated tests into build/release pipelines.
8. Integrate test automation with synthetic test data generation APIs: ensure test data is programmatically generated, managed and injected into test scenarios.
9. Write and maintain automation scripts and utilities in C# for the target application landscape.
10. Use SQL to query, validate, and clean up data in test databases; write robust SQL queries to verify test results, test data states, and ensure data integrity across scenarios.
11. Enhance existing automation frameworks: refactor, optimize, add new modules, increase re-usability of automation assets, drive framework improvements.
12. Collaborate with QA leads, functional analysts, development (.NET/C#) teams, and data/infrastructure teams to identify regression scope, test data needs, dependencies, and infrastructure constraints.
13. Execute regression automation in CI/CD pipelines: schedule, monitor, report on automated runs; ensure automation fits into build/release pipelines effectively.
14. Maintain and manage the automation test environments, including data setup/teardown, environment provisioning (mock/test services), and synthetic data injections.
15. Analyze automation results, log defects, communicate issues and work with development/data teams to resolve. Provide meaningful metrics and reports (coverage, regression failure trends, automation ROI).
16. Ensure automation assets remain maintainable, scalable and reliable: establish/publish coding standards, review automation code, enforce best practices.
17. Assist in defining and documenting the regression automation strategy: scope, coverage, risk areas, data requirements, and synthetic data usage.
18. Stay current with emerging automation tools, synthetic data generation techniques, programming practices (C#), database tools (SQL), and recommend improvements.

Skills Required