Share this Job
Apply now »


Req ID:  38006

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 35-year track record of delivering to more than 500 organizations, Sapiens’ team of over 4,000+ operates through our fully-owned subsidiaries in North America, the United Kingdom, EMEA, and Asia Pacific. For more information:


Roles & Responsibilities:

·        Work with business users to clarify ETL requirements and business rules

·        Understand pre-designed insurance-specific target data models, meta data layer and data marts and ETL processes

·        Design, develop, implement, and assist in validating ETL processes

·        Create and execute unit test plans based on system and validation requirements.

·        Troubleshoot, optimize, and tune ETL processes.

·        Maintain existing code and fix bugs

·        Ensure that all timelines of loading/validating data are met

·        Ensure smooth functioning of development, staging and production environments

·        Ability to research and analyze data and processing issues or inquiries as they arise.

·        Demonstrate strong analytical skills to implement solutions for business requirements and problem resolution



·        3-5 years of ETL developer experience

·        Experience with developing an ETL lifecycle

·        Experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. - using ETL tools such as SAP BODS, SQL Server Integration Services.          Experience or knowledge in Bigdata related tools like (Spark, Hive, Kafka, Hadoop, Horton works, Python, R) would be good to go

·        Should be able to understand reusability, parameterization, workflow design, etc

·        Experience in understanding complex source system data structures – preferably in Insurance services

·        Experience in Data Analysis, Data Modeling and Data Mart design

·        Strong database development skills like complex SQL queries, complex stored procedures

·        Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities

·        Ability to work with minimal guidance or supervision in a time critical environment.

·         Willingness to travel and work at various customer sites

          Some experience with Data Migration or Integration is an advantage

          PHP or JAVA knowledge is an advantage

          Optional : PAS knowledge (life insurance)

Apply now »