Senior DWH/BI Developer (Oracle)

  • Minsk, Belarus
Job #: 21262
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 Senior DWH/BI Developer (Oracle) for our Minsk office to make the team even stronger.

Once upon a time (back to 2004) we fell in love with BI. With time (in 2009) this love shaped into BI Solution Practice. At BI SP we do BI, practice BI, rock BI and cover: reporting, data integration and data warehousing, data management, big data, data science and advanced analytics. We help pretty big players from different industries to drive their business:
– telecommunications (some large companies);
– travel (a couple of giants revolutionizing the world);
– retail (again impressive names);
– oil & gas (everybody takes these guys seriously);
– healthcare & life sciences (it can be vital for being and being well);
– media (again global brand);
– financial services (c’mon, you’ve definitely heard about these companies in the news).

We are not only industry – but also technology stack-independent and you can choose among these BI platforms: Microsoft, Oracle, SAP, IBM, Teradata, Informatica, MicroStrategy, Big Data-related techs (Hadoop, Hive, Spark, Kafka, Amazon EMR, etc.). So our BI landscape is extremely diverse and you will also work with Tableau, Talend, TIBCO Spotfire, QlikView, Pentaho, Kalido, etc.

All this is possible due to the culture of sharing experience which is spread inside our local but global EPAM BI community: there are ~380 likeminded (BI) people only in Minsk office to learn from and to teach, to mentor and to be mentored. By the way, we have successfully delivered more than 20 BI projects during the recent year.

Now we are proud to invite YOU: «let it BI» together!

We have a range of DWH/BI projects for ORACLE adepts.

WHAT IS COMMON FOR ALL OF THEM:

– Oracle as the heart of a system;
– Complex BI landscape and large scale. Yes, data totally drive all the decision-making of our big clients.

WHAT IS DIFFERENT:

– Oracle-based DWH can be accompanied by different ETL and BI tools like ODI, Informatica, Pentaho Data Integrator, SAP BODS, Cognos, SAP BO, Tableau, etc.;
– Clients’ data problems are quite typical but every time unique as every business has its own specifics, needs a targeted BI insight to stand out and make a difference on the global market;
– Clients’ mentality and communication style;
– Projects length from 3 months up to 2+ years;
– Team size from 2 up to 50 people.

PROJECT DESCRIPTION


Elias says: On our project we are dealing with a ~100 TB Oracle DWH for a telecom company. Reporting is based on 400+ fact tables, 450+ dimension tables, and various analytical solutions. Now the team is merging two huge equally sized but differently modeled DWHs (as part of a companies’ merger).

Andrei says: What we have is pure DWH/ETL agile development for a large Canadian retailer. What really drives us is an opportunity to work with Exadata V5 on the latest Oracle version 12.1.0.2.

Denis says: Scattered data sources, data quality issues, different business rules across the offices, absence of 360-degree view on their activities – these are only some challenges our pharma customer is facing and we are asked to help with. We are developing the analytical system on the top of a greenfield DWH using contemporary technologies like Oracle 12c In-Memory based on Amazon cloud services and continuous integration. Implementing enterprise level MDM solution using mix of dedicated full-cycle tools and sophisticated data cleansing and matching algorithms: Levenshtein distance, Jaro-Winkler, etc.

Responsibilities

  • Work with technical and business requirements: gather and document, understand and review them
  • Analyze data, generating mockup data
  • Analyze data sources, perform data profiling
  • Communicate with different stakeholders, including both technical and business-oriented people
  • Logical and physical design of the DWH (let’s light stars and melt snowflakes!)
  • Create Dimensional models for presentation area and E-R/Data Vault for backroom
  • Design, implement and optimize ETL/ELT strategies and processes
  • Design and implement Data Marts
  • Design and implement reports, dashboards (optional; depends on a project role)

