ETL Test Lead with AZURE Cloud and Data bricks

Capgemini • Atlanta, NY

3d • Onsite

About The Position

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 by a 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 organizations unlock the value of technology and build a more sustainable, more inclusive world. 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.

Requirements

• 12 to 15 years of experience in Data Testing, ETL, Reporting, Data Automation skills.
• Minimum 5 to 8 years of experience in an onsite role, handling multi-vendor and multi-stakeholders at the client side.
• Experience in large data testing transformation programs (at least 2 projects).
• Minimum 4 to 6 years of hands-on experience in Microsoft Azure cloud platform, including Databricks, ADF, and BI Reporting.
• Ability to lead a team of 6 to 10 offshore resources across multiple workstreams (3 to 5 workstreams).
• 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.
• Experience using defect management tools such as Jira, Azure DevOps, and Quality Center.
• Strong knowledge of SDLC, STLC, Agile, and Waterfall methodologies.
• Exposure to ETL test automation frameworks.
• Excellent leadership, communication, and stakeholder management skills.
• Insurance domain experience (Home, Auto, Commercial etc.).
• Collaborate with all project stakeholders with minimal supervision from Capgemini as well as Vendors.

Nice To Haves

• Financial Data repo or Financials Data Hub and downstream General Ledger experience.
• Any automation data testing tool in the cloud.
• Strong knowledge of Guidewire PolicyCenter, ClaimCenter, and BillingCenter data models and business processes.
• Data governance and data quality testing knowledge.
• Experience working in the Insurance domain.
• Relevant certifications in testing, data warehousing, or cloud technologies.

Responsibilities

• Lead large data warehouse and ETL testing initiatives.
• Validate data integration, data migration, data quality, and reporting solutions.
• Lead a testing team.
• Coordinate with business and technical stakeholders.
• Ensure high-quality data delivery across enterprise applications.
• Handle multi-vendor and multi-stakeholder relationships at the client side.
• Lead multiple workstreams, with each workstream typically having 1-2 people.
• Perform 50% lead activities and 50% hands-on responsibilities for the project.

Benefits

• Paid time off based on employee grade (A-F), depending on grade: Vacation: 12-25 days.
• Company paid holidays.
• Personal Days.
• Sick Leave.
• Medical, dental, and vision coverage.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed