ETL Tester with P&C Insurance

At Sogeti, we believe the best is inside every one of us. Whether you are early in your career or at the top of your game, we'll encourage you to fulfill your potential to be better. Through our shared passion for technology, our entrepreneurial culture , and our focus on continuous learning, we'll provide everything you need to do your best work and become the best you can be.​

Your Role

• Perform comprehensive testing of data products, ETL processes, and data validation workflows, ensuring accuracy, completeness, and reliability of insurance data across systems.
• Develop, execute, and maintain complex SQL queries to validate data integrity, troubleshoot issues, and support end-to-end testing activities.
• Test and validate Power BI reports, dashboards, semantic models, and DAX calculations to ensure business requirements and reporting accuracy are met.
• Collaborate with business stakeholders, developers, and analysts within the Property & Casualty Insurance domain to validate data requirements, business rules, and insurance-specific data structures.
• Participate in Agile/Scrum ceremonies, manage defects using tracking tools, and contribute to continuous quality improvement throughout the software development lifecycle.
• Support testing activities on cloud-based data platforms and Azure environments, ensuring seamless integration, performance, and data quality across modern data ecosystems.

Your Profile

• 3+ years of experience in Property & Casualty (P&C) Insurance, with a strong understanding of insurance data structures, business processes, and domain-specific workflows.
• 2+ years of experience in data product testing, including ETL testing, data validation, and ensuring data quality across complex data pipelines.
• Strong SQL expertise with the ability to write, optimize, and troubleshoot complex queries for data analysis, reconciliation, and validation.
• Hands-on experience in Power BI testing, including validation of reports, dashboards, semantic models, and DAX calculations to ensure accurate business reporting.
• Experience working in Agile environments with proficiency in defect tracking and test management tools; exposure to cloud data platforms and Microsoft Azure is a plus.

What will you love working at Capgemini?

This role provides an opportunity to work with insurance data products, ETL processes, and Power BI reporting, while building expertise in SQL, data validation, and cloud-based technologies. Candidates will gain exposure to modern data platforms, Agile delivery practices, and cross-functional collaboration, helping accelerate their growth in the data and analytics space.

Part of the Capgemini Group, Sogeti makes business value through technology for organizations that need to implement innovation at speed and want a local partner with global scale. With a hands-on culture and close proximity to its clients, Sogeti implements solutions that will help organizations work faster, better, and smarter. By combining its agility and speed of implementation through a DevOps approach, Sogeti delivers innovative solutions in quality engineering, cloud and application development, all driven by AI, data and automation.​

Ref. code:  489535

Posted on:  3 Jul 2026

Experience Level:  Experienced Professionals

Contract Type:  Permanent

Location: 

Bangalore, IN

Navi Mumbai, IN

Pune, IN

Hyderabad, IN

Chennai (ex Madras), IN

Brand:  Capgemini

Professional Community:  Quality Engineering & Testing