Project description
In your role as a Regular Oracle Engineer you will be responsible for understanding data flows, integrating and developing the databases in order to integrate two separated banking systems.
Main 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
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
Other
- Shower
- Chill room
- Integration events