Apply now »

Senior Quality Analyst - ETL

Req ID:  53343

Bangalore, IN

Location: Bangalore, India


Sapiens International Corporation (NASDAQ and TASE: SPNS) is a leading global provider of software solutions for the insurance industry, with a growing presence in the financial services sector. We offer integrated core software solutions and business services, and a full digital suite for the property and casualty/general insurance; life, pension, and annuities; and reinsurance markets. Sapiens also services the workers’ compensation and financial and compliance markets.

Our portfolio includes policy administration, billing, and claims; underwriting, illustration and electronic application; reinsurance and decision management software. Sapiens’ digital platform features customer and agent portals, and a business intelligence platform. With a 40-year track record of delivering to more than 600 organizations, Sapiens’ team of over 5,400 operates through our fully-owned subsidiaries in North America, the United Kingdom, EMEA, and Asia Pacific. For more information:

Job Description:

Roles & Responsibilities:

  • Conduct BI/DWH Testing;
  • Understanding insurance business process and the Business Requirements
  • Preparing Functional/Technical Specifications.
  • Design test cases for all scenarios (i.e. positive, negative testing, boundary) including expected outputs from the Business Requirements and Functional to ensure maximum coverage.
  • Verify requirement traceability from System Requirements through test cases and defects
  • Validate Test Preparation and verify all teams are aligned with what needs to occur to build/prepare the test plan
  • Validate the Data against source and target on various platforms / layers
  • Update & maintain documentation of the executed test cases
  • Proficient in converting complex business rules to SQL test scripts.
  • Proficient in test data creation
  • Proficient in Test management tools, HP AL, Jira - Zephyr.


Requirement: -

  • Overall 5 to 9 years of experience in DWH and Report software testing.
  • Understanding insurance business process and the Business Requirements and Functional/Technical Specifications.
  • Strong hands an End to End experience in ETL Testing, Report Testing.
  • Proficient in converting business scenarios into SQL queries.
  • Should be involved in designing and preparing Test Scenarios, Test Plans, Test Strategies, Test Cases, Test Data
  • Should have experience in Test Management tool - HP ALM, Jira
  • Should have experience in SDLC & STLC
  • Good Analytical and communication skills.
  • Automation experience in any open source platform is plus
  • Experience in Big Data Testing is plus
  • ISTQB Certified is a plus
  • Prior Insurance industry experience is a plus
  • Any Scripting language python /java is a plus

Apply now »