FBS Application Test Spec IV.

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. Requirements 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) Snowflake - 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)

Benefits Competitive compensation and benefits package:

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/