ETL Testing - Sr.Associate

Industry/Sector

Insurance

Specialism

Functional & Industry Technologies

Management Level

Senior Associate

Job Description & Summary

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.

As a business application consulting generalist at PwC, you will provide consulting services for a wide range of business applications. You will leverage a broad understanding of various software solutions to assist clients in optimising operational efficiency through analysis, implementation, training, and support.

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.

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 Firm's code of conduct, and independence requirements.

Education Qualification - BTech/BE/MTech/MS/MCA/MBA.

Total Experience – 5 to 10 years

Overview - A career in Insurance Transformation and Modernization using cutting-edge technologies for ETL Policy conversion aimed to solve our client’s most critical business challenges. You will play a vital role in improving operational efficiency, enhancing customer experience, and enabling innovation through the implementation of advanced technologies and streamlined workflows. You will work closely with cross-functional teams, assess current systems, analyze, and design the future state system, develop modernization strategies, and oversee the successful execution of transformation projects.

Roles and

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.
• Preferred Skill Set -
• 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

Travel Requirements

Not Specified

Job Posting End Date