Requirements

  • Adequate SQL and PL/SQL (at least 2-3 years of persistent SQL coding)
  • Decent understanding of Oracle DB internals
  • Oracle DB modeling – yes, you did it!
  • Performance tuning and optimization
  • Hands-on skill in ETL (proficiency in any ETL tool, e.g. IBM DataStage, Oracle Warehouse Builder, Oracle Data Integrator, Informatica, Pentaho, Talend, etc.)
  • Understanding of Data Warehouse design principles: you know who is Kimball and who is Inmon, what kind of religion they practice
  • Experience with enterprise level analytical software is preferred (OBIEE, Cognos BI, etc.)
  • English: at least Intermediate (B1) level and you feel more or less comfortable to discuss the above-mentioned things in English
  • Proactive life attitude (you are quite initiative, able to take responsibility, not afraid to make decisions on your own)
  • Open-minded (you really want to learn new things and become a better you)
  • Flexible and able to adapt to a changing environment
  • Comprehensive communication skills (you are able to listen to other people and clearly express your own thoughts; yes, we used to work in teams and negotiate quite a lot with each other and customers)

We offer

  • Regular assessments and salary reviews
  • Internal mobility program (relocation to any EPAM office including the EU and the USA)
  • Flexible working schedule
  • Vast opportunities for self-development: free English and German classes, wide range of professional and soft-skills trainings and workshops, etc
  • Extensive social package: free medical care, vaccination and massage, sport programs, family care, etc
  • Impressive amount of benefits and discounts

Здравствуйте, чем мы можем вам помочь?


