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.

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)

Competitive compensation and benefits package:

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/