Line of Service Advisory Industry/Sector Not Applicable Specialism Product Innovation Management Level Senior 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.

Focused on relationships, you are building meaningful client connections, and learning how to manage and inspire others. Navigating increasingly complex situations, you are growing your personal brand, deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients, and to deliver quality. Embracing increased ambiguity, you are comfortable when the path forward isn't clear, you ask questions, and you use these moments as opportunities to grow.

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

• Respond effectively to the diverse perspectives, needs, and feelings of others.
• Use a broad range of tools, methodologies and techniques to generate new ideas and solve problems.
• Use critical thinking to break down complex concepts.
• Understand the broader objectives of your project or role and how your work fits into the overall strategy.
• Develop a deeper understanding of the business context and how it is changing.
• Use reflection to develop self awareness, enhance strengths and address development areas.
• Interpret data to inform insights and recommendations.
• Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), 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

Travel Requirements Not Specified Available for Work Visa Sponsorship? No Government Clearance Required? No Job Posting End Date February 19, 2025