ETL Developer jobs in Bangalore at Sapiens Technologies India

ETL Developer

Location: India, Bangalore

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

Requirements :

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

Sapiens International Corporation empowers insurers to succeed in an evolving industry. The company offers digital insurance software platforms, solutions and services for the property and casualty, life, pension and annuity, reinsurance, financial and compliance, workers’ compensation and financial markets. With more than 35 years of experience delivering to over 450 organizations globally, Sapiens has a proven ability to satisfy customers’ core, data and digital requirements.