Skip navigation

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
Learn more about EPAM in Belarus

Equal Employment Opportunity

EPAM Systems, Inc. is an equal opportunity employer.  We recognize the value of diversity and inclusion in creating success for our customers, business partners, shareholders, employees and communities. We are committed to recruiting, hiring, developing and promoting employees without discrimination. As a global employer, this commitment includes complying with all laws in the countries in which we operate. Nevertheless, we believe equal employment practices should not be limited to what the law requires. Equal opportunity and inclusion are essential to motivate, empower and recognize the best in everyone.

At EPAM, employment actions are based on individual qualifications, without regard to race, color, religion, creed, gender, pregnancy status, sexual orientation, gender identity, gender expression, marital or familial status, national origin, ancestry, genetics, age, disability status, veteran status, citizenship status when otherwise legally able to work, or any other characteristic protected by law.

Pay Transparency Non-Discrimination Provision

EPAM will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

Affirmative Action Obligations as a U.S. Government Federal Contractor

As a U.S. federal government contractor, EPAM is committed to meet its affirmative action obligations to make good faith efforts to expand the recruiting pool of women, minorities, individuals with disabilities, and protected veterans through outreach, targeted recruitment, training opportunities and other activities. We affirm this commitment annually in EPAM’s Affirmative Action Plans. The full text of our Affirmative Action Plan for Persons with a Disability and Protected Veterans is available for inspection in the People Operations Department during normal business hours. Email the People Operations Department to schedule an appointment.

Accessibility for Applicants with Disabilities

EPAM is committed to working with and providing reasonable accommodation to individuals with disabilities. If you require an accommodation at any stage of the employment application process, please send an email to the People Operations Department including your name, a detailed description of your requested accommodation, and the best method to contact you. If you have already reviewed a job posting or submitted an application for a job, please include the requisition number. We will assist you and make a determination on your accommodation request on a case-by-case basis.

EEO is the Law. Applicants to and employees of EPAM Systems Inc., are protected under Federal law from discrimination.

EPAM Systems, Inc. participates in eVerify.

Background investigations are required for all new hires as a condition of employment, after the job offer is made. Employment will not begin until EPAM Systems receives and approves the results of the background check.

A day in the life

SALMAN TALAT
Account Manager
Toronto, Canada

IRYNA KOVALENKO
Delivery Manager
Kyiv, Ukraine

JAN MAZUREK 
Senior Business Analyst
Gdansk, Poland

DANIELLA KOROSSY
Project Manager
Budapest, Hungary

MIGUEL MURILLO
Software Engineer
Guadalajara, Mexico

Hello. How Can We Help You?


Our Offices

  • Canada

    • Ottawa

      343 Preston Street,
      ON K1S 1N4, Ottawa
      Canada

      Map
    • Toronto

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

      Map
      F: +1-416-595-1551
  • Mexico

    • Guadalajara

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

      Map
  • United States

    • Newtown, PA

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

      Map
      F: +1-267-759-8989
    • Bellevue, WA

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

      Map
    • Boston, MA

      21 Drydock Avenue,
      Suite 410 W,
      Boston, MA 02210
      USA

      Map
    • Conshohocken, PA

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

      Map
    • Los Angeles, CA

      11601 Wilshire Blvd,
      Suite 350,
      Los Angeles, CA 90025
      USA

      Map
    • New York, NY

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

      Map
      F: +1-267-759-8989
    • Philadelphia, PA

      30 South 15th Street,
      9th Floor,
      Philadelphia, PA 19102
      USA

      Map
    • San Francisco, CA

      222 Kearny Street,
      Suite 308,
      San Francisco, CA 94108
      USA

      Map
    • San Jose, CA

      2055 Gateway Place,
      Suite 510,
      San Jose, CA 95110
      USA

      Map
    • Washington D.C.

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

      Map
  • Australia

  • China

    • Guangzhou

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

      Map
    • 广州

      中国广州市越秀区
      中山六路236号
      越秀新都会大厦中座 23楼 B01室
      邮编510180

      地图
    • Shanghai

      Room B509, 5th Floor,
      48 Weihai Road,
      Huangpu District, Shanghai,
      China 200000

      Map
    • 上海

      上海市黄浦区
      威海路48号
      5楼B509室
      邮编200000

      地图
    • Shenzhen

      3/F, Block 5, Vision Shenzhen Business Park,
      9th Gaoxin South Road, 
      Shenzhen Hi-tech Industrial Park,
      Nanshan District, Shenzhen,
      Guangdong, China 518057

      Map
    • 深圳

      中国广东省深圳市
      南山区高新南九道
      威新软件园5号楼3楼
      邮编518057

      地图
    • Suzhou

      Building 12, Creative Industrial Park,
      328 Xinghu Street,
      Suzhou Industrial Park,
      Suzhou, China 215123

      Map
    • 苏州

      中国江苏省苏州市
      苏州工业园区星湖街328号
      创意产业园内12号楼
      邮编215123

      地图
  • Hong Kong

    • Hong Kong

      26F&17F, The Wellington Tower,
      198 Wellington Street,
      Central, HK

      Map
  • India

    • Bangalore

      Smartworks,  
      Global Technology Park,
      Block C, Outer Ring Rd,
      Adarsh Palm Retreat, Bellandur,
      Bengaluru, Karnataka 560103
      India

      Map
    • Hyderabad

      10, 11 & 12th Floors,
      Salarpuria Sattva Knowledge City,
      Plot No. 2, Phase - 1,
      Survey No. 83/1,
      Raidurgam Village,
      Serilingampally Mandal,
      Hyderabad, Telangana - 500081
      India

      Map
    • Pune

      SmartWork Business Center Pvt Ltd,
      Suite 8, Level 1,
      West Wing, Nyati Unitree,
      Samrat Ashok Road,
      Yerwada, Pune - 411006,
      Maharashtra
      India

      Map
  • Japan

    • Tokyo

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

      Map
      F: +81-03-6880-9201
  • Singapore

    • Singapore

      5 Shenton Way
      UIC Building, #10-01,
      Singapore (068808)

      Map
  • United Arab Emirates

    • Dubai

      EPAM Systems FZ-LLC Dubai Branch
      2307 Arenco Tower, Dubai Media City
      PO Box 501929 Dubai
      United Arab Emirates

      Map