ETL+QA Testing +SQL - Hyderabad

Cloudxtreme; Hyderabad; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Cloudxtreme in Hyderabad seeks an experienced ETL QA tester to plan, execute, and coordinate testing across data migration and BI reporting projects. You will validate data quality, write complex SQL, and ensure production readiness through thorough test analyses.

The role requires 5-7 years in ETL testing, strong SQL skills, and knowledge of Data Warehousing concepts, with familiarity in UFT, TFS, Azure, DB2, and SAP.- related enterprise tools.

Qualifications

• 5-7 yrs of ETL testing experience is required.
• Proficient in SQL queries for data validation and mapping checks.
• Knowledge of Data Warehousing concepts and BI report testing.
• Experience with ETL tools like UFT or similar and knowledge of enterprise data sources.

Responsibilities

• Plan, develop, and coordinate testing activities including test plan and test case creation.
• Execute test scenarios and analyze results to ensure quality before production.
• Collaborate with on-site teams to ensure timely test phases.
• Validate data quality during migrations; write complex SQL for validation.
• Perform schema validations and verify SCD types and data mappings.
• Monitor defect management and raise risks with clear mitigation actions.

Skills

ETL testing

SQL

Data warehousing

BI reports testing

DB2

HANA

SCD types

Complex SQL

Tools

UFT

TFS

Azure

DB2

HANA

Job description

Role & responsibilities

Role Specific Responsibilities:

• Responsible for planning, developing, and coordinating testing activities including
• Test Plan creation, Test Case creation, debugging, execution, test analysis.
• Responsible for the execution of test scenarios in support of the test team.
• Familiarize themselves with the business functionality and technology used for assigned applications (under test).
• Utilize ETL QA testing tools, methodologies, and processes.
• Work closely with on-site team towards successful test phases.
• Encourage collaborative efforts and camaraderie with other Release Stream team areas.
• Ensure the quality and low bug rates of code released into production.
• Responsible for successful execution and alerting team leads and managers of obstacles, issues, and risks.
• Able discuss status of all open issues facing the test team and describes actions taken to mitigate such issues
• Responsible for coordinating/engaging build movements to the QA environment as directed by Team Lead.

Technical Skills and Qualifications

5-7 yrs of Experience in ETL testing.

Demonstrates an understanding and working experience on SQL databases and ETL testing. Should be able to write queries to validate the table mappings and structures

• Should be able to perform schema validations
• Good understanding of SCD types
• Strong knowledge of database methodology
• In-depth understanding of Data Warehousing/Business intelligence concepts
• Working experience in testing BI reports
• Should be able to write queries to validate the data quality during migration projects
• Demonstrates an understanding of any of the peripheral technologies utilized in SDC, including Peoplesoft, SAP and Aderant.
• Demonstrates a working understanding of tools like UFT and TFS
• Experience with Microsoft tools is highly desired
• Understands enterprise-wide networks and software implementations.
• Must have previous experience in creating complex SQL queries for data validation.
• Must have testing experience in Enterprise Data Warehouse (EDW)
• Good to have Reports testing experience
• Good to have working knowledge on Azure, DB2, HANA, SQL databases.
• Demonstrates a working understanding of planning, developing, and coordinating testing activities including Test Plan creation, Test Case creation, debugging, execution, test analysis.
• Demonstarte an understanding on the estimation techaniques and QA plan
• Demonstrates analytical skills in assessing user, functional and technical requirements
• Demonstrates a working understanding of functional testing techniques and strategies.
• Demonstrates a working understanding of test analysis and design.
• Demonstrates a working understanding of analyzing test results and the creation of appropriate test metrics.
• Demonstrates a working understanding of the defect management process.
• Demonstrates an ability to provide accurate project estimates and timelines.
• Demonstrates an ability to deliver on project commitments.
• Produces work that consistently meets quality standards.
• Demonstrates the ability to operate as the primary resource on a project

Preferred candidate profile