ETL Specialist

Role: ETL Testing

Exp Level: 8+ Years

Location: Hyderabad

Mode of work: Work from office

Shift Timings: 3pm to 12am

Desired Job attributes:

• Bachelor’s 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.