Etl/SQL Tester

4 hours 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 Tester

    2 weeks ago

    Sydney, Australia City People Solutions Full time

    ETL Tester - Sydney/Melbourne - Immediate Start We are looking for an ETL Tester to join our team. Job description: - Understand the requirements and data models - Involve in preparation of ETL/DW test strategy and approaches - Prepare test cases and SQL scripts for data migration testing - Automation of test cases - Test execution and result reporting -...

  • Etl Tester

    2 weeks ago

    Sydney, Australia Delivery Centric Technologies Full time

    **ETL Tester / Senior Test Analyst** **Primary Skills - Teradata & Bigdata** **Secondary Skills - Unix, Informatica, Tableau ,Control M** **Location: Sydney** **Experience: 3+ years** **Mode of Hiring: Permanent/FTC**: - 3-5 years of experience hands on experience with Data warehouse/ETL testing. - Strong SQL/PL-SQL skills to write complex SQL queries for...

  • Etl Testers

    2 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

    5 days ago

    Sydney, New South Wales, Australia CareCone Group Full time $100,000 - $150,000 per year

    Role- ETL TesterType- PermanentLocation- SydneyDescription:-5+ years of hands on experience with Data warehouse / ETL testing.Good experience on Match, Merge, Survivorships rules.Extensive Experience in Manual Testing, Database Testing, ETL Testing. Understand the behavior of complex data warehousing and business intelligence solutions and apply that...

  • SQL Tester/qa

    4 hours 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

    2 weeks ago

    Sydney, New South Wales, Australia FR Consultancy Full time $90,000 - $120,000 per year

    Role:ETL TesterType:Full time – Perm or ContractLocation:Sydney, AUStatus:Valid AU visa holdersSkills:ETL Testing, Data, Informatica, SnowflakeExperience:6+ yearsRequisites:Hands-on experience in ETL Testing - Large dataInterested?Please apply, thanks for your interest and time.

  • ETL Tester

    5 days ago

    Sydney, New South Wales, Australia Delivery Centric Full time $80,000 - $120,000 per year

    Role: ETL TesterLocation: SydneyJob Description: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 transformationsTest Automation: Utilize Python or other...

  • Etl Testers

    1 week 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

    2 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 Tester

    4 days ago

    Sydney, New South Wales, Australia PibyThree Full time $90,000 - $120,000 per year

    Key ResponsibilitiesDevelop, execute, and maintain test cases, test scripts, and test data for MDM and ETL processes.Validate Informatica ETL processes to ensure accuracy, performance, and compliance with business rules.Perform end-to-end testing of MDM workflows including data ingestion, cleansing, consolidation, survivorship, and publishing.Collaborate...