Delivery Centric is seeking a highly skilled ETL Test Engineer to join our Sydney team. The ideal candidate will have extensive experience in ETL testing, data warehousing, and SQL scripting, ensuring accurate and high-quality outcomes for complex enterprise projects. In this role, you will collaborate with development, QA, and data teams to validate data transformations, integrity, and reporting across multiple platforms, including Informatica and Snowflake. You will play a crucial role in implementing automated testing approaches and ensuring adherence to software development lifecycle best practices.
Key Responsibilities
- Design, develop, and execute ETL test scenarios, test cases, and procedures for enterprise projects.
- Validate data transformation, data quality, and reporting accuracy across data warehouses and ETL pipelines.
- Perform ETL testing using tools like Informatica PowerCenter and Snowflake.
- Write and maintain SQL scripts to verify data transformations and integrations.
- Monitor and validate ETL processes using Control-M or similar job schedulers.
- Collaborate with development and QA teams to identify, log, and resolve defects using JIRA and Confluence.
- Support automated regression testing for ETL workflows to ensure reliability and performance.
- Ensure adherence to software development lifecycle processes and version control tools such as Azure DevOps and GitHub.
- Contribute to documentation, best practices, and knowledge sharing within the team to improve testing efficiency.
Qualifications
- Proven experience in ETL testing with Informatica and Snowflake.
- Strong SQL scripting and ETL technical expertise.
- Familiarity with job scheduling and control processes (e.g., Control-M).
- Hands-on experience with JIRA, Confluence, Azure DevOps, and GitHub.
- Deep understanding of data warehousing concepts, ETL processes, and automated regression testing.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work independently and collaboratively in a fast-paced enterprise environment.
At Delivery Centric, you will be part of a high-performing team delivering enterprise data solutions that drive impactful business outcomes. You will have the opportunity to work on complex ETL projects, implement automated testing strategies, and collaborate with skilled professionals, all while developing your expertise in data warehousing, quality assurance, and advanced ETL tools. This is a role where technical excellence, innovation, and continuous improvement are highly valued.