Design and execute ETL test plans to validate extraction, transformation, and loading processes. Perform source-to-target SQL validations, data reconciliation, regression and integration testing, monitor ETL jobs, report defects, and collaborate with engineers and analysts to ensure data quality and governance.
Job Summary
We are looking for a detail-oriented ETL Tester to validate data extraction, transformation, and loading (ETL) processes across enterprise data platforms. The ideal candidate will have strong SQL skills, hands-on experience with ETL testing, and a solid understanding of data warehousing concepts. You will work closely with Data Engineers, ETL Developers, Business Analysts, and QA teams to ensure data quality, integrity, and accuracy throughout the data lifecycle.
Key Responsibilities- Develop and execute ETL test plans, test cases, and test scripts based on business and technical requirements.
- Validate data extraction, transformation, and loading processes from source systems to target data warehouses.
- Perform source-to-target data validation using SQL queries.
- Verify business transformation rules and ensure data accuracy and consistency.
- Conduct data completeness, data integrity, and reconciliation testing.
- Identify, analyze, and report data discrepancies, defects, and inconsistencies.
- Perform regression, integration, system, and end-to-end testing for ETL processes.
- Validate scheduled ETL jobs and monitor batch processing results.
- Collaborate with Data Engineers and ETL Developers to resolve data quality issues.
- Ensure compliance with data governance, security, and quality standards.
- Prepare test documentation, defect reports, and test execution summaries.
- Participate in requirement analysis and provide feedback on testability and data quality.
- Strong proficiency in SQL for data validation and analysis.
- Hands-on experience in ETL Testing and data validation.
- Good understanding of ETL/ELT processes and data warehousing concepts.
- Experience with relational databases such as Oracle, SQL Server, PostgreSQL, or MySQL.
- Knowledge of data modeling concepts including Star Schema and Snowflake Schema.
- Experience with defect tracking tools such as Jira or Azure DevOps.
- Strong analytical, problem-solving, and debugging skills.
- Excellent communication and documentation skills.
- Experience with ETL tools such as:
- Informatica PowerCenter
- Talend
- Microsoft SSIS
- IBM DataStage
- Pentaho
- Ab Initio
- Experience with cloud data platforms such as Databricks, Snowflake, Azure Synapse, or AWS Redshift.
- Basic knowledge of Python or Shell scripting for test automation.
- Familiarity with BI tools such as Power BI or Tableau.
- Experience working in Agile/Scrum environments.
Similar Jobs
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Supports automation systems including AMHS, ASRS, AGVs, conveyors, robots, PLCs, and material tracking tools. Performs installation, commissioning, testing, troubleshooting, preventive maintenance, root cause analysis, and corrective actions. Participates in automation projects, FAT, SAT, UAT, system buyoffs, documentation, vendor coordination, and cross-functional deployment activities. Ensures compliance with safety and operating standards while developing technical expertise in semiconductor manufacturing automation.
Top Skills:
AgvsAmhsArvAsrsControllersConveyorsLiftsMaterial Tracking SystemsMechanical SystemsPlcsRobotsSensorsServo DrivesSpmVision Systems
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Monitors and operates facility utility systems through FMCS, BMS, and SCADA platforms. Manages alarms, performs field verification and first-level troubleshooting, coordinates maintenance and emergency response, maintains operational logs, prepares shift reports, and conducts detailed handovers. Supports electrical, HVAC, cleanroom, water, gas, fire safety, wastewater, and other critical semiconductor facility systems while contributing to reliability, safety, and energy-saving initiatives.
Top Skills:
Agent BotsBmsCmmsFmcsGen Ai ToolsHmiIndustrial AutomationMicrosoft CopilotPlcScada
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Owns equipment performance, reliability, and availability for semiconductor manufacturing lines. Responsibilities include troubleshooting automation and equipment issues, analyzing downtime, improving OEE, MTBF, and MTTR, optimizing maintenance and changeovers, leading root cause analysis, supporting new product introductions, implementing equipment upgrades, ensuring safety and ESD compliance, coaching technicians, and collaborating with vendors and cross-functional engineering teams.
Top Skills:
Ai-Assisted ToolsData AnalyticsEsd ControlsManufacturing Automation
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
