Контакты

Data Warehouse and Integration Developer

Krakow, Poland

Striving for excellence is in our DNA. Since 1993, we have been helping the world’s leading companies imagine, design, engineer, and deliver software and digital experiences that change the world. We are more than just specialists, we are experts.

DESCRIPTION


Currently we are looking for a Data Warehouse and Integration Developer for our Krakow office to make the team even stronger.

Warehouse and Integration Developer is a key role in the completion of the program, where it is required to build and implement high quality solutions, principally in the Oracle database infrastructure, that are highly performing and operationally complete.

Responsibilities

  • Confirm and complete component specifications in partnership with the business and analyst/QA members;
  • Write, and unit test, SQL and PL/SQL for views, tables, procedures, functions and packages in the Oracle infrastructure;
  • Generate test data and test cases to support Integration testing – notably for non-functional performance testing;
  • Define and implement performance enhancements to ensure solutions are tuning in the Oracle 12c (Exadata) environment – from SIT through to Production;
  • Ensure strong code and data management in Git, with automated deployments;
  • Provide design and architecture insights to enhance the warehousing product – including usage of new integration technologies, and reporting solutions;
  • Establish capabilities in non-core activities: understand the Java/Camel integration solution (FIRE) and reporting solutions (Microstrategy and Coric). Integration teams by their nature must be capable of understanding the broad environment in which they implement solutions;
  • Provide support of test and production environments as required – providing expertise to solve process and/or performance problems in higher environments.

Requirements

  • Intellectual curiosity and a drive to create high quality solutions across a range of technologies and financial products;
  • Oracle DDL and PL/SQL solutions expertise;
  • Good understanding of Oracle indexing strategies, caching configurations and operational constraints;
  • Good understanding of data transfer solutions: FTP, MFT, ETL;
  • Proven unit test creation and execution to support supply of quality solutions;
  • Proven experience in working with geographically distributed teams;
  • Proven capacity to accept challenging assignments and deliver quality solutions on time;
  • Good understanding of financial products and financial accounting principles;
  • Good understanding of business and technology operational procedures in Asset/Fund management environment.

Nice to have

  • Experience in reporting and data integration;
  • Experience in additional technologies: Java; HTML5; JSON; Microstrategy; SimCorp.

We offer

  • Possibility to be involved in an international project (Canada, China, Hong Kong, Mexico, USA, Switzerland, Germany, Sweden, United Kingdom, Russia, Belarus, Ukraine, Hungary, etc.);
  • Language classes (English and Polish);
  • Vast opportunities for self-development: online courses and library, experience exchange with colleagues around the world, partial grant of certification;
  • Career development center;
  • Possibility to take part in both: corporate and startup environment;
  • Possibility to relocate for short and long-term projects;
  • Relocation package for those who relocate to Krakow, Wroclaw, Katowice or Gdansk from other locations;
  • Benefit package (health care, multisport, lunch tickets, petrol vouchers and shopping vouchers, etc.);
  • Fruits on a weekly basis;
  • Sponsored sport activities, E-sport program;
  • We kindly ask you to include the following clause in your application: "Wyrażam zgodę na przetwarzanie danych osobowych zawartych w niniejszym dokumencie do realizacji procesu rekrutacji zgodnie z ustawą z dnia 10 maja 2018 roku o ochronie danych osobowych (Dz. Ustaw z 2018, poz. 1000) oraz zgodnie z Rozporządzeniem Parlamentu Europejskiego i Rady (UE) 2016/679 z dnia 27 kwietnia 2016 r. w sprawie ochrony osób fizycznych w związku z przetwarzaniem danych osobowych i w sprawie swobodnego przepływu takich danych oraz uchylenia dyrektywy 95/46/WE (RODO)";
  • Please note that only selected candidates will be contacted.