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.
Photon Hyderabad, Telangana, IND Office
DLF Cyber City 6th Floor, Block 3 Gachibowli , Hyderabad, India, 500032
Photon Hyderabad, Telangana, IND Office
Hyderabad, India
Similar Jobs
Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
Own and build Coursera’s India channel program across universities, government bodies, and public sector enterprises. Recruit and activate partners, develop enablement and compliance frameworks, establish co-sell programs, negotiate agreements, track performance, and conduct partner business reviews. Collaborate with sales, marketing, implementation, and solution consulting teams to generate and close enterprise opportunities, while evaluating new partnerships and leading executive-level partner discussions.
Top Skills:
Gem
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
Operate and monitor high-voltage electrical distribution systems, GIS substations, utilities, transformers, UPS systems, and backup generators in a 24x7 facilities environment. Perform switching, inspections, preventive and corrective maintenance, troubleshooting, emergency response, RCA, safety compliance, and reliability improvements. Maintain shift logs, maintenance records, and reports using CMMS/SAP while supporting HVAC, chilled water, compressed air, water, gas, cleanroom, and building utility systems.
Top Skills:
220 Kv Gis Substations33 Kv Distribution Systems6.6 Kv Electrical NetworksAir CompressorsArc FlashBattery BanksBmsChillersCleanroom UtilitiesCmmsDg SetsEmsGas SystemsGen AiHt/Lt Power SystemsHvacLotoMccMicrosoft CopilotPccPmsProtection RelaysPtwRmuSap PmScadaSwitchgearSynchronization SystemsThermographyTransformersUpsWater And Wastewater Systems
Artificial Intelligence • Consumer Web • Edtech • Enterprise Web • HR Tech • Social Impact • Generative AI
Design and develop scalable, skill-aligned online learning experiences focused on technical and AI topics. Partner with subject-matter experts, APAC partners, and vendors to create outcomes, architectures, storyboards, learning journeys, assessments, and production standards. Provide quality assurance and actionable feedback, build reusable design systems, repackage learning assets, and contribute to AI-assisted design tools, agentic workflows, analytics, experimentation, and continuous improvement.
Top Skills:
Agentic WorkflowsAi/MlArticulate StorylineCoursera PlatformFigmaGenerative AiLookerSQLTableau
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
