IN_Senior Associate_ ETL Tester _OC Guidewire_ Advisory_ Kolkata at pwc

Kolkata, west bengal, India -

Full Time

Start Date

Immediate

Expiry Date

26 Dec, 25

Salary

0.0

Posted On

27 Sep, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

ETL Testing, Data Warehousing, Data Integration, SQL, Guidewire Insurance Suite, Data Validation, Automation Testing, Defect Management, Collaboration, Compliance, Analytical Skills, Problem-Solving, Attention to Detail, Cloud-Based Data Platforms, BI Tools, Programming Languages

Industry

Professional Services

Description

Line of Service Advisory Industry/Sector Not Applicable Specialism Guidewire 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 Guidewire developer at PwC, you will specialise in developing and customising applications using the Guidewire platform. Guidewire is a software suite that provides insurance companies with tools for policy administration, claims management, and billing. You will be responsible for designing, coding, and testing software solutions that meet the specific needs of insurance organisations. Why PWC At PwC, you will be part of a vibrant community of solvers that leads with trust and creates distinctive outcomes for our clients and communities. This purpose-led and values-driven work, powered by technology in an environment that drives innovation, will enable you to make a tangible impact in the real world. We reward your contributions, support your wellbeing, and offer inclusive benefits, flexibility programmes and mentorship that will help you thrive in work and life. Together, we grow, learn, care, collaborate, and create a future of infinite experiences for each other. Learn more about us. At PwC, we believe in providing equal employment opportunities, without any discrimination on the grounds of gender, ethnic background, age, disability, marital status, sexual orientation, pregnancy, gender identity or expression, religion or other beliefs, perceived differences and status protected by law. We strive to create an environment where each one of our people can bring their true selves and contribute to their personal growth and the firm’s growth. To enable this, we have zero tolerance for any discrimination and harassment based on the above considerations. Job Description & Summary: We are looking for a skilled ETL Tester with knowledge in Guidewire to join our dynamic team. The ideal candidate will have a strong background in data management with specific expertise in Guidewire Insurance Suite applications. You will be responsible for ensuring the quality and integrity of data as it is loaded from various sources into the data warehouse, with a particular focus on Guidewire-related data. Responsibilities: · Test Planning and Strategy: o Develop and document comprehensive test plans, test cases, and test scripts for ETL processes related to Guidewire implementations. o Define testing strategies, methodologies, and best practices to ensure the reliability and integrity of data within the Guidewire framework. · Guidewire Data Validation and Verification: o Perform data validation to ensure that ETL processes involving Guidewire products (PolicyCenter, BillingCenter, ClaimCenter) are functioning as expected. o Verify that data is accurately extracted from Guidewire systems, transformed correctly, and loaded into the target data warehouse or data marts. · Test Execution: o Execute test cases and scripts to identify defects, inconsistencies, and issues in the ETL processes related to Guidewire data. o Conduct functional, integration, regression, and performance testing on Guidewire-related ETL processes. · Defect Management: o Identify, document, and track defects and inconsistencies specific to Guidewire data. o Collaborate with ETL developers and data engineers to resolve identified issues. · Automation: o Develop and maintain automated test scripts using appropriate testing tools and frameworks. o Implement and manage automated testing processes to enhance efficiency and coverage, with a focus on Guidewire-related data. · Analysis and Reporting: o Analyze test results and provide detailed reports on testing activities, including metrics and KPIs related to Guidewire data. o Communicate findings, risks, and recommendations to stakeholders. · Collaboration: o Work closely with data architects, data analysts, developers, and business stakeholders to understand data requirements and ensure alignment with business goals. o Participate in design and code reviews to provide insights from a testing perspective, especially for Guidewire implementations. · Compliance and Quality Assurance: o Ensure that ETL processes comply with data governance and quality standards. o Continuously improve testing processes and methodologies to enhance quality and efficiency, particularly for Guidewire data. Mandatory skill sets: · 3+ years of experience in ETL testing, data warehousing, and data integration. · Proficiency in SQL and experience with database technologies (e.g., Oracle, SQL Server, MySQL). · Strong understanding of ETL concepts, tools (e.g., Informatica, Talend, SSIS), and data warehousing. · Experience with Guidewire Insurance Suite applications (PolicyCenter, BillingCenter, ClaimCenter). · Excellent analytical, problem-solving, and debugging skills. · Strong attention to detail and ability to work in a fast-paced environment. · Familiarity with JIRA for issue tracking and project management. · Familiarity with Confluence for documentation and collaboration. Preferred skill sets: · Experience with any cloud-based data platforms (e.g., AWS Redshift, Google BigQuery, Azure Synapse). · Knowledge of any programming languages such as Python or Java. · Familiarity with BI tools (e.g., Tableau, Power BI). · Certification in testing or data-related fields (e.g., ISTQB, Certified Data Management Professional). · Guidewire certification or relevant training in Guidewire products. · Experience with automation testing tools and frameworks (e.g., Selenium, QTP, JUnit). Years of experience required: 3-6 years Education qualification: B.Tech. / B.E. / MCA / M.Tech Education (if blank, degree and/or field of study not specified) Degrees/Field of Study required: Bachelor of Technology, Bachelor of Engineering Degrees/Field of Study preferred: Certifications (if blank, certifications not specified) Required Skills Extract Transform Load (ETL) Optional Skills Accepting Feedback, Active Listening, Analytical Thinking, Communication, Creativity, Embracing Change, Emotional Regulation, Empathy, Guidewire BillingCenter, Guidewire BillingCenter Configuration, Guidewire ClaimCenter, GuideWire Integration, Inclusion, Intellectual Curiosity, Learning Agility, Optimism, PolicyCenter (Software), Self-Awareness, Software Development, Software Development Methodology, System Development, Teamwork, Well Being Desired Languages (If blank, desired languages not specified) Travel Requirements Available for Work Visa Sponsorship? Government Clearance Required? Job Posting End Date Are you ready to make a difference? Want to unlock new value by applying your unique perspective and talents? You can grow exponentially at PwC. Here, you can uncover hidden talents, build lifelong relationships rooted in trust and empathy and turn challenges into opportunities for innovation. We’ll help you grow your skills through challenging, meaningful work so you can go further.

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The ETL Tester will develop and document comprehensive test plans and execute test cases to ensure the quality and integrity of data related to Guidewire implementations. They will collaborate with developers and data engineers to resolve defects and enhance testing processes.