Senior ETL Tester

Caterpillar Inc.; Bengaluru; In loco; INR 2.500.000 - 4.000.000; Tempo pieno

Descrizione del lavoro

Caterpillar Inc. in Bengaluru is seeking a detail-oriented QA ETL Engineer to validate data pipelines, ETL processes, and data warehouse solutions.

The role focuses on ETL testing, SQL validation, data quality, and automation within a large enterprise environment. The candidate will design and execute test plans, validate data across multiple sources, and collaborate with data engineers to ensure accurate reporting and data integrity.

Competenze

• Bachelor's degree in CS/IT or related field.
• 8+ years of ETL/Data Warehouse testing experience.
• Strong SQL and database concepts.
• Knowledge of data warehousing and dimensional modeling.
• Experience with Jira and Azure DevOps for defect tracking and test management.
• Understanding of Agile/Scrum methodologies.
• Strong analytical and problem-solving skills.

Mansioni

• Develop and execute ETL test plans, test cases, and scripts for data integration projects.
• Validate data extraction, transformation, and loading across source/target systems.
• Perform source-to-target data mapping validation and reconciliation.
• Execute functional, regression, integration, and end-to-end testing for ETL workflows.
• Write and optimize complex SQL queries to verify data accuracy and completeness.
• Identify, document, track, and retest defects through resolution.
• Collaborate with Data Engineers, Developers, BAs, and Product Owners to understand data flows.
• Validate data warehouse, data lake, and reporting solutions.
• Support test automation initiatives for ETL and data quality testing.
• Participate in Agile ceremonies like sprint planning and reviews.

Conoscenze

SQL

ETL testing

Data validation

Automation testing

Agile/Scrum

Troubleshooting

Formazione

Bachelor's degree in Computer Science/IT or related field

Strumenti

Jira

Azure DevOps

Python

Selenium

Descrizione del lavoro

Job Description

Your Work Shapes the World at Caterpillar Inc. When you join Caterpillar, you're joining a global team who cares not just about the work we do – but also about each other. We are the makers, problem solvers, and future world builders who are creating stronger, more sustainable communities. We don't just talk about progress and innovation here – we make it happen, with our customers, where we work and live. Together, we are building a better world, so we can all enjoy living in it.

Career Area

Technology, Digital and Data

Job Summary

We are seeking a detail-oriented QA ETL Engineer to validate and ensure the quality, accuracy, and integrity of data pipelines, ETL processes, and data warehouse solutions. The ideal candidate will have strong experience in ETL testing, SQL, data validation, and automation testing within large-scale enterprise environments.

Key Responsibilities

• Develop and execute ETL test plans, test cases, and test scripts for data integration projects.
• Validate data extraction, transformation, and loading processes across multiple source and target systems.
• Perform source-to-target data mapping validation and data reconciliation.
• Execute functional, regression, integration, and end-to-end testing for ETL workflows.
• Write and optimize complex SQL queries to validate data accuracy, completeness, and consistency.
• Identify, document, track, and retest defects through resolution.
• Collaborate with Data Engineers, Developers, Business Analysts, and Product Owners to understand requirements and data flows.
• Validate data warehouse, data lake, and reporting solutions.
• Support test automation initiatives for ETL and data quality testing.
• Participate in Agile ceremonies, including sprint planning, reviews, and retrospectives.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 8+ years of experience in ETL/Data Warehouse testing.
• Strong proficiency in SQL and database concepts.
• Knowledge of data warehousing concepts and dimensional modeling.
• Experience with defect tracking and test management tools such as Jira and Azure DevOps.
• Understanding of Agile/Scrum methodologies.
• Strong analytical, troubleshooting, and problem-solving skills.

Preferred Qualifications

• Experience with cloud data platforms such as Azure, AWS, or Google Cloud.
• Experience in test automation using Python, Selenium, or data testing frameworks.
• Knowledge of CI/CD pipelines and DevOps practices.

Posting Dates

October 18, 2026 - October 24, 2026

Caterpillar is an Equal Opportunity Employer. Qualified applicants of any age are encouraged to apply