ETL QA

Designation

Qualifications

Experience

Location

Shift timings

Job Description:

Desired Job attributes:

• Bachelors degree in computer science, Engineering, or a related field.
• Proven experience as a ETL/SQL QA Tester or similar role.
• Thorough knowledge with ETL(extract, transform, load) process and validation points within the process.
• Experience in executing jobs in ETL software, such as Databricks or DataStage.
• Data testing, Testing in large datasets, Missing data, Duplicate data, Data from different sources Structural errors, Data attribute validations
• Strong in SQL query writing skills.
• Strong knowledge of software testing methodologies, tools, and processes.
• Familiarity with Agile development methodologies.
• Excellent analytical and problem-solving skills.
• Strong attention to detail and ability to work independently.
• Excellent communication and collaboration skills.
• Ability to prioritize and manage multiple tasks and projects simultaneously.
• Experience with test automation tools and frameworks is a plus.
• Fluent English - written and spoken; second foreign language is an advantage.

Roles and Responsibilities:

• Develop and execute test plans,test cases, and test scripts to ensure the quality of our software products.
• Tests complex ETL processes using SQL queries, web and windows-based applications that reference database back-end systems.
• Must be able to write SQL query/Stored Procedure and able to test application at backend level.
• Execute and troubleshoot automated functional, API, and end-to-end tests.
• Identify and document any defects or issues found during testing, and work with the development team to resolve them.
• Collaborate with the development team to understand the requirements and functionality of the software being tested.
• Conduct thorough Source-destination data testing to ensure that any changes or updates to the ETL processes do not introduce new issues.
• Perform manual testing of software applications, including functional, integration, system, and user acceptance testing.
• Collaborate with cross-functional teams to ensure that all aspects of the software development life cycle are properly tested and validated.