Disclaimer: Hunt UK Visa Sponsors aggregates job listings from publicly available sources, such as search engines, to assist with your job hunting. We do not claim affiliation with Derisk360. For the most up-to-date job details, please visit the official website by clicking "Apply Now."
Job Title: Test Analyst (ETL Testing & SQL Expert – Individual Contributor)
Location: Bangalore, Chennai, Gurgaon –
Hybrid (3 days/week work from office)
Experience Level: 7+ Years
Mode: Hybrid
Role Type: Individual Contributor (Not a Managerial Role)
Job Summary
We are looking for a
highly experienced and hands-on Test Analyst with deep expertise in
ETL testing, complex SQL queries, and
end-to-end data validation. This is a critical
individual contributor role focused on validating the integrity, accuracy, and completeness of data across all layers of the data pipeline – from source to target – in large-scale
data migration and transformation projects.
The ideal candidate must demonstrate
practical proficiency in writing and optimizing complex SQL queries, along with a
strong understanding of ETL testing methodologies and frameworks.
Key Responsibilities
- Design and implement comprehensive ETL test strategies and plans for data migration, transformation, and validation.
- Perform end-to-end testing across all layers of the data pipeline (source, staging, transformation logic, and target).
- Write, debug, and optimize complex SQL queries for large-scale data validation and backend testing.
- Validate ETL workflows and data movement processes across different databases, file systems, and cloud environments.
- Ensure data integrity, consistency, and completeness by applying sound data quality and testing principles.
- Collaborate with developers, data engineers, and business analysts to understand requirements and troubleshoot data issues.
- Execute test cases, log defects, perform root cause analysis, and track resolution to closure.
- Generate and maintain detailed test documentation including test cases, defect logs, and traceability matrices.
- Participate in peer reviews of test artifacts and contribute to continuous improvement of testing processes.
Required Skills & Qualifications
- Bachelor’s degree in Computer Science, Information Technology, or related discipline.
- Strong hands-on experience with ETL testing processes, frameworks, and tools (e.g., Informatica, Talend, etc.).
- Must have deep expertise in writing complex SQL queries for large dataset validations.
- Proven experience in end-to-end testing for data migration projects, with ability to test across all layers.
- Strong understanding of data warehousing concepts, data lakes, and data integration workflows.
- Familiarity with test management and defect tracking tools such as JIRA, TestRail, etc.
- Experience with testing in cloud environments (AWS, Azure, GCP) is preferred.
- Excellent communication skills and ability to work independently in a collaborative team environment.
Preferred Qualifications
- Scripting knowledge (Python, Shell, etc.) for test automation is a plus.
- Experience with API testing, integration testing, and automation frameworks.
- Exposure to CI/CD processes and tools like Git, Jenkins, etc.
- ✅ Good to have: Banking domain experience – this will be considered an added advantage.
