Position: DWH Developer
Company: luxoft
Category: SQL
Experience required: 3y
English level: upper

Responsibilities:

o Review/write technical specifications and document them as needed.
o Design, development and implementation a logical and physical data model
o Design, development and maintenance of ETL processes
o Design data models and model changes based on business processes
o Bug fixing on code and data
o Identification of potential data sources
o Implementation reports in the reporting system and testing
o Improvement of existing reports
o Internal testing of modules on integrated environment
o Checking the quality of the data regarding the technical correctness of the content
o Automation of regular and periodic data controls
o Automation of vendor-supplied data controls on core systems
o Project management and active participation in local and group DWH and BI improvement projects
o Constant auditing of BI & DWH solutions and system performance management
o Data quality management
o Reporting on the status of incidents, problems and requests
o Recommendations for BI and DWH system enhancements

Mandatory Skills:

o Databases: IBM DB2, MS SQL server
o Databases: All objects (Procedures, MQT, Jobs, Tables etc.)
o BI: Informatica PowerCenter
o Reporting: Cognos
o Reporting: Data Model
o BI: IBM DataStage
o FLINK for ETL process
o Integration Services
o Reporting: experience from banking sector (advantage)

Nice-to-Have Skills:

o Experience in Core Banking business processes