ETL Tester

Capgemini; San Francisco (CA); On-site; USD 80,000 - 107,000; Full time

Job summary

Capgemini is seeking an experienced ETL Tester to join their Quality Assurance team in San Francisco. The role involves validating data integration processes and ensuring data accuracy, while collaborating with developers and data engineers. Ideal candidates will have strong ETL testing experience, proficiency in SQL, and familiarity with tools like Informatica and Snowflake.

Benefits

Flexible work

Healthcare including dental, vision, mental health

Financial well-being programs such as 401(k)

Paid time off and paid holidays

Paid parental leave

Qualifications

• Strong experience in ETL Testing with a focus on data validation and transformation.
• Proficiency in SQL for data querying, validation, and analysis.
• Solid understanding of QA methodologies and testing life cycle.

Responsibilities

• Develop and implement comprehensive test strategies and plans for ETL processes.
• Execute test cases to validate ETL workflows and data transformations.
• Collaborate with development and data engineering teams to resolve issues.

Skills

ETL Testing

SQL

Analytical Skills

Problem-Solving

Communication

Tools

Informatica

Snowflake

Job description

Explore our latest thought leadership, ideas, and insights on the issues that are shaping the future of business and society.

Choose a partner with intimate knowledge of your industry and first-hand experience of defining its future.

Discover our portfolio – constantly evolving to keep pace with the ever-changing needs of our clients.

Become part of a diverse collective of free-thinkers, entrepreneurs and experts – and help us to make a difference.

See our latest news, and stories from across the business, and explore our archives.

We are a global leader in partnering with companies to transform and manage their business by harnessing the power of technology.

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.

We are seeking a detail-oriented and experienced ETL Tester to join our Quality Assurance team. The ideal candidate will be responsible for validating data integration and transformation processes, ensuring data accuracy, and supporting the delivery of high-quality data solutions. You will work closely with developers, data engineers, and business analysts to test and validate ETL workflows and data pipelines.

Key Responsibilities:

• Develop and implement comprehensive test strategies and plans for ETL processes.
• Prepare detailed test cases and scenarios based on business requirements and technical design documents.
• Execute test cases to validate ETL workflows and data transformations.
• Perform various types of testing including functional, integration, regression, system, and user acceptance testing (UAT).
• Ensure data accuracy, completeness, and integrity across source and target systems.
• Identify, document, and track defects using standard defect tracking tools.
• Collaborate with development and data engineering teams to resolve issues and verify fixes.
• Generate test reports, metrics, and dashboards to communicate testing progress and quality status to stakeholders.
• Participate in daily stand-ups, sprint planning, and review meetings.

Required Skills and Qualifications:

• Strong experience in ETL Testing with a focus on data validation and transformation.
• Proficiency in SQL for data querying, validation, and analysis.
• Hands-on experience with Informatica and Snowflake or similar ETL and cloud data platforms.
• Solid understanding of QA methodologies, testing life cycle, and defect management processes.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.

Preferred Qualifications:

• Experience with test automation tools for data testing.
• Familiarity with Agile/Scrum methodologies.
• Knowledge of data warehousing concepts and data modeling

Life at Capgemini

Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
Flexible work
Healthcare including dental, vision, mental health, and well-being programs
Financial well-being programs such as 401(k) and Employee Share Ownership Plan
Paid time off and paid holidays
Paid parental leave
Family building benefits like adoption assistance, surrogacy, and cryopreservation
Social well-being benefits like subsidized back-up child/elder care and tutoring
Mentoring, coaching and learning programs
Employee Resource Groups
Disaster Relief

Disclaimer

Capgemini is an Equal Opportunity Employer encouraging diversity in the workplace. 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 accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.
Click the following link for more information on your rights as an Applicant http://www.capgemini.com/resources/equal-employment-opportunity-is-the-law

Salary Transparency Disclaimer

Capgemini discloses salary range information in compliance with state and local pay transparency obligations. The disclosed range represents the lowest to the highest salary we, in good faith, believe we would pay for this role at the time of this posting, although we may ultimately pay more or less than the disclosed range, and the range may be modified in the future. The disclosed range takes into account the wide range of factors that are considered in making compensation decisions including, but not limited to, geographic location, relevant education, qualifications, certifications, experience, skills, seniority, performance, sales or revenue-based metrics, and business or organizational needs. At Capgemini, it is not typical for an individual to be hired at or near the top of the range for their role. The base salary range for the tagged location is $80420 to $106050 / yearly.
This role may be eligible for other compensation including variable compensation, bonus, or commission. Full time regular employees are eligible for paid time off, medical/dental/vision insurance, 401(k), and any other benefits to eligible employees.
Note: No amount of pay is considered to be wages or compensation until such amount is earned, vested, and determinable. The amount and availability of any bonus, commission, or any other form of compensation that are allocable to a particular employee remains in the Company's sole discretion unless and until paid and may be modified at the Company’s sole discretion, consistent with the law.

Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem.

Ref. code 237895-en_US

Posted on 19 May 2025

Experience level Experienced Professionals

Contract type Permanent

Business unit FS

Brand Capgemini

Professional communities Software Engineering

When you join Capgemini, you don’t just start a new job. You become part of something bigger.

Learn about how the recruitment process works – how to apply, where to follow your application, and next steps.

To help you bring out the best of yourself during the interview process, we’ve got some great interview tips to share before the big day.