Etl/SQL Tester

4 days ago

Sydney Central Business District, Australia HAYS Full time

Good pay rate - Leisure and leaning industry - Good working environment

**Your new company**

An international company that invests in Leisure and learning industry throughout Australia.

**Your new role**
- Developing test plans, test run sheets and test scripts.
- Hands-on testing experience in all aspects of testing, including functional, system integration, End to End, User Acceptance, Regression and Performance
- Identify and define test cases for data migration/integration, validate data transformations in line with data mapping artifacts.
- Execute manual testing using SQL, JIRA, and Excel, perform defect analysis and logging, document and manage defects to resolution.
- Create/Modify the SQL test scripts as per the ETL mapping documents and technical specifications & requirements.
- Create/Update the RTM if applicable and Query log with test cases and test data.
- Record and maintain testing evidence and track execution status of assigned test cases.
- Ability to effectively prioritize and execute tasks in a consistently changing environment
- Produce relevant technical documentation in accordance with SDLC.
- Experience in Microsoft Azure SQL server and Azure DevOps
- Self-managing resource with at least 3 years of experience on database testing, data migration, data reconciliation, and data integrity testing (ETL/ELT approach)
- Strong SQL skills to validate data from multiple sources like JSON, XMLs, CSV, and Databases (SQL Server, CosmosDB)

**What you'll need to succeed**
- Minimum 3 years of experience in: a) Microsoft SQL Server. b) Delivery of large scale, information management, information governance and analytics solutions.
- Minimum 3 years of experience with Microsoft BI stack (SSAS, SSIS).
- Experience working with SQL including creating stored procedures, views, and indexes as well as performance tuning queries.
- Experience and understanding of Business Intelligence (BI), Data/Analytics, Reporting, Data Integration and Master Data Management.
- Able to read and understand complex transformation rules in the mapping document/ETL Packages
- Understanding of BI tools including Power BI.
- Experience using Azure DevOps release pipelines
- Strong analytical, problem-solving and communication skills.
- Previous exposure in data migrations is a plus
- Ability to work in a fast-paced team environment.

**What you'll get in return**

A good Pay Rate available and a chance to work in a great environment. A chance to work in a good company culture who support growth and progression.

**What you need to do now**

If this job isn't quite right for you but you are looking for a new position, please contact us for a confidential discussion on your career.

Navita.

Recruitment partner at Hays.

**LHS 297508** #2718519

  • Etl Testers

    7 days ago

    Sydney, Australia GoTech Solutions Pty Ltd Full time

    **About Us**: GOSOL, IT consulting and Staffing organization, can help you enhance Technology, Digital, Project and Business Transformation. Guided by integrity and trust, we believe in offering an unparalleled experience as your Tech of choice. For businesses, this means providing you with access to the quality solution. - Sound experience in ETL and...

  • Etl Tester

    3 days ago

    Sydney, Australia GoTech Solutions Pty Ltd Full time

    **About Us**: GOSOL, IT consulting and Staffing organization, can help you enhance Technology, Digital, Project and Business Transformation. Guided by integrity and trust, we believe in offering an unparalleled experience as your Tech of choice. For businesses, this means providing you with access to the quality solution. - Sound experience in ETL and...

  • SQL Tester/qa

    4 days ago

    Sydney Central Business District, Australia HAYS Full time

    SQL Tester - Contract - 3 months Your new role: As, Test Engineer you will be responsible for manual testing of features and functionalities as well as automation testing and integration, coordinating with development/data engineering groups for various testing and providing analysis and reports to stakeholders. You will be working across an AWS migration...

  • Etl Tester

    3 days ago

    Sydney, Australia Delivery Centric Technologies Full time

    **Role: ETL Tester** **Location: Sydney** - **Data Migration and Data Warehousing Testing**: Conduct thorough testing of data migration and data warehousing processes to ensure data integrity, accuracy, data encryption etc. - **SQL Query Writing**: Develop and execute complex SQL queries to validate data transformations - **Test Automation**: Utilize Python...

  • Senior ETL Tester

    4 days ago

    Sydney, New South Wales, Australia beBeeData Full time $128,191 - $136,132

    Senior ETL TesterJob Title:We are looking for a Senior ETL Tester to join our organization.Job Description:End-to-End Data Testing ExpertAs a seasoned ETL testing professional, you will be responsible for ensuring the quality and accuracy of data across multiple applications and releases in various data programs.Key Responsibilities:Manage and handle...

  • Etl Testers

    2 weeks ago

    Sydney, Australia Ampion Full time

    Discounted Insurance & Paid Maternity Leave - Flexible working arrangement., Sydney/ Melbourne - High profile projects | Great team environment **BE PART OF OUR EVOLUTION** Welcome to Ampion a Wipro company. Ampion is a technology services provider delivering a new level of specialization at scale. As an independent subsidiary of Wipro, we deliver...

  • Etl Test Analyst

    7 days ago

    Sydney, Australia CareCone Australia Full time

    **Role - ETL Test Analyst** **Location: Sydney** **Experience require: Only 5-8 years** **Major Skill Set: ETL Tester with SQL and data migration** **Job Type: Permanent** **Job Type**: Permanent **Salary**: $120,000.00 - $135,000.00 per year Schedule: - 8 hour shift Ability to commute/relocate: - Sydney, NSW: Reliably commute or planning to...

  • Etl Testers

    7 days ago

    Sydney, Australia Zone IT Solutions Full time

    We are looking for ETL Test Consultants for a permanent role in Sydney. **Requirements**: - A solid understanding of the SDLC with the demonstrated ability to define test conditions for given requirements. - Design test cases and create test scripts and supporting data, working to the specifications provided. - Interpret, execute and record test cases in...

  • Etl Tester

    2 weeks ago

    Sydney, Australia innovate it Full time

    . A minimum of 4 plus years ETL testing and knowledge on Teradata, Hadoop, Hive, SQL - Participating in design reviews and providing input on requirements, product design, and potential problems. Preparation/review of test plans/test cases. Note - Hiring for Australian PR, Citizens and full work right holders **Salary**: $90,609.87 - $110,177.65 per...

  • ETL Tester

    7 hours ago

    Sydney, New South Wales, Australia N2S Full time

    Delivery Lead - Recruitment at Net2Source Inc.Responsibilities5+ years of hands-on experience with Data Warehouse / ETL testing.Good experience with Match, Merge, and Survivorship rules.Extensive experience in Manual Testing, Database Testing, ETL Testing. Understand the behavior of complex data warehousing and business intelligence solutions and apply that...