Developer-ETL

Designing, and developing of core components/services that are flexible, extensible, multi-tier, scalable, high-performance and reliable applications of an advanced complex software system, called ALIS both in R&D and Delivery.

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.

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

What to Have for this position.

Must have Skills.

• 3 - 5 years of IT experience.

• 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 etc,.)

• Should have experience with developing a complete DWH ETL lifecycle

• 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

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

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

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

• Experience in understanding complex source system data structures preferably in Insurance services (Insurance preferred)

• 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 across the globe.