Developer (ETL)

Location : Bangalore; India

About Sapiens :

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 700+ 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: www.sapiens.com.

Responsibilities:

Primary:

1. Good understanding in the ETL Advanced concepts and administration activities to support R&D/Project

2. Experience in understanding of different ETL tools (min 4) and Advanced transformations, Good in Talend, SAP BODS to support R&D/Project

3. To be able to resolve all ETL code and administration issue

Secondary skills

4. Ability to resolve complex Reporting challenges.

5. Ability to create full-fledged dashboards with story boards/lines, drill down, linking etc.; design tables, views or datamarts to support these dashboards

6. Ability understand, propose data load strategies which improves performance and visualizations

7. Ability to performance tune SQL, ETL & Report, Universes

To understand Sapiens Intelligence Product and support below points

1. Understands the Transaction Layer model for all modules

2. Universe the Universe Model for all modules

3. Should have End to End Sapiens Intelligence knowledge

4. Should be able to independently demo or give training for Sapiens Intelligence product.

5. Should be an SME in Sapiens Intelligence as a Product

Requirements:

1.           3- 5 years of IT experience .

2.           Should have experience to understand the Advanced concepts of Insurance and has good command over at least all Business / Functional Areas (like NB, claims, Finance et al)

3.           Should have experience with developing a complete DWH ETL lifecycle

4.           Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. - using ETL tools such as  Talend, BODS, SSIS  etc. Experience or knowledge in Bigdata related tools like (Spark, Hive, Kafka, Hadoop,  Horton works, Python, R) would be good to go

5.           Should have experience in developing SAP BO or any Reporting tool knowledge

6.           Should be able to implement reusability, parameterization, workflow design, etc.

7.           Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and Low/High level design documents

8.           Experience in understanding complex source system data structures – preferably in Insurance services (Insurance preferred)

9.           Experience in Data Analysis, Data Modeling and Data Mart design

10.         Strong database development skills like complex SQL queries, complex stored procedures

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

12.         Ability to work with minimal guidance or supervision in a time critical environm ent.

13.         Willingness to travel and work at various customer sites across the globe.