ETL Developer

Sapiens is on the lookout for a Developer (ETL) to become a key player in our Bangalore team. If you're a seasoned ETL pro and ready to take your career to new heights with an established, globally successful company, this role could be the perfect fit.

Location: Bangalore

Working Model: Our flexible work arrangement combines both remote and in-office work, optimizing flexibility and productivity.

This position will be part of Sapiens’, for more information about it, click here: https://sapiens.com/solutions/life-and-pension-software/

What you’ll do:

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.Use AI-assisted tools (e.g., GitHub Copilot) to accelerate ETL development, debugging, and optimization

3. Experience in understanding of different ETL tools (min 4) and Advanced transformations, Good in Talend

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

5. Ability to resolve complex Reporting challenges.

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

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

8. 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.

· 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 be able to Automate data validation, cleansing, and transformation processes using AI-based approaches

· 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

· 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.

About Sapiens

Sapiens is a global leader in the insurance industry, delivering its award-winning, cloud-based SaaS insurance platform to over 600 customers in more than 30 countries. Sapiens’ platform offers pre-integrated, low-code capabilities to accelerate customers’ digital transformation. With more than 40 years of industry expertise, Sapiens has a highly professional team of over 5,000 employees globally. For More information visit us on www.sapiens.com.

Sapiens is an equal opportunity employer. We value diversity and strive to create an inclusive work environment that embraces individuals from diverse backgrounds.

Disclaimer : Sapiens India does not authorise any third parties to release employment offers or conduct recruitment drives via a third party. Hence, beware of inauthentic and fraudulent job offers or recruitment drives from any individuals or websites purporting to represent Sapiens . Further, Sapiens does not charge any fee or other emoluments for any reason (including without limitation, visa fees) or seek compensation from educational institutions to participate in recruitment events. Accordingly, please check the authenticity of any such offers before acting on them and where acted upon, you do so at your own risk. Sapiens shall neither be responsible for honouring or making good the promises made by fraudulent third parties, nor for any monetary or any other loss incurred by the aggrieved individual or educational institution.

In the event that you come across any fraudulent activities in the name of Sapiens , please feel free report the incident at sapiens to [email protected].