Наши офисы

  • Армения

    • Ереван

      ул. Мовсес Хоренаци, 15
      Бизнес-центр Elite Plaza,
      0010 Ереван
      Армения

      Карта
      Тел: +374-10-60-0065
    Узнать больше
  • Беларусь

    • Брест

      пр-т Машерова, 6А
      224030 Брест
      Беларусь

      Карта
      Тел: +375-162-52-5268
      Факс: +375-162-50-9888
    • Витебск

      пр-т Строителей, 11а-311
      210032 Витебск
      Беларусь

      Карта
      Тел: +375-17-389-0100, доб. 54433
    • Гомель

      пр-т Речицкий, 80
      246012 Гомель
      Беларусь

      Карта
      Тел: +375-17-389-0100, доб. 54079
      Факс: +375-232-70-50-31
    • Гродно

      ул. Горького, 87Б
      230005 Гродно
      Беларусь

      Карта
      Тел: +375-17-389-0100, доб. 69011
    • Минск

      ул. Академика Купревича, 1-1-110
      220141 Минск
      Беларусь

      Карта
      Тел: +375-17-389-0100
      Факс: +375-17-268-6699
    • Могилев

      ул. Космонавтов, 19-510
      212009 Могилев
      Беларусь

      Карта
      Тел: +375-17-389-0100, доб. 1001
    Узнать больше
  • Казахстан

    • Астана

      ул. Ауэзова, 8
      Бизнес-Центр "Азия",
      010000 Астана
      Казахстан

      Карта
      Тел: +7-7172-475-970
      Факс: +7-7172-475-970
    • Караганда

      ул. Ермекова, 58/3
      100009 Караганда
      Казахстан

      Карта
      Тел: +7-7212-93-01-01
      Факс: +7-7212-93-01-00
    Узнать больше
  • Россия

    Узнать больше
  • Украина

    • Винница

      ул. Оводова, 51
      21000 Винница
      Украина

      Карта
      Тел: +380-432-551-294 +380-432-551-275
      Факс: +380-432-551-293
    • Днепр

      ул. В. Мономаха, 17a
      49000 Днепр
      Украина

      Карта
      Тел: +380-56-790-5651
    • Киев: юридический адрес

      ул. Физкультуры, 28
      03150 Киев
      Украина

      Карта
      Тел: +380-44-390-5457
      Факс: +380-44-390-0861
    • Киев: фактический адрес

      ул. Кудряшова, 14-Б
      03035 Киев, Украина

      Карта
      Тел: +380-44-390-5457
      Факс: +380-44-390-0861
    • Львов

      ул. Е. Степановны, 45
      79018 Львов
      Украина

      Карта
      Тел: +380-32-242-4642
      Факс: +380-44-390-5458
    • Харьков

      ул. Коломенская, 63
      61166 Харьков
      Украина

      Карта
      Тел: +380-57-728-0628
      Факс: +380-57-752 2870
    Узнать больше
  • Австрия

    • Вена

      Nottendorfer Gasse 11,
      1030 Wien
      Austria 

      Карта
    Узнать больше
  • Болгария

    • София

      69 Bulgaria Blvd.,
      Infinity Tower,
      1404 Sofia
      Bulgaria

      Карта
      Тел: +359-700-20-273
    Узнать больше
  • Великобритания

    • Лондон

      114 Middlesex Street,
      London, E1 7HY
      United Kingdom

      Карта
      Тел: +44-203-514-0027
    • Манчестер

      Tower 12,
      18-22 Bridge Street,
      Manchester, M3 3BZ
      United Kingdom

      Карта
      Тел: +44-203-514-0027
    Узнать больше
  • Венгрия

    • Будапешт

      Corvin Offices I.
      Futó street 47-53,
      Budapest, H-1082
      Hungary

      Карта
      Тел: +36-1-327-7400
      Факс: +36-1-577-2384
    • Дебрецен

      Bethlen Street 3-9,
      Debrecen, 4026
      Hungary

      Карта
      Тел: +36-52-999-485 доб. 45050
    • Сегед

      Római Av. 21,
      Szeged, 6723
      Hungary

      Карта
      Тел: +36-62-808-013
      Факс: +36-62-550-655
    Узнать больше
  • Германия

    • Франкфурт-на-Майне

      Mainzer Landstrasse 49/49A, D-60329
      Frankfurt am Main,
      Germany

      Карта
      Тел: +49-69-3085-5074
      Факс: +49-69-3085-5100
    Узнать больше
  • Ирландия

    • Дублин

      Alexandra House,
      The Sweepstakes,
      Ballsbridge, Dublin 4,
      D04 C7H2
      Ireland

      Карта
      Тел: +353-(0)-1-631-9280
    Узнать больше
  • Нидерланды

    • Делфт

      Delftechpark 37j
      2628 XJ Delft
      Netherlands

      Карта
      Тел: +31 20 241 6134
    • Схипхол

      The Base B,
      Evert van de Beekstraat 104,
      1118CN Schiphol
      Netherlands

      Карта
    Узнать больше
  • Польша

    • Варшава

      Al. Jana Pawła II 23,
      Atrium International,
      00-854 Warszawa
      Poland

      Карта
    • Вроцлав

      Ul. Piotra Skargi 1,
      Budynek A,
      50-082 Wrocław
      Poland

      Карта
    • Гданьск

      Al. Grunwaldzka 472
      Olivia Gate,
      80-309 Gdańsk
      Poland

      Карта
    • Краков

      Ul. Bora Komorowskiego
      25C Quattro,
      Budynek C,
      31-476 Kraków
      Poland

      Карта
      Тел: +48-12-222-02-02
    Узнать больше
  • Чехия

    • Прага

      City Tower building
      Hvezdova 2b,
      Prague 4
      Czech Republic

       

      Карта
      Тел: +420 22 888 28 23
    Узнать больше
  • Швейцария

    • Глатпарк

      Boulevard Lilienthal 2,
      8152 Glattpark (Opfikon)
      Switzerland

      Карта
      Тел: +41-43-500-21-49
    Узнать больше
  • Швеция

    • Гетеборг

      Lilla Nygatan 2,
      411-09 Göteborg
      Sweden

      Карта
      Тел: +46-31-146-550
    • Стокгольм

      Kungsbron 1, Entrance E,
      111 22, Stockholm
      Sweden

      Карта
    Узнать больше
  • Канада

    • Оттава

      343 Preston Street,
      ON K1S 1N4, Ottawa
      Canada

      Карта
    • Торонто

      5 Park Home Avenue,
      Suite 400,
      ON M2N 6L4, North York,
      Toronto
      Canada

      Карта
      Тел: +1-416-591-4004
      Факс: +1-416-595-1551
    Узнать больше
  • Мексика

    • Гвадалахара

      Periférico Sur #8110,
      Col. El Mante
      45609 Tlaquepaque,
      Jalisco
      Mexico

      Карта
      Тел: +52-33-462-400-98
    Узнать больше
  • США

    • Ньютаун

      41 University Drive,
      Suite 202,
      Newtown, PA 18940
      USA

      Карта
      Тел: +1-267-759-9000
      Факс: +1-267-759-8989
    • Белвью

      110 110th Ave. NE,
      Suite 310
      Bellevue, WA 98004
      USA

      Карта
    • Вашингтон

      7901 Jones Branch Drive,
      Suite 400,
      McLean, VA 22102
      USA

      Карта
    • Кембридж (Массачусетс)

      One Mifflin Place
      Cambridge, MA 02138
      USA

      Карта
      Тел: +1-267-759-9000
      Факс: +1-267-759-8989
    • Коншохокен (Пенсильвания)

      101 East 8th Ave,
      Suite 201,
      Conshohocken, PA 19428
      USA

      Карта
      Тел: +1-484-382-1300
    • Маунтин-вью

      465 Fairchild Dr,
      Building B, Suite 221,
      Mountain View, CA 94043
      USA

      Карта
    • Нью-Йорк (Нью-Йорк)

      24 West 25th Street,
      New York, NY 10010
      USA

      Карта
      Тел: +1-267-759-9000
      Факс: +1-267-759-8989
    • Филадельфия (Пенсильвания)

      777 Appletree Street,
      Philadelphia, PA 19106
      USA

      Карта
    Узнать больше
  • Австралия

    • Сидней

      31 Highgate Cct
      Kellyville NSW 2155

      Карта
      Тел: +61-28-310-82-72
    Узнать больше
  • Гонконг

    • Гонконг

      198 Wellington Street,
      17F, Central
      Hong Kong

      Карта
      Тел: +852-5808-6018
    Узнать больше
  • Индия

    • Пуна

      Level 6,
      Pentagon Tower P-2,
      Magarpatta City,
      Hadapsar,
      Pune - 411013,
      Maharashtra
      India

      Карта
      Тел: +91-20-40-147-833
    • Хайдарабад

      North wing,
      JVP Building, Plot No. 5,
      Software Units Layout
      Madhapur,
      Hyderabad - 500081
      India

      Карта
      Тел: +91-40-47979900
    Узнать больше
  • Китай

    • Гуанчжоу

      Unit B01, 23/F
      Yuexiuxinduhui Building
      No. 236, 6th Zhongshan Road
      Yuexiu District
      510180 Guangzhou, China

      Карта
    • Сучжоу

      18F, Phase 3
      Science Plaza
      1355 Jinjihu Avenue
      Suzhou Industrial Park
      215021 Suzhou, China

      Карта
    • Шанхай

      Unit 704, Block C
      No. 668 East Beijing Road
      Huangpu District
      200001 Shanghai, China

      Карта
    • Шэньчжэнь

      Vision Shenzhen Business Park
      No. 9 Gaoxin 9th South Road
      Building 5, Floor 3
      Shenzhen Hi-Tech Industrial Park
      Nanshan District
      518057 Shenzhen
      China

      Карта
      Тел: +86-755-36899008
    Узнать больше
  • ОАЭ

    • Дубай

      EPAM Systems FZ-LLC
      Dubai Branch,
      Building 16, Office 241,
      Dubai Internet City,
      PO Box 501929, Dubai
      United Arab Emirates

      Карта
      Тел: +971-4-568-3569
    Узнать больше
  • Сингапур

    • Сингапур

      6 Raffles Quay
      #16-01,
      Singapore 048580

      Карта
      Тел: +65-6812-7843
      Факс: +65-6812-7889
    Узнать больше
  • Япония

    • Токио

      Floor 1-10-11
      Shibadaimon Centre Building 10th
      Shibadaimon Minato-ku
      Tokyo 105-0012
      Japan

      Карта
      Тел: +81-03-6880-9198
      Факс: +81-03-6880-9201
    Узнать больше