QA Analyst

Jobtailor; Pune District; On-site; INR 600,000 - 900,000; Full time

Job summary

Jobtailor in Pune, India seeks a QA/Test Engineer specialized in data warehousing to ensure delivery quality across projects.

You will design test plans, perform DWH and database testing, write SQL scripts, and coordinate with clients and teams to validate fixes. The role covers functional, regression, load, system, and UAT testing, with emphasis on data quality and defect tracking using JIRA.

Qualifications

• Minimum 3 years and maximum up to 6 years of experience.
• Experience and knowledge in DWH and Database Testing.
• SQL and ETL testing knowledge.
• Ability to debug differences and document identified issues.
• Ability to understand requirements and translate them into test cases.
• Proficiency with SQL language and Data Warehousing principles.
• Knowledge of any ETL tool.
• Experience with cloud technologies; AZURE preferred.
• Experience with JIRA and Agile.
• Good communication skills.
• Basic-level certification in AWS, AZURE, or GCP.
• Familiarity with cloud technologies.
• Experience testing SOAP/API projects.
• Stakeholder communication.
• Microsoft Office proficiency.

Responsibilities

• Act as the gatekeeper between the development team and clients, ensuring deliverables meet client expectations and requirements
• Participate throughout the entire project life cycle and become a subject matter expert for a project
• Write test plans, design test cases, develop test SQL scripts, test conditions, test procedures, and expected results
• Perform DWH and database testing
• Perform functional, regression, load, system, and user acceptance testing (UAT)
• Create large volumes of test data when required
• Track and report defects using tools such as JIRA
• Validate fixes and ensure follow-through across all test cycles
• Investigate and recommend remediation strategies for data quality conditions and process failures
• Communicate test status to internal project teams and clients

Skills

DWH Testing

SQL Proficiency

ETL Testing Knowledge

JIRA Experience

Cloud Technologies Familiarity

Data Warehousing Principles

Education

Bachelor’s or Master Degree or equivalent Degree

Tools

JIRA

AZURE

ETL Tools

Microsoft Office

Job description

• Act as the gatekeeper between the development team and clients, ensuring deliverables meet client expectations and requirements


• Participate throughout the entire project life cycle and become a subject matter expert for a project


• Write test plans, design test cases, develop test SQL scripts, test conditions, test procedures, and expected results


• Perform DWH and database testing


• Perform functional, regression, load, system, and user acceptance testing (UAT)


• Create large volumes of test data when required


• Track and report defects using tools such as JIRA


• Validate fixes and ensure follow-through across all test cycles


• Investigate and recommend remediation strategies for data quality conditions and process failures


• Communicate test status to internal project teams and clients

Requirements

• Minimum 3 years and maximum up to 6 years of experience


• Bachelor’s or Master Degree or equivalent Degree


• Experience and knowledge in DWH and Database Testing


• SQL and ETL testing knowledge


• Ability to debug differences and document identified issues


• Ability to understand requirements and translate them into test cases


• Proficiency with SQL language and Data Warehousing principles


• Knowledge of any ETL tool


• Experience with cloud technologies; AZURE preferred


• Experience with JIRA and Agile


• Good communication skills


• Basic-level certification in AWS, AZURE, or GCP


• Familiarity with cloud technologies


• Experience testing SOAP/API projects


• Stakeholder communication


• Microsoft Office proficiency

Core Competencies

Demonstrates expertise in DWH and Database Testing, with proficiency in SQL and ETL testing. Capable of managing the testing life cycle, including functional, regression, and user acceptance testing while ensuring effective communication with stakeholders.

Highest-signal resume keywords

• DWH Testing


• SQL Proficiency


• ETL Testing Knowledge


• JIRA Experience


• Cloud Technologies Familiarity

ATS Optimization Keywords

Hard Skills

• Database Testing


• Test Plan Writing


• Test Case Design


• Test SQL Script Development


• Functional Testing


• Regression Testing


• Load Testing


• User Acceptance Testing


• Defect Tracking


• Data Quality Investigation

Soft Skills

• Good Communication Skills


• Stakeholder Communication

Certifications & Qualifications

• Basic-Level Certification in AWS


• Basic-Level Certification in AZURE


• Basic-Level Certification in GCP

Industry Keywords

• Cloud Technologies


• Data Warehousing Principles


• SOAP Testing


• API Testing


• Agile Methodology

Tools & Technologies

• JIRA


• AZURE


• ETL Tools


• Microsoft Office