Skip navigation EPAM

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.

Hello. How Can We Help You?


Our Offices