Test Analyst

2 days ago

Hybrid Banglore karnataka India Derisk360 Full time ₹ 12,00,000 - ₹ 36,00,000 per year

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.

  • Business Analyst

    2 days ago

    Kumbakonam, Tamil Nadu, , India Aardhraa Test Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    We are looking for a proactive and detail -oriented Business Analyst to join our team. The ideal candidate will be responsible for analyzing and evaluating business processes, identifying areas for improvement, and implementing effective solutions. As a Business Analyst, you will work closely with stakeholders, project managers, and technical teams to ensure...

  • Test Analyst

    4 days ago

    India MUFG Pension & Market Services Full time ₹ 5,00,000 - ₹ 12,00,000 per year

    DescriptionOverviewWe're looking for Test Analyst professionals who are driven and passionate about Testing and Quality, who can perform design, preparation and execution of testing across an enterprise scale application landscape. A strong background in super, insurance and financial systems will be highly advantageous.Key Accountabilities and Main...

  • Worldline - Test Analyst - Functional Testing

    2 weeks ago

    Hyderabad, India Worldline Global Services Full time

    Job Description Position Overview We are seeking an experienced Test Analyst to join our dynamic team for a project that involves both traditional functional testing (user acceptance testing) and test automation. The ideal candidate will have strong analytical skills, experience with functional testing methodologies, and knowledge of test automation...

  • Selenium Test Analyst

    4 days ago

    India Capgemini Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Short Description Selenium Test Analyst - 4 to 6 yrs-Hyderabad Qualifications Job ResponsibilitiesJob DescriptionPQA Resource with Automation testing experience to support LARS applicationJob ResponsibilitiesPerform end end testing by creating test scenarios cases and scriptsExperience QA Resource with Automation testing experience in a finance...

  • ETL Test Analyst

    4 days ago

    India Capgemini Full time ₹ 40,00,000 - ₹ 1,20,00,000 per year

    Short Description ETL Test Analyst - 4 to 6 yrs-Bangalore Qualifications Job Responsibilities Job Description:Overall hands on experience in ETL Testing .Understanding of data model, ETL architectureGood Data warehouse concepts.Knowledge of writing Medium to complex SQL queries.BFSI domainPrimary Skills-ETL

  • QTP Test Analyst

    4 days ago

    India Capgemini Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Short Description QTP Test Analyst - 6 to 9 yrs-Bangalore Qualifications Job Responsibilities Job DescriptionISEB/ISTQB Foundation Certificate in Software Testingyears test experience of UFT (aka QTP) automation within a defined framework and following the documented Framework Guidelines. Strong test analysis experienceUse of exploratory testing...

  • Test Analyst

    2 weeks ago

    Hyderabad, India Cognizant Full time

    Job Description Job Summary We are seeking a skilled Test Analyst with 3 to 7 years of experience to join our team in a hybrid work model. The ideal candidate will have expertise in Linux and Embedded Systems using C/C++. This role involves ensuring the quality and reliability of our tech devices through rigorous testing and validation processes. The...

  • SAP Testing Analyst

    2 days ago

    India AMETEK Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    We are seeking a highly skilled SAP Testing Analyst with hands-on experience in Tosca Tricentis to join our SAP Team in AMETEK Bangalore office. This role will play a key role in ensuring the quality and reliability of SAP applications through effective testing strategies. The role involves working closely with cross-functional teams to design, execute, and...

  • Technical Systems Analyst

    4 days ago

    Banglore, India Albemarle Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    Be an essential element to a brighter future. We work together to transform essential resources into critical ingredients for mobility, energy, connectivity and health. Join our values-led organization committed to building a more resilient world with people and planet in mind. Our core values are the foundation that make us successful for ourselves, our...

  • ▷ High Salary! Senior Test Analyst

    2 weeks ago

    India emagine Full time

    Job Description Introduction & Summary We are seeking a detail-oriented and experienced Senior Test Analyst to join our offshore team in India. This role is crucial for System Integration Testing (SIT), focusing on end-to-end (E2E) testing efforts within trading and settlement platforms. The ideal candidate will possess a proven background in complex system...