Oracle Database Migration Engineer

Commerzbank - Centrum Technologii Cyfrowych w Polsce
Mid
Online interview
Employment contract
Łódź
Paid vacation
26

Project description

In your role as a Oracle Database Migration Engineer you will be responsible for understanding data flows, integrating and developing the databases in order to integrate two separated banking systems.

Remote work (until the pandemic situation is clarified)

Your tasks

  • Optimalization and tuning of existing queries, including analytical one
  • Analysing data structures and data flows
  • Preparing migration scripts, mainly from DB2 to Oracle data warehouses
  • Supporting migration process
  • Developing new features (in later stages of project)

Who we're looking for?

What we expect from you:

  • Good knowledge of design and development of data warehouse solutions in the Oracle environment (Oracle 12 preferred and PL/SQL)
  • Good knowledge of Unix/Linux
  • Familiarity with Agile mindset / DevOps Setup
  • Readiness for On-Call Service


Nice to have:

  • DB2
  • Experience with data migration projects
  • Experience with large data warehouse, including analytical queries and tuning of corresponding queries
  • Oracle Data Integrator (ODI)
  • SAP BI software
  • Star Schemas, Data Vault and Slow Changing Dimensions


Foreign language skills:

  • English B2 level mandatory
  • German optional

Skills
Oracle Database
Unix or Linux
Toolset
Laptop
PC
Additional monitor
Headphones
Personal container
Phone
Operating system
Work environment
Tech supervisor
Open space
Flexible working hours
7 - 19
Office hours
Healthcare
  • Healthcare package
  • Healthcare package for families
Leisure package
  • Leisure package
  • Leisure package for families
Bonuses
  • Financial bonus
Kitchen
  • Cold beverages
  • Hot beverages
  • Lunches
Traning
  • Conferences
  • Trainings
Parking
  • Car parking
  • Bicycle parking
Relocation
  • Language courses
  • Visa Services
Other
  • Shower
  • Chill room
  • Integration events

Our company

Commerzbank - Centrum Technologii Cyfrowych w Polsce

Łódź >350
Tech skills
  • Java
  • C++
  • .NET

Check out similar job offers