Senior ETL Tester

Mployee.me; Bengaluru; In loco; INR 4.000.000 - 7.000.000; Tempo pieno

Descrizione del lavoro

Caterpillar Inc. is seeking a detail-oriented QA ETL Engineer to validate data pipelines, ETL processes, and data warehouses. You will conduct ETL testing, create SQL-based validations, and support automation within large-scale enterprise environments.

The role focuses on ensuring data quality, integrity, and reliability across source-to-target transformations, data lake/storage solutions, and reporting platforms, with close collaboration across Data Engineers, Developers, and Product Owners.

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 concepts and dimensional modeling.
• Experience with Jira and Azure DevOps for defect tracking/test management.
• Understanding of Agile/Scrum methodologies.
• Strong analytical, troubleshooting, and problem-solving skills.

Mansioni

• Develop and execute ETL test plans, cases, and scripts for data integration projects.
• Validate data extraction, transformation, and loading across sources and targets.
• 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 validate data accuracy and completeness.
• Identify, document, track, and retest defects through resolution.
• Collaborate with Data Engineers, Developers, BAs, and PO 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, including sprint planning and reviews.

Conoscenze

SQL

ETL testing

Data validation

Agile/Scrum

Troubleshooting

Formazione

Bachelor's degree in Computer Science/Information Technology

Strumenti

Jira

Azure DevOps

Python

Selenium

Descrizione del lavoro

Career Area

Technology, Digital and Data

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.

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