Backend/Data QA

Position Overview

We are seeking a skilled Backend/Data QA (Automation) Engineer to join our team in Bengaluru, Karnataka. This role is crucial for driving test planning and execution for critical backend services and data workflows. Your primary focus will be on API automation, robust SQL-based data validation, and comprehensive integration/ETL testing across complex services and data pipelines. You will collaborate closely with engineering and analytics teams to ensure the functionality, data accuracy, performance, and reliability of our enterprise systems.

Key Responsibilities:

• Plan and execute tests for backend services, APIs, and intricate data integrations.
• Develop, maintain, and enhance automated API test suites, including smoke and regression packs.
• Conduct thorough SQL-based validations, focusing on transformations, joins, aggregations, and data reconciliations.
• Provide essential support for ETL/ELT testing, including source-to-target checks, mapping validations, and data parity assessments.
• Actively participate in integration and end-to-end testing scenarios, spanning across multiple services and data pipelines.
• Effectively triage defects, analyze logs and metrics, and collaborate with cross-functional teams for prompt issue resolution.
• Contribute to CI/CD pipelines by ensuring quality gates and providing release readiness evidence; execute test collections via Newman within pipelines.
• Document comprehensive test plans, test cases, and test results; produce clear, actionable defect reports.
• Adhere strictly to security, governance, and compliance guidelines throughout the testing process.
• Drive continuous improvements in QA processes and tooling to enhance efficiency and effectiveness.

Required Qualifications:

• A minimum of 3 years of experience in Quality Assurance, with a strong emphasis on backend/API testing and/or data/ETL testing.
• Hands-on experience with API testing tools like Postman, including managing collections, environments, and writing pre-request/test scripts; proven experience running Newman in CI environments is essential.
• Proficiency in test automation using Python with frameworks such as pytest or requests (or equivalent modern automation stack).
• Strong SQL skills for effective data validation and reconciliation, preferably with experience in MS SQL.
• Solid understanding of HTTP, REST principles, JSON data format, and authentication mechanisms (e.g., OAuth/JWT).
• Exposure to ETL/ELT concepts and cloud data platforms, specifically Azure (Data Factory/Fabric/Databricks) and/or AWS.
• Experience with version control systems like Git and familiarity with CI/CD practices; experience with Agile methodologies and defect tracking tools (Jira/Azure DevOps) is expected.
• Excellent communication and cross-functional collaboration skills.

Nice to Have:

• Experience with contract testing, service virtualization, and performance testing tools such as k6 or JMeter.
• Familiarity with observability concepts (logs/metrics) and troubleshooting distributed systems.
• Exposure to distributed data processing frameworks like Spark or BI validation.
• A good understanding of data governance principles.
• Relevant certifications such as ISTQB, AWS, or Microsoft.

Client Context:

Our client is a prominent US-based investment management business, part of a Fortune Global 500 and Fortune 500 American company. They offer a wide array of insurance, investment management, and other financial products and services to both retail and institutional customers across the United States and over 40 international markets.