INSenior Associate ETL Tester TC Guidewire AdvisoryKolkata
INSenior Associate ETL Tester TC Guidewire AdvisoryKolkata
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Line of Service
AdvisoryIndustry/Sector
Not ApplicableSpecialism
OperationsManagement Level
Senior AssociateJob 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.
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 Guidewirerelated 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 : 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 Guidewirerelated 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 Guidewirerelated 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 problemsolving and debugging skills. Strong attention to detail and ability to work in a fastpaced environment. Familiarity with JIRA for issue tracking and project management. Familiarity with Confluence for documentation and collaboration.
Preferred skill sets:
Experience with any cloudbased 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 datarelated 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:
36 years
Education qualification:
. / B.E. / MCA /
Education (if blank degree and/or field of study not specified)
Degrees/Field of Study required: Bachelor of Technology Bachelor of EngineeringDegrees/Field of Study preferred:Certifications (if blank certifications not specified)
Required Skills
ETL (Extract Transform Load) TestingOptional 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) SelfAwareness Software Development Software Development Methodology System Development Teamwork Well BeingDesired Languages (If blank desired languages not specified)
Travel Requirements
Not SpecifiedAvailable for Work Visa Sponsorship
NoGovernment Clearance Required
NoJob Posting End Date
Required Experience:
Senior IC
Employment Type
Full-Time
