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 • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Lead end-to-end QA for Salesforce Sales Cloud and CPQ across Quote-to-Cash. Design and execute functional, regression, API, and end-to-end tests; build and maintain ACCELQ automation suites; validate data flows with external systems; support UAT; collaborate with developers, admins, and product owners; troubleshoot defects and ensure release quality.
Top Skills:
AccelqApexBrunoCi/Cd PipelinesClaudeDell BoomiFlowsInformatica CloudLightning Web Components (Lwc)Microsoft CopilotMulesoftNetSuiteOauthPlaywrightPostmanProcess BuilderProvarRest ApisRevenue CloudSalesforce BillingSalesforce CpqSalesforce Sales CloudSalesforce Scale CenterSeleniumSlackbot AiSoap ApisSOQLSoslSsoVaricent
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Cybersecurity • Data Privacy
Lead Rubrik's engagement with Global Systems Integrators across India to grow strategic partnerships, drive service creation and enablement, execute account and partner business plans, coordinate cross-functional teams, and accelerate partner adoption and bookings. Manage negotiations, build OEM/ISV ecosystems, and travel extensively to engage partners.
Top Skills:
AWSCloud PlatformsGCPMicrosoft (Azure)NutanixPure StorageRubrikSaaSSalesforce
Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Design, build, and deploy event-driven automations to eliminate operational runbook toil. Operate and support production databases and streaming platforms, participate in on-call rotation, implement least-privilege IAM and auditability, and lead automation roadmap across data infrastructure.
Top Skills:
AlertmanagerApache AirflowAws CloudtrailAws CloudwatchAws EventbridgeAws IamAws LambdaClaudeCursorDynamoDBElasticsearchGithub ActionsGitopsJavaScriptJenkinsKafkaKubernetesMySQLPostgresPrometheusPythonRedisTerraformTypescript
What you need to know about the Mumbai Tech Scene
From haggling for the best price at Chor Bazaar to the bustle of Crawford Market, the energy of Mumbai's traditional markets is a key part of the city's charm. And while these markets will always have their place, the city also boasts a thriving e-commerce scene, ranking among the largest in the region. Driven by online sales in everything from snacks to licensed sports merchandise to children's apparel, the local industry is worth billions, with companies actively recruiting to meet the demands of continued growth.
