Software Engineer Software Engineer …

in London, United Kingdom
Permanent, Full time
Last application, 08 May 21
in London, United Kingdom
Permanent, Full time
Last application, 08 May 21
Job Reference #228597BR
Your team
You'll be working in the Banker Portal Business Intelligence development team in London. Our role is to provide data integration, analytics and critical reporting to senior management of the UBS Investment Banking business. You will be working very closely with key business sponsors and expected to respond quickly and professionally to varying business requests. Business management uses our products for daily financial and performance management, regulatory reporting and strategic planning.

Your expertise
You must have:
- Strong experience in designing real time (or close to real time) complex ETL solutions.
- Excellent hands-on experience in developing ETL solutions using Informatica PowerCenter (9.x and above)
- Experience to methodically identify the performance bottleneck in ETL flows and come up with appropriate solutions
- In-depth knowledge of Informatica version management and release management tools
- Strong experience in dimensional modelling for new applications and to extend or modify an existing application
- Experience in using data modelling tools (e.g. ERWIN)
- Excellent knowledge of Oracle SQL including analytic functions (Oracle 11g2 and above)
- A clear understanding of Oracle features related to data warehouse, like star transformation, bitmap indexes, partition exchange etc.
- Experience in automating batch jobs using scheduling tools (e.g. Autosys)
- Knowledge in basic UNIX scripting to support ETL process and batch scheduling
- Skill on identifying and setting up appropriate data transfer mechanisms between systems (e.g. setting up SFTP, HTTPS etc.)

Preferred and desired skills include:
- Oracle PL/SQL programming
- Experience in Oracle 12c or Oracle 19c
- Experience in Informatica PowerCenter 10.x
- Knowledge in any BI reporting tool. Preferably Business Object - BI 4.x
- Experience using GitLab
- Experience with Azure Cloud

About us
Expert advice. Wealth management. Investment banking. Asset management. Retail banking in Switzerland. And all the support functions. That's what we do. And we do it for private and institutional clients as well as corporations around the world.

We are about 60,000 employees in all major financial centers, in more than 50 countries. Do you want to be one of us?

Join us
We're a truly global, collaborative and friendly group of people. Having a diverse, inclusive and respectful workplace is important to us. And we support your career development, internal mobility and work-life balance. If this sounds interesting, apply now.

Disclaimer / Policy Statements
UBS is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills and experiences within our workforce.
Company Overview

UBS works with individuals, families, institutions, and corporations around the world to help answer some of life's questions – whether through award winning wealth management advisory, investment banking and asset management expertise, or private and corporate banking services in Switzerland.
We're a team of more than 66,000 colleagues, collaborating across all major financial centers in 50 countries. We strive for excellence in everything we do, and this has awarded us recognition across our businesses. We offer a collaborative, international and diverse working environment that rewards passion, commitment and success – and are regularly recognized as an attractive employer.

Together for the goals
#TOGETHERBAND raises awareness about the 17 United Nations Sustainable Development Goals for 2030 through 17 uniquely colored bracelets. Each pack contains two individually packaged bands: one to wear and one to share so you can spread the word about what goal matters most to you and give someone else the opportunity to do the same. The production and money raised from the sales of these bands will help fight injustices such as poverty and gender inequality as well as climate change and unfair labor.

Right now, #TOGETHERBAND is helping to support emergency COVID-19 relief. For the month of April, our partners at #TOGETHERBAND have created TOGETHER FUND to help fight the pandemic and provide aid to those who need it most.

UBS logo
More Jobs Like This
See more jobs