Automation Engineer - API/Data/SQL

Job summary

The Automation Engineer role involves designing and implementing automated validation solutions for APIs, data pipelines, and database reconciliation. Key responsibilities include developing automated validation, building reusable automation frameworks with advanced Python, performing SQL-based validation, and integrating automated tests with CI/CD pipelines to ensure data quality and platform reliability.

Qualifications

• Minimum of 5 years of test automation experience, preferably in an enterprise level data integration project
• 5+ years of experience in building and implementing reusable automation frameworks using advanced Python development
• Advanced knowledge of technologies: Python, Pytest, Playwright, Requests or HTTPX, Pandas or PySpark, SQL, Postman/Newman, Azure DevOps Repos and Pipelines, Microsoft Azure including: Azure Data Factory and Databricks, Kafka/Event Hub, JFrog Artifactory, Allure or equivalent reporting tool

Responsibilities

• Develop automated validation for APIs, ETL/data pipelines, transformations, database reconciliation, and regression testing
• Build reusable automation frameworks using advanced Python development
• Perform SQL-based validation and reconciliation
• Validate schemas, contracts, and batch/event-driven interfaces
• Create automated reporting and logging solutions
• Integrate automated tests with CI/CD pipelines
• Follow Git branching and code review best practices
• Produce test execution evidence and reports

Skills

Certifications

Security clearance

Relocation