Job Description

Location : Bangalore; IndiaAbout 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/Project2. Experience in understanding of different ETL tools (min 4) and Advanced transformations, Good in Talend, SAP BODS to support R&D/Project3. To be able to resolve all ETL code and administration issueSecondary skills4. 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 dashboards6. Ability understand, propose data load strategies which improves performance and visualizations7. Ability to performance tune SQL, ETL & Report, UniversesTo understand Sapiens Intelligence Product and support below points1. Understands the Transaction Layer model for all modules2. Universe the Universe Model for all modules3. Should have End to End Sapiens Intelligence knowledge4. Should be able to independently demo or give training for Sapiens Intelligence product.5. Should be an SME in Sapiens Intelligence as a ProductRequirements: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 lifecycle4. 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 go5. Should have experience in developing SAP BO or any Reporting tool knowledge6. 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 documents8. Experience in understanding complex source system data structures - preferably in Insurance services (Insurance preferred)9. Experience in Data Analysis, Data Modeling and Data Mart design10. Strong database development skills like complex SQL queries, complex stored procedures11. 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.

Sapiens International