Senior Data Tester

Capgemini Engineering; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Capgemini is seeking a seasoned ETL/Data Warehouse/Big Data Tester to ensure data quality across complex enterprise applications in Hyderabad. You will validate mappings, transformations and business rules, and execute end-to-end testing with SQL-driven data validation.

The role emphasizes automation of data testing, reconciliation, and defect lifecycle management, collaborating with developers, data engineers, and business stakeholders to deliver accurate data insights.

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.
• Strong understanding of data validation, reconciliation, and data quality testing.
• 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

SQL

PL/SQL

Joins

CTEs

Window Functions

PySpark

Spark SQL

Hive

Hadoop

Databricks

Tools

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 you’d like, where you’ll be supported and inspired bya collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizationsunlock the value of technology and build a more sustainable, more inclusive world.

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.

Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.

Make it real | www.capgemini.com