ETL Test Lead

Capgemini; Richmond (VA); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Paid time off

Medical, dental, and vision coverage

401(k) retirement savings plan

Life and disability insurance

Employee assistance programs

Job summary

Capgemini is seeking an experienced ETL Test Lead to drive data warehouse testing across multiple locations in the United States. The role involves leading a testing team, coordinating with business and technical stakeholders, and ensuring high-quality data delivery for enterprise applications.

The candidate should have 12–15 years in data testing, hands-on Azure Databricks/ADF, and a track record of leading offshore teams.

Qualifications

• 12 to 15 years’ experience in Data Testing, ETL, Reporting, Data Automation skills etc.
• Minimum 5 to 8 years’ experience at onsite role, handled multi-vendor and multi-stake holders at client side
• Must have experience in large data testing transformation programs (at least 2 projects)
• Microsoft Azure cloud platform is must – Databricks, ADF, BI Reporting hands-on 4 to 6 years
• Ability to lead 6 to 10 offshore team for multiple workstreams; onsite lead should manage all workstreams
• 50% Lead activities and 50% hands-on responsibility for the project
• Collaborate with all project stakeholders with minimal supervision from Capgemini and Vendors
• Preferred – Financial Data repo/Financials Data Hub and downstream General Ledger experience
• Preferred – Any automation data testing tool in cloud

Responsibilities

• Lead large data warehouse and ETL testing initiatives.
• Coordinate with business and technical stakeholders to ensure data quality.
• Oversee onsite and offshore teams across multiple workstreams.
• Ensure compliance with SDLC, STLC, Agile, and Waterfall methodologies.
• Mentor and guide junior testers and drive test automation where applicable.

Skills

SQL

Data testing

Stakeholder management

Leadership

Agile

Jira

Azure DevOps

Quality Center

Tools

Jira

Azure DevOps

Quality Center

Job description

Location : Multiple Location across Unites States.

We are seeking an experienced ETL Test Lead to lead large data warehouse and ETL testing initiatives. The ideal candidate will have strong expertise in validating data integration, data migration, data quality, and reporting solutions. The role involves leading a testing team, coordinating with business and technical stakeholders, and ensuring high-quality data delivery across enterprise applications.

Key Responsibilities

• Must -12 to 15 years’ experience in Data Testing, ETL, Reporting, Data Automation skills etc..
• Must -Minimum 5 to 8 years’ experience at onsite role, handled multi-vendor and multi-stake holders at client side
• Must – Must have experience in Large data testing transformation program at least for 2 projects
• Must -Microsoft Azure cloud platform is must – Minimum 4 to 6 years hands on experience in Databricks, ADF, BI Reporting
• Must -Ability to lead 6 to 10 offshore team for multiple workstream. This project involves multi workstream minimum 3 to 5. Each workstream will be 1 or 2 people
• Onsite lead should be capable to lead all workstreams
• Must – 50% Lead activities and 50% hands on responsibility for the project
• Must- Collaborate all project stake holders with minimal supervision from Capgemini as well as Vendors
• Preferred – Financial Data repo or Financials Data Hub and downstream General Ledger experience
• Preferred – Any automation data testing tool is preferred in cloud

Required Skills

• Advanced proficiency in SQL and database testing across platforms including Databricks, Oracle, SQL Server, PostgreSQL, Snowflake, and other relational databases.
• Proven experience validating complex data transformations, aggregations, data migration processes, and ensuring data accuracy through rigorous source-to-target validation.
• Solid understanding of dimensional modeling, including Star Schema and Snowflake Schema, along with experience using defect management tools such as Jira, Azure DevOps, and Quality Center.
• Strong knowledge of SDLC, STLC, Agile, and Waterfall methodologies, with exposure to ETL test automation frameworks and excellent leadership, communication, and stakeholder management skills.

Nice-to-Have Skills

• Strong knowledge of Guidewire PolicyCenter, ClaimCenter, and BillingCenter data models and business processes.
• Data governance and data quality testing knowledge.
• Experience working in Insurance domain.
• Relevant certifications in testing, data warehousing, or cloud technologies are advantageous.

.

Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:

Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave

Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)

Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)

Life and disability insurance

Employee assistance programs

Other benefits as provided by local policy and eligibility

Important Notice: Compensation (including bonuses, commissions, or other forms of incentive pay) is not considered earned, vested, or payable until it becomes due under the terms of applicable plans or agreements and is subject to Capgemini’s discretion, consistent with applicable laws. The Company reserves the right to amend or withdraw compensation programs at any time, within the limits of applicable legislation.

Disclaimers

Capgemini is an Equal Opportunity Employer encouraging inclusion in the workplace. Capgemini also participates in the Partnership Accreditation in Indigenous Relations (PAIR) program which supports meaningful engagement with Indigenous communities across Canada by promoting fairness, accessibility, inclusion and respect. We value the rich cultural heritage and contributions of Indigenous Peoples and actively work to create a welcoming and respectful environment. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodation does not pose an undue hardship. Capgemini is committed to providing reasonable accommodation during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.

Please be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.

Click the following link for more information on your rights as an Applicant in the United States. http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law