Oracle Database Migration Engineer
Miejsce pracy: Łódź / RemoteIn 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.
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)
Requirements:
- Good knowledge of design and development of data warehouse solutions in the Oracle environment (Oracle 12 preferred and PL/SQL)
- Good knowledge of Apex
- Good knowledge of ETL
- Practical experience in 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
Benefits:
- Friendly international environment
- The possibility of language professional training and growth (English and German courses; technical trainings and workshops)
- Stable employment
- Benefits package including: Medical Care Package, Multisport,
- Lunch card
- Employee Pension Scheme (PPE)
- Relax corner where you can recharge your batteries
- Open space office environment