Job Overview:
The ETL Testing role involves the validation of data pipelines and processes that extract, transform, and load data.
As a ETL Test Engineer, you must be highly organized and detail-oriented, with strong analytical, problem solving, and prioritization skills. You should also be able to handle multiple tasks in a fast-paced, deadline-driven environment, both independently and as part of a team.
Responsibilities:
- Design and implement test plans for ETL processes.
- Writing and Executing Test Cases based on ETL mapping artifacts
- Data mining and detailed data analysis on data warehousing systems
- Validate data extraction, transformation, and loading for accuracy.
- Automate ETL testing processes using testing frameworks
- Execute formal test plans to ensure the delivery of data related projects
- Create SQL scripts based ETL mapping documents
- Test case design and creation - Proven ability to develop comprehensive test scenarios, test plans, and detailed test cases for complex data workflows
Qualification:
- Hands-on Experience in ETL Testing
- Python programming (required) - Strong proficiency for test automation and data validation
- ETL testing expertise - Deep understanding of Extract, Transform, Load processes and testing methodologies
- SQL Server proficiency - Ability to write complex queries, validate data integrity, and perform database testing
- Excellent written and verbal communication skills, interpersonal skills and team working skills
- Strong experience in analysing Requirements
- Experience of agile/Scaled Agile methodology, processes and tools such as Jira, ALM etc.
