Cookies & analytics consent
We serve candidates globally, so we only activate Google Tag Manager and other analytics after you opt in. This keeps us aligned with GDPR/UK DPA, ePrivacy, LGPD, and similar rules. Essential features still run without analytics cookies.
Read how we use data in our Privacy Policy and Terms of Service.
🤖 15+ AI Agents working for you. Find jobs, score and update resumes, cover letter, interview questions, missing keywords, and lots more.
Capgemini • Bengaluru, Karnataka, India
Role & seniority: ETL Tester (experienced)
Stack/tools: ETL tools (Informatica PowerCenter, DataStage, SSIS, Talend or similar); SQL; databases (Oracle, SQL Server, Teradata, Snowflake, PostgreSQL); BI tools (Tableau, Power BI, Cognos, MicroStrategy); data quality tools (Informatica DQ, Talend DQ, Collibra); API testing (Postman, Swagger); scripting (Python optional); cloud data platforms (AWS Redshift, Azure Synapse, GCP BigQuery)
Top 3 responsibilities: 1) Validate data transformations and end-to-end testing of insurance data pipelines; 2) Ensure data quality across DW/BI systems; 3) Debug data issues and perform backend data verification; support ETL mappings, DWH design, and schema validation
Must-have skills: Strong hands-on ETL testing; SQL proficiency for validation and complex queries; experience with ETL tools; familiarity with data warehouse concepts (Star/Snowflake schemas); experience with relevant databases; ability to validate mappings and data quality
Nice-to-haves: BI reporting validation (Tableau, Power BI, Cognos, MicroStrategy); Python or scripting for data automation; exposure to Agile/Scrum; API testing experience; knowledge of data quality tooling (Informatica DQ, Talend DQ, Collibra)
Location & work type: Not specified; Capgemini is a global company with remote/hybrid options typical, but no explicit location or work-type stated in the description
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. Your Role We are seeking an experienced ETL Tester with strong expertise in data validation, ETL workflows, and insurance domain processes. The candidate will be responsible for validating data transformations, ensuring data quality across DW/BI systems, and supporting end‑to‑end testing of insurance data pipelines.
Strong hands‑on experience in ETL testing Experience working with ETL tools such as Informatica PowerCenter, DataStage, SSIS, Talend, or similar. Ability to understand and validate ETL mappings, DWH design, fact/dimension structure, and schemas (Star/Snowflake). Strong proficiency in SQL for data validation, joins, aggregations, and complex queries. Experience working with databases like Oracle, SQL Server, Teradata, Snowflake, or PostgreSQL. Expertise in debugging data issues and performing backend data verification. Your Profile Experience with BI reporting tools (Tableau, Power BI, Cognos, MicroStrategy) for report validation. Knowledge of Python or any scripting languages for data automation (optional but beneficial). Exposure to Cloud Data Platforms (AWS Redshift, Azure Synapse, GCP BigQuery).Understanding of Agile/Scrum methodologies. Experience with API testing (Postman, Swagger) is a plus. Knowledge of data quality tools like Informatica DQ, Talend DQ, or Collibra. What you will love about working her You can shape your career with us. We offer a range of career paths and internal opportunities within Capgemini group. You will also get personalized career guidance from our leaders. You will get comprehensive wellness benefits including health checks, telemedicine, insurance with top-ups, elder care, partner coverage or new parent support via flexible work. At Capgemini, you can work on cutting-edge projects in tech and engineering with industry leaders or create solutions to overcome societal and environmental challenges. Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.Make it real | www.capgemini.com