Reporting and DWH Delevoper

Job description

·  Job Description:

·  You will be part of DWH/Reporting team, with responsibilities to design and develop ETL and Data Extraction solutions, monitor production execution, create reports, writing procedures, be in charge of performing code reviews, enhancing standards, tuning performance and maintaining code components. Design, develop, test and maintain Cognos reports.

Technical proficiency:

·  Databases Strong SQL skills: DB2, MS SQL server
·  Databases: Stored procedures
·  Reporting: Cognos (advantage)
·  Reporting: Cognos Cubes (advantage)
·  Reporting: Data Model (advantage)
·  Reporting: experience from banking sector (advantage)
·  BI: IBM DataStage (advantage)
·  BI: Informatica PowerCenter (advantage)
·  ETL tools (advantage), Flink

Your major tasks:

·  Review/write technical specifications and document them as needed.
·  Improving existing reports.
·  Internal testing of modules on integrated environment.
·  Managing/deploying versions of code/reports on multiple environments.
·  Production and project activities
·  Develop and test extraction, transformation, and load processes
·  Develop or maintain code according to reporting specifications
·  Support or enhance the ETL processes to accommodate changes in source systems and new business user requirements.
·  Write SQL to explore source data and data quality issues
·  Evaluate, determine root cause and resolve production issues.
·  Review/write technical specifications and document them as needed.
·  Assist in other related departments as required by business needs.

Skills:

·  Ability to work as a team player, carry out short deadlines and stressful situations
·  Excellent computer literacy (MS-Office).
·  Strong problem-solving ability, conceptual and analytical skills.
·  Responsible person with strong implementation skills.