FIT - ETL QA - Associate 2

At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency. These individuals analyse client needs, implement software solutions, and provide training and support for seamless integration and utilisation of business applications, enabling clients to achieve their strategic objectives. Those in Guidewire testing at PwC will specialise in testing and quality assurance activities related to Guidewire applications. Guidewire is a software suite that provides insurance companies with tools for policy administration, claims management, and billing. You will be responsible for confirming that the Guidewire applications meet the desired quality standards and perform as expected.

Enhancing your leadership style, you motivate, develop and inspire others to deliver quality. You are responsible for coaching, leveraging team member’s unique strengths, and managing performance to deliver on client expectations. With your growing knowledge of how business works, you play an important role in identifying opportunities that contribute to the success of our Firm. You are expected to lead with integrity and authenticity, articulating our purpose and values in a meaningful way. You embrace technology and innovation to enhance your delivery and encourage others to do the same.

Skills

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

• Analyse and identify the linkages and interactions between the component parts of an entire system.
• Take ownership of projects, ensuring their successful planning, budgeting, execution, and completion.
• Partner with team leadership to ensure collective ownership of quality, timelines, and deliverables.
• Develop skills outside your comfort zone, and encourage others to do the same.
• Effectively mentor others.
• Use the review of work as an opportunity to deepen the expertise of team members.
• Address conflicts or issues, engaging in difficult conversations with clients, team members and other stakeholders, escalating where appropriate.
• Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), the Firms code of conduct, and independence requirements.
  
  

The Opportunity

When you join PwC Acceleration Centers (ACs), you step into a pivotal role focused on actively supporting various Acceleration Center services, from Advisory to Assurance, Tax and Business Services. In our innovative hubs, you’ll engage in challenging projects and provide distinctive services to support client engagements through enhanced quality and innovation. You’ll also participate in dynamic and digitally enabled training that is designed to grow your technical and professional skills.

As part of the ETL Testing team you engage in both automation and manual testing to maintain quality assurance in our projects. As an Associate, you focus on learning and contributing to client engagement and projects while developing your skills and knowledge to deliver quality work. You are exposed to clients to learn how to build meaningful client connections, manage and inspire others, and grow your personal brand by enhancing your technical knowledge of firm services and technology resources. You work on projects related to systems configurations within the Insurance industry, leveraging tools like the ETL Testing Framework and object-oriented programming.

Responsibilities

• Conducting Gap Analysis and feasibility analysis during the project inception phase.
• Work with the business stakeholders to rationalize and prioritize the business requirements.
• Understanding and analyzing business expectations and conducting workshops that may involve multiple stakeholders, elicit & document requirements.
• Should have effective storytelling and communication skills to various audiences (written and verbal).
• Analyze the impact of business requirements changes to the project.
• Analyze client requirements.
• Understanding the features, functions, and capabilities of packaged solutions to achieve proper business requirements alignment and adaptation to package as needed.
• Participate in scrum calls and provide status reports.
• Take part in CoE activities, trainings, recruitments as required and interested.
  
  

What You Must Have

• Bachelors Degree
• 2 years of experience
• Automation and Manual Testing
• ETL QA Background
• Oral and written proficiency in English required
  
  

What Sets You Apart

• Candidate should have Guidewire Property & Casualty insurance product (PC, BC or CC) knowledge.
• Strong understanding of SQL & data concepts.
• Participate and provide clarifications about data anomalies and data distribution information for data mapping sessions during iterations for the user story backlog.
• Document detailed Source to Target Data Mapping for Legacy to GWPC such as GW Entities, Type lists, Transformation rules, valid values, data types, etc.
• Reference data analysis and fitment to Guidewire Type lists, provide observations to project team.
• Experience working on data analysis, data modeling and updating data specifications mapping documents.
• Manage data mapping, data transformation logic, de-duplication rules, and business logic.
• Review and hand-off with offshore developers regarding User story Acceptance Criteria, expected system functionality, data mapping requirements & business rules
• Collaborate with development, QE and Test Data Management to ensure test data is created to meet the Acceptance criteria for feature testing.
• Provide support to developers for defect triaging.
• Ability to write SQL with joins and usage of database functions /scripts.
• Working knowledge of agile

---