Location: 

Bratislava, BL, SK

 

Oracle Data Warehouse Engineer 


About Swiss Re

The Swiss Re Group is one of the world’s leading providers of reinsurance, insurance and other forms of insurance-based risk transfer, working to make the world more resilient. It anticipates and manages risk – from natural catastrophes to climate change, from ageing populations to cybercrime. The aim of the Swiss Re Group is to enable society to thrive and progress, creating new opportunities and solutions for its clients. Headquartered in Zurich, Switzerland, where it was founded in 1863, the Swiss Re Group operates through a network of around 80 offices globally. It is organised into three Business Units, each with a distinct strategy and set of objectives contributing to the Group’s overall mission.

 

About the team

Our data warehouse is one of several warehouses developed and operated in our Group Data Warehouse unit. The information scope of the warehouse is Group IT and serves IT Executives to in decision-making for the IT department. Do you share our real passion for high quality information products that have high exposure and wide usage?

 

Our team is organized as an agile DevOps team. Team collaboration, continuous feedback and people over process is our DNA. We work together on improvement activities, tool evaluations, prototyping and hackathons to which you also chip in. We together develop, extend and rewrite our tool chain to deliver more and faster value to our customers. Do you love to work in a team that always challenges itself on how to become better?

 

About the role

We are the Swiss Re data warehouse team and seek to extend our team with an additional Oracle Data Warehouse Engineer. He or she is responsible for the data acquisition and information exploitation, so that we as a team successfully deliver information products to our customers.

 

The engineer develops, inspects and tests delivered data, executes reconciliations, coordinates deployments for releases, actively increases data quality in the warehouse and consults the business system developers on data quality improvements. The new team member will become the key person for a good collaboration with the business application team.

 

We work in an agile DevOps setup. We emphasize team work and always strive to improve. The engineer is actively contributing to deployment & test automation.

 

Our Oracle Data Warehouse Engineer...

  • Develops & maintains the data load workflows of our data warehouse based on Oracle 12c and Informatica Power-center.
  • Uses our in-house developed code generators and deployment automations, which accelerates our time to market and release frequency.
  • Develops, tests and deploys data-marts and delivery views with advanced database PL/SQL and software development skills.
  • Tunes and optimizes load performance.
  • Collaborates and interacts with source system developers and reporting developers.
  • Builds data marts and information delivery views for customers
  • Uses (or is able to learn) programming languages like Python, Java, Groovy, Bash and deployment/testing tools like Bamboo, Gradle Ansible, Puppet, Chef, Maven, Gradle to increase our level of automation
  • Is delivering reliable, high quality information items as contribution to our team that delivers frequent data warehouse.

 

About you

  • You hold a bachelors or master's degree in a technical field, preferably Information Technology or you have experience in the area of data warehousing or database development in your previous jobs.
  • You have a minimum 3-5 year experience with Oracle Data Warehouses and you have built load processes or used ETL tools like Informatica Power Center, Kettle/Pentaho.
  • You have proven knowledge of relational databases (Oracle, Microsoft SQL Server) and database development tools like Toad for Oracle, SQLPlus, Sybase Power Designer, PL/SQL).
  • You are experienced with software development tool chains like Source Control (GitHub, SVN, TFS), Continuous Integration (Jenkins, Bamboo), Testing (DBUnit, JUnit), Build Tools (Gradle, Ansible, Maven).
  • You love working with data and information. You have strong analytical skill, you have an eye for detail and you can work with complex data constellations.
  • You enjoy to identify issues, offer a workaround and implement a problem resolutions to satisfy a customers concern.
  • You are a great teammate, a good communicator and you love collaborating within the team and various other teams spread around the globe.
  • You are proficient in English. Speaking German is a plus.

 

 

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

 

Minimum base salary for this job from 1700 EUR gross/month/full time. Our offer to you may be higher based on your skills and experience and will include additional rewards and benefits.We are required by law to disclose basic wage component (minimum salary) for the advertised positions. We carefully consider your professional competencies, qualifications and experience in our compensation package and/or when offering you other positions. Our compensation philosophy is to pay fairly, also considering market situation and the value employees may bring to Swiss Re.

 

We provide feedback to all candidates via email. If you have not heard back from us, please check your spam folder.


Keywords:  
Reference Code: 86499