FBS Application Test Spec IV.

Capgemini; Pune District; Hybrid; INR 1,000,000 - 1,800,000; Full time

Benefits offered by this job

Competitive compensation and bonuses

Comprehensive benefits package

Career development and training

Flexible remote/office options

Private Health Insurance

Pension Plan

Paid Time Off

Training & Development

Job summary

Capgemini India in Pune seeks a data validation and QA specialist to ensure quality across customer data products. You'll craft complex SQL, validate ETL pipelines, and verify Snowflake data warehouses while supporting data governance and analytics initiatives.

You'll participate in Agile ceremonies, troubleshoot data quality issues, and validate data feeds for Power BI and reporting platforms, working across multiple enterprise data domains.

Qualifications

• Experience with SQL-based data validation and ETL testing.
• Knowledge of data governance and data quality frameworks.
• Familiarity with Snowflake and cloud data platforms.
• Experience in Agile/Scrum environments.

Responsibilities

• Validate data across customer data products and pipelines.
• Write complex SQL for profiling, validation, and root cause analysis.
• Validate ETL transformations and Snowflake data warehouses.
• Support data governance, data stewardship, and analytics datasets.
• Participate in Agile ceremonies and operational testing.
• Validate feeds for Power BI and reporting systems.

Skills

SQL

Data validation

ETL testing

MDM

Agile/Scrum

Defect management

Data reconciliation

Root cause analysis

Test planning

Automation testing

Snowflake

Data quality

Tools

AWS S3

AWS Glue

AWS Lambda

EventBridge

EMR Serverless

Step Functions

Git/GitHub

PySpark

Job description

Role Description:

Perform data validation, reconciliation, and quality assurance activities across the Customer Data Products. Execute end-to-end testing for customer mastering, identity resolution, matching, merging, survivorship, and householding processes. Write complex SQL queries for data profiling, validation, reconciliation, root cause analysis, and defect investigation. Validate ETL/data pipeline transformations and data movement across source systems. Perform testing and validation of Snowflake data warehouses, data marts, curated data products, and customer analytics datasets. Verify business rules, transformations, aggregations, and customer data calculations within enterprise data products. Support customer data certification, data governance, data stewardship, and data quality initiatives. Analyze and troubleshoot data quality issues involving customer identities, household relationships, matching results, and downstream reporting. Participate in Agile/Scrum ceremonies including sprint planning, backlog grooming, daily stand-ups, demos, and retrospectives. Support production validation, post-deployment verification, defect triage, and ongoing operational testing activities. Validate customer data feeds consumed by operational platforms, analytics, reporting, Power BI, and enterprise decision-support systems.

Skills and Capabilities

Other Critical Skill

• SQL - Advanced
• Data Validation - Advanced
• ETL Testing - Advanced
• Snowflake - Intermediate
• Automation Testing - Intermediate
• Customer Master Data Management (MDM) - Intermediate
• Agile / Scrum - Intermediate
• Defect Management - Advanced
• Data Reconciliation - Intermediate
• Root Cause Analysis - Entry Level
• Test Planning & Execution - Advanced

Software / Tool Skills

• SQL (Advanced) - Advanced (7+ Years)
• AWS S3, Glue, Lambda, EventBridge - Intermediate (4-6 Years)
• AWS EMR Serverless , Step Functions - Entry Level (1-3 Years)
• Automated Testing Frameworks - Advanced (7+ Years)
• Data Reconciliation Tools - Intermediate (4-6 Years)
• Git/GitHub - Entry Level (1-3 Years)
• PySpark - Entry Level (1-3 Years)

Competitive compensation and benefits package:

1. Competitive salary and performance-based bonuses
2. Comprehensive benefits package
3. Career development and training opportunities
4. Flexible work arrangements (remote and/or office-based)
5. Dynamic and inclusive work culture within a globally renowned group
6. Private Health Insurance
7. Pension Plan
8. Paid Time Off
9. Training & Development

Note: Benefits differ based on employee level.

About Capgemini

Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of over 340,000 team members in more than 50 countries. With its strong 55-year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group €22.5 billion in revenues in 2023.

https://www.capgemini.com/us-en/about-us/who-we-are/