Job Description

About Us

Capco, a Wipro company, is a global technology and management consulting firm. Awarded with Consultancy of the year in the British Bank Award and has been ranked Top 100 Best Companies for Women in India 2022 by Avtar & Seramount. With our presence across 32 cities across globe, we support 100+ clients across banking, financial and Energy sectors. We are recognized for our deep transformation execution and delivery.

WHY JOIN CAPCO?

You will work on engaging projects with the largest international and local banks, insurance companies, payment service providers and other key players in the industry. The projects that will transform the financial services industry.

MAKE AN IMPACT

Innovative thinking, delivery excellence and thought leadership to help our clients transform their business. Together with our clients and industry partners, we deliver disruptive work that is changing energy and financial services.

#BEYOURSELFATWORK

Capco has a tolerant, open culture that values diversity, inclusivity, and creativity.

CAREER ADVANCEMENT

With no forced hierarchy at Capco, everyone has the opportunity to grow as we grow, taking their career into their own hands.

DIVERSITY & INCLUSION

We believe that diversity of people and perspective gives us a competitive advantage.

Key Responsibilities:

Exp: 5 to 10yrs

Design and implement automated test strategies for validating ETL pipelines and data integration workflows.



Develop automated test scripts using industry-standard tools/frameworks to validate data ingestion, transformation, and delivery.



Test data flows involving Kafka topics, ensuring data consistency and schema validation across producers/consumers.



Validate data correctness between source systems (DB2) and downstream targets (e.g., S3, Redshift, etc.).



Perform regression, performance, and functional testing of data-centric applications and APIs.



Build and maintain reusable automation test cases and frameworks aligned with DevOps and CI/CD.



Collaborate closely with ETL developers, data engineers, and business analysts to define test coverage and quality metrics.



Analyze test results, debug issues, and proactively identify data anomalies.



Manage test data and leverage mocks/stubs for downstream systems where applicable.

Required Skills & Experience:

6+ years of experience in QA Engineering, with a strong focus on ETL/data warehouse testing.



Hands-on experience with Apache Kafka (topic validation, offset tracking, schema evolution).



Proficient in validating data pipelines on AWS (S3, Lambda, Glue, Redshift, or EMR).



Strong database testing skills with DB2 and SQL-based validation across large datasets.



Solid experience with automation tools/frameworks like Pytest, JUnit, TestNG, Selenium, or custom scripting in Python.



Experience with CI/CD tools (e.g., Jenkins, GitHub Actions) and version control (Git).



Understanding of data quality, lineage, and metadata validation principles.



Strong communication skills and ability to work across agile squads.

Nice to Have:

Knowledge of data lake architecture and cloud-native ETL orchestration.



Experience using Docker or Kubernetes for test environments.



Experience testing REST APIs and microservices supporting data flows.