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 Chennai, Tamil Nadu, IND Office
DLF IT Park 1/124 Mount Poonamallee Road Sivaji Gardens Manapakkam , Chennai, India, 600089
Similar Jobs
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Cybersecurity • Data Privacy
Lead full-cycle recruiting for complex and senior G&A roles in India, including Finance, Legal, People, IT, and Business Operations. Advise senior leaders on hiring strategy, leveling, organization design, location, and team composition. Develop sourcing strategies, build diverse pipelines, use talent-market intelligence, and improve candidate and interview processes. Mentor peers on recruiting tools and best practices while leading cross-functional Talent Acquisition initiatives.
Top Skills:
Applicant Tracking Systems (Ats)Competitive Intelligence ToolsRecruiting AnalyticsSourcing Platforms
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Cybersecurity • Data Privacy
Lead full-cycle recruiting for senior and complex G&A roles in India, including Finance, Legal, People, IT, and Business Operations. Advise senior leaders on hiring strategy, leveling, organization design, and location decisions. Build diverse talent pipelines, engage passive candidates, support internal mobility, and drive talent acquisition initiatives. Serve as a recruiting process and ATS subject-matter expert while mentoring peers and improving candidate and interviewer experiences.
Top Skills:
Applicant Tracking Systems (Ats)Market Intelligence ToolsRecruiting Analytics And Reporting ToolsSourcing Tools
Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Build and operate production software and AI systems across cloud infrastructure. Responsibilities include developing APIs and services, operating RAG and inference platforms, implementing CI/CD and observability, managing AWS or GCP environments with Kubernetes and Terraform, optimizing model serving and GPU usage, controlling cloud and AI costs, and partnering with stakeholders on reliability, security, governance, and technical tradeoffs.
Top Skills:
AWSCi/CdFinopsGCPGoJavaKubernetesLlmsNext.JsNode.jsPythonPyTorchRagReactTensorFlowTerraformTypescriptVector Databases
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
