Job Opportunity: ETL Data Analyst
We are seeking an experienced Senior ETL Test Analyst to work with our team.
* A solid understanding of testing principles and practices is essential for this role.
* The ideal candidate will have relevant testing experience in Functional, System Integration, Regression, and E2E testing.
* Experience testing web-based, client-server, and batch applications is a must.
* The selected candidate should understand requirements and data models.
* Involvement in preparing ETL/DW test strategies and approaches is necessary.
* Preparation of test cases and SQL scripts for data migration testing is required.
* API testing experience with SOAP and Restful services is desirable.
* Knowledge of JSON, XML, and Swagger files is a plus.
* The ability to write stubs for testing purposes is beneficial.
* Excellent Excel skills for solving complex problems with large datasets are necessary.
* Strong experience with RDBMS, preferably Oracle/SQL Server, including writing complex queries and verifying functions/stored procedures.
* Advanced knowledge of SQL database commands, query formation, and execution is required.
* Familiarity with automation tools such as Selenium, QTP, SoapUI, and Atlassian products like JIRA, Confluence, and Bamboo is a bonus.
* Experience with test management tools such as Quality Center, ALM, ServiceNow, or PractiTest is advantageous.
* The ability to understand complex concepts and interpret detailed documentation to derive quality test scenarios is crucial.
* Good communication skills for IT delivery coordination and team management are necessary.
* The successful candidate should be self-motivated and capable of working independently.
This role requires a minimum of 8-9 years of strong ETL and SQL testing skills. The selected candidate must have full work rights and be based in Sydney.