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
Artificial Intelligence • Fintech • Information Technology • Logistics • Payments • Business Intelligence • Generative AI
Designs and implements multi-cloud security controls, policy-as-code guardrails, IAM and network protections, container and Kubernetes security, vulnerability remediation, and incident response tooling. Partners with engineering, IT, compliance, and risk teams on audits and control validation. The role also mentors security engineers, supports root-cause analysis, improves response runbooks, and participates in on-call rotations.
Top Skills:
AWSAzureBashCi/CdContainer SecurityEdrGCPIamInfrastructure As CodeJavaScriptKubernetesNaclsOrganizations/ScpsPythonVpcVulnerability Scanning
Artificial Intelligence • Fintech • Information Technology • Logistics • Payments • Business Intelligence • Generative AI
Supports cloud, application, infrastructure, container, and Kubernetes security engineering. Contributes to multi-cloud controls, IAM policies, policy-as-code guardrails, vulnerability triage, compliance evidence gathering, security automation, and secure AI system monitoring. The role also involves scripting, documentation, root-cause analysis, and collaboration with Engineering, IT, Compliance, and senior security engineers.
Top Skills:
AWSAzureBashCi/CdContainer SecurityFedrampGCPIamInfrastructure As CodeIso 27001JavaScriptKubernetesNetwork AclsOrganizations/ScpsPci-DssPolicy As CodePythonSecurity GroupsSoc 2VpcVulnerability Scanning
Information Technology
Design end-to-end digital product experiences through user research, interaction design, wireframing, prototyping, visual design, and design systems. Collaborate with product, engineering, and business stakeholders to create accessible, responsive web and mobile interfaces. Conduct usability testing, incorporate feedback and analytics, present design concepts, and support accurate implementation across multiple initiatives.
Top Skills:
A/B TestingAdobe Creative SuiteComponent LibrariesCSSDesign SystemsFigjamFigmaHTMLProduct AnalyticsWcag
What you need to know about the Delhi Tech Scene
Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.
