Senior Data Tester

Capgemini; Hyderabad; On-site; INR 1,800,000 - 2,400,000; Full time

Job summary

Capgemini in Hyderabad, India, seeks an experienced Data Testing professional to join a data-heavy environment focused on ETL, Data Warehouse and Big Data testing for complex enterprise applications.

You will validate source-to-target mappings, transformations and business rules, perform data quality checks, reconciliation, regression and end-to-end testing, and craft advanced SQL queries for data validation.

Qualifications

• 6-10 years of experience in ETL, Data Warehouse, or Big Data Testing.
• Strong hands-on expertise in SQL, PL/SQL, Joins, CTEs, and Window Functions.
• Experience with PySpark, Spark SQL, Hive, Hadoop, or Databricks.
• Experience in automation of data testing and defect lifecycle management.

Responsibilities

• Perform ETL, Data Warehouse, and Big Data testing for complex enterprise applications.
• Validate source-to-target data mappings, transformations, and business rules.
• Execute data quality, reconciliation, regression, and end-to-end testing.
• Develop and execute complex SQL queries for data validation and analysis.
• Collaborate with developers, data engineers, and business stakeholders to ensure data accuracy.

Skills

ETL Testing

Data Warehouse Testing

Big Data Testing

SQL

PL/SQL

Joins

CTEs

Window Functions

Data quality testing

Automation of data testing

Tools

SQL

PySpark

Spark SQL

Hive

Hadoop

Databricks

Job description

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way youd like, where youll be supported and inspired bya collaborative community of colleagues around the world, and where youll be able to reimagine whats possible. Join us and help the worlds leading organizations

Your Role

• Perform ETL, Data Warehouse, and Big Data testing for complex enterprise applications.
• Validate source-to-target data mappings, transformations, and business rules.
• Execute data quality, reconciliation, regression, and end-to-end testing.
• Develop and execute complex SQL queries for data validation and analysis.
• Collaborate with developers, data engineers, and business stakeholders to ensure data accuracy.

Your Profile

• 6-10 years of experience in ETL, Data Warehouse, or Big Data Testing.
• Strong hands-on expertise in SQL, PL/SQL, Joins, CTEs, and Window Functions.
• Experience with PySpark, Spark SQL, Hive, Hadoop, or Databricks.
• Strong understanding of data validation, reconciliation, and data quality testing.
• Experience in automation of data testing and defect lifecycle management.

What you will love working at Capgemini

• Large-scale Data Warehouse and Big Data transformation programs.
• Modern cloud and analytics platforms using Databricks and Spark.
• End-to-end ownership of critical data quality initiatives.