ETL Developer

ETL Developer - Dublin

CPL Solutions currently have an urgent requirement for an ETL Developer to work a 6 month to 1 year daily rate contract in Dublin. The position entails working for a pharmaceutical giant with European headquarters in Ireland.

KEY SKILLS

- Experience in the design and implementation of ETL processes using Oracle ODI (preferred) or similar ETL tool (eg Informatica, Datastage, OWB etc)
- Strong foundation and understanding of Dimensional Modeling, including familiarity with best practice methodologies such as Inmon and Kimball is highly desirable
- Analysis and design of data Integration solutions
- Core principles around interfaces design
- Understanding of integration transports, FTP etc
- Advanced knowledge of PL/SQL

WORKING KNOWLEDGE AND EXPERIENCE IN THE FOLLOWING AREAS IS ADVANTAGEOUS:

- Core integration principles, for example: guaranteed delivery
- Relational Database Design and Modeling
- Experience of Datamodelling within data model design tools, (Embarcadero preferred)
- Good knowledge of XML and related standards, including: XSD, WSDL, XSLT, XPath, SOAP, etc
- Experience across a range of integration protocols and transports, including: HTTP, Web Services, File & S/FTP, JMS, ODBC/JDBC, Change-data-capture and database replication
- Good understanding of Enterprise Architecture Concepts, including knowledge of enterprise architecture integration patterns, and related core concepts - eg: guaranteed delivery, idempotency, interface contracts, compatibility, re-use, loose coupling, transformation & routing, handshaking, etc
- A strong understanding of designing and building integration solutions at an enterprise level, considering: fault tolerance and recovery, security, transactionality, reconciliation, performance, service monitoring & management, etc...
- Good knowledge of Enterprise Data Model and Master Data management concepts

If you are interested in this position please contact JJ McCarthy or email.