Quality Engineer - Associate

Line of Service

Industry/Sector

Specialism

Management Level

Job Description & Summary

To really stand out and make us fit for the future in a constantly changing world, each and every one of us at PwC needs to be an authentic and inclusive leader, at all grades/levels and in all lines of service. To help us achieve this we have the PwC Professional; our global leadership development framework. It gives us a single set of expectations across our lines, geographies and career paths, and provides transparency on the skills we need as individuals to be successful and progress in our careers, now and in the future.

As an Associate, you'll work as part of a team of problem solvers, helping to solve complex business issues from strategy to execution. PwC Professional skills and responsibilities for this management level include but are not limited to:

• Invite and provide evidence-based feedback in a timely and constructive manner.
• Share and collaborate effectively with others.
• Work with existing processes/systems whilst making constructive suggestions for improvements.
• Validate data and analysis for accuracy and relevance.
• Follow risk management and compliance procedures.
• Keep up-to-date with technical developments for business area.
• Communicate confidently in a clear, concise and articulate manner - verbally and in written form.
• Seek opportunities to learn about other cultures and other parts of the business across the Network of PwC firms.
• Uphold the firm's code of ethics and business conduct

JOB DESCRIPTION – ETL Testing

REQUIRED EXPERIENCE:

MUST HAVE

• 3-5 years of experience in ETL and Data Warehouse testing on GCP 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
• 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
• Works closely with software development team (Business Analysts, Developers & other testers) to ensure timely and effective testing effort
• Ensure all sign offs on deliverables (overall test strategy, 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.

      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)

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Available for Work Visa Sponsorship?

Government Clearance Required?

Job Posting End Date