Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Product Innovation

Management Level

Associate

Job Description & Summary

At PwC, our people in software and product innovation focus on developing cutting-edge software solutions and driving product innovation to meet the evolving needs of clients. These individuals combine technical experience with creative thinking to deliver innovative software products and solutions.

In quality engineering at PwC, you will focus on implementing leading practice standards of quality in software development and testing processes. In this field, you will use your experience to identify and resolve defects, optimise performance, and enhance user experience.

Driven by curiosity, you are a reliable, contributing member of a team. In our fast-paced environment, you are expected to adapt to working with a variety of clients and team members, each presenting varying challenges and scope. Every experience is an opportunity to learn and grow. You are expected to take ownership and consistently deliver quality work that drives value for our clients and success as a team. As you navigate through the Firm, you build a brand for yourself, opening doors to more opportunities.

Examples of the skills, knowledge, and experiences you need to lead and deliver value at this level include but are not limited to:

Apply a learning mindset and take ownership for your own development.Appreciate diverse perspectives, needs, and feelings of others.Adopt habits to sustain high performance and develop your potential.Actively listen, ask questions to check understanding, and clearly express ideas.Seek, reflect, act on, and give feedback.Gather information from a range of sources to analyse facts and discern patterns.Commit to understanding how the business works and building commercial awareness.Learn and apply professional and technical standards (e.g. refer to specific PwC tax and audit guidance), uphold the Firm's code of conduct and independence requirements.

JOB DESCRIPTION – ETL Testing 

REQUIRED EXPERIENCE: 
 
MUST HAVE  

  

3-5 years of experience in ETL and Data Warehouse testing on GCP (or any cloud) platform 

Knowledge of any automated testing tool is preferred 

Proficient in writing SQL Queries to extract data as per the test cases and perform data comparison 

Create SIT test cases/test data and perform Test execution 

Works closely with software development team (Business Analysts, Developers & other testers) to ensure timely and effective testing effort 

Ensure all sign offs on deliverables (test plan, test cases) and that testing meets governance requirements 

Solid understanding of databases and systems and the ability to communicate effectively across groups 

Self-Starter, with strong confidence level 

Flexible in thought and creative in approach to testing 

Experienced in an Onshore/Offshore model, ability to work independently and with a team. 

Excellent Communication, Analytical and Problem-solving skills 

 

 

PREFERRED / GOOD TO HAVE 

Knowledge of ETL automation tool such as Query surge 

Basic understanding of big data technologies 

Cloud technology knowledge/experience – Azure, AWS, GCP 

Experience in various databases – Oracle, Teradata, Snowflake etc. 

Knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions and facts 

Review Data Models, Data Mappings, Architectural Documentation to create/execute effective SIT Test Plans and SIT test cases 

Analyzes and troubleshoots erroneous results, determines the root cause of defects, logs the defects in HP Quality Center/ALM/Jira or other Test Management tool and enables defect management, including working with the development team on the resolution of Software related defects 

 

 

      ROLES / RESPONSIBILITIES: 

Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities 

Gather requirements and business process knowledge to transform the data in a way that’s geared towards the needs of end users 

Maintain and improve already existing processes 

Ensure that the data architecture is scalable and maintainable 

Work with the business in designing and delivering correct, high-quality data 

Investigate data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions 

 

 

 

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required:

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Communication, Compatibility Testing, Defect Reporting, Emotional Regulation, Empathy, Functional Testing, Inclusion, Intellectual Curiosity, Optimism, Performance Testing, Post Go Live Support, Process Improvement, QA Methodologies, Quality Assurance Engineering, Quality Assurance Metrics, Quality Assurance Process Design, Quality Assurance Process Evaluation, Quality Assurance Process Management, Quality Assurance Testing, Quality Control Testing, Quality Engineering, Quality Management {+ 14 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date

February 23, 2025