ETL Developer

Barcelona/Sant Cugat Professional

At ERNI we are looking for an experienced ETL Developer to join one of our most important customers from the pharmaceutical industry.

You will DB/ETL support the area of Business Intelligence for BIOPharma, handling a big amount of data.

About the position

Responsibilities

  • Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
  • Extensively worked on the ETL mappings, analysis and documentation of requirements. Solid understanding of concepts and challenges, especially with large data sets.
  • Strong technical skills in SQL and developing Oracle PL/SQL scripts and performance tuning.
  • Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
  • Have command to work with UNIX and in writing Shell scripts for automation.

Requirements

  • Be experienced as an Informatica Power Center developer (Informatica Cloud experience a plus DVDS platform).
  • Good knowledge of Oracle PL/SQL, Linux shell scripting, Integration.
  • Degree in Computer Engineering and a Master on IT Computer Administration.
  • Tools such as Informatica PowerCenter, Microsoft BI all suite, SQL Server, Oracle Warehouse Builder, QlikView, Cognos Transformer (low level).
  • High knowledge of English and Spanish.

Benefits

  • Permanent contract.
  • Hybrid working model, between 4-6 days from office per month.
  • Home Office monthly expenses compensation + extend working set up (ergonomic chair, 2 screens…).
  • Self-managed flexible working hours 40h/week +/- 10%.
  • Friday intensive shift.
  • Private medical insurance for you and a competitive flat race price for your relatives.
  • 100% salary coverage for sick leave.
  • Free language courses: English, Spanish, German.
  • Gym funding.
  • Transportation bonus for non-Barcelona/Madrid city working locations.
  • Re-allocation funding from 1.000€ to 2.000€ depending on the source country.
  • Flexible payroll.
  • Candidates referral program bonus from 1.000€ to 3.000€ depending on the candidate seniority level.
  • Business opportunity referral program bonus from 500€ to 5.000€ depending on the opportunity size and customer.
  • Learning Paths and Technical Coaches in our main Expertise Areas: DevOps, Agile, QA, Cloud, Al, Data, Software Development.
  • Paid certifications in our Expertise Areas: DevOps, Agile, QA, Cloud, Al, Data, Software Development.
  • Rewarded certifications from 200€ to 1.400€ per certification depending on the certification subject level, in addition to the paid exam.
  • On-line and on-demand paid trainings in platforms such as Pluralsight or Udemy on our Expertise Areas.
  • Events paid under request for topics related to our Learning Paths.
  • Internal technical trainings done by our Subject Matter Experts.
  • Internal Soft-Skills trainings with external trainers as main part of our learning curriculum.

About the recruiter

Gonçalves Correia Monica

Email: [email protected]

Trust, Passion, Responsibility and Independence

About us

ERNI was founded in 1994 in Switzerland to develop innovative software for international companies and small to medium­sized enterprises. Today, the ERNI Group has more than 800 employees at 15 locations in 7 countries and continues to grow. Interested?

Sounds interesting?
Apply now!