Database/ETL Testing

Dentsu Global Services; Pune District; On-site; INR 500,000 - 1,100,000; Full time

Job summary

Dentsu Global Services in Pune (IST shift) is seeking a QA tester to design and execute test plans for DWH/database testing. You will handle functional, regression, load, system, and UAT testing, creating large test data sets and tracking defects with Jira.

The role involves ensuring data quality, remediation, and clear communication with project teams and clients. Education requirements include a Bachelor's or Master's degree; AWS/Azure/GCP basic certs and Snowflake familiarity are a plus.

Qualifications

• Bachelor's or Master's degree or equivalent degree.
• Any basic level certification in AWS / AZURE / GCP.
• Snowflake Associate / Core Optional.

Responsibilities

• Write test plans, design test cases, develop test SQL scripts, test conditions, test procedures and expected results.
• Work on DWH / Database testing.
• Perform all aspects of testing, including functional, regression, load, system testing, and user acceptance testing (UAT).
• Create large volumes of test data if required.
• Track and reports defect using appropriate tools such as JIRA.
• Validate fixes and ensure follow through to all test cycles.
• Investigate and recommend remediation strategies for data quality conditions, and process failures.
• Communicate test status to internal project team and clients(s).

Skills

Test planning

Test case design

SQL scripting

DWH testing

Functional testing

Regression testing

UAT

JIRA

Data quality

Data remediation

Education

Bachelor's or Master's degree

Tools

AWS/Azure/GCP

Snowflake

Job description

• Write test plans, design test cases, develop test SQL scripts, test conditions, test procedures and expected results
• Work on DWH / Database testing
• Perform all aspects of testing, including functional, regression, load, system testing, and user acceptance testing (UAT)
• Create large volumes of test data if required
• Track and reports defect using appropriate tools such as JIRA
• Validate fixes and ensure follow through to all test cycles
• Investigate and recommend remediation strategies for data quality conditions, and process failures
• Communicate test status to internal project team and clients(s)

Job Description

Key Responsibilities

• Write test plans, design test cases, develop test SQL scripts, test conditions, test procedures and expected results
• Work on DWH / Database testing
• Perform all aspects of testing, including functional, regression, load, system testing, and user acceptance testing (UAT)
• Create large volumes of test data if required
• Track and reports defect using appropriate tools such as JIRA
• Validate fixes and ensure follow through to all test cycles
• Investigate and recommend remediation strategies for data quality conditions, and process failures
• Communicate test status to internal project team and clients(s)

Education Qualification

• Bachelor's or Master Degree or equivalent Degree

Certification If Any

• Any Basic level certification in AWS / AZURE / GCP
• Snowflake Associate / Core Optional

Shift timing

12 PM to 9 PM and / or 2 PM to 11 PM - IST time zone

Location:

DGS India - Pune - Indiqube Orchid

Brand:

Merkle

Time Type:

Full time

Contract Type:

Permanent#DGS