Viennalife Emeklilik ve Hayat A.Ş. - Etl Developer

Responsibilites:

As a ETL Developer you will be responsible to develop and maintain ETL processes to load,cleanse and validate data, review and analyse existing SQL quaries for performance improvement. You will be working with ODI as ETL tool, Oracle 12c as DWH backends, MS SQL server, My SQL,Oracle, google Big Query as source system DB’s. You will be working with Oracle Business Intelligence EE (OBIEE) and Power BI to develop BI reports and dashboards. You will be working with business units to performs tecnical analysis

We are looking for:

• Minimum of 3 years hands-on development of ETL functions
• Minimum of 2 years hands-on development of BI reports and models (OBIEE RPD prefered)
• Minimum of 2 years hands-on tecnical analysis experience
• At least 3 years working experience with data in a financial services environment
• Knowledge of at least one ETL tool such as (ODI prefered),SSIS,
• Strong hands-on SQL experience for the purposes of interrogating data
• Experience with BI reporting tools such as (OBIEE prefered), PowerBI
• Experience of different data modelling paradigms, such as Kimball dimensional models and/or 3NF data modelling approaches for data warehousing
• Good understanding of underlying data sources and data warehousing principles
• Experince with insurance sector is plus

Other Requirements

• Minimum Bachelor’s Degree at related fields
• Good command of the English language
• Excellent analytical and problem solving skills
• Excellent listening, communication, interpersonal and presentation skills
• Experience testing and data quality assurance processes