ETL Developer/Dataware House Developer

Dublin  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

ETL Developer/ETL/Oracle/PL/SQL/Datbase design/Modeling.

My client based in Dublin is looking for an ETL Developer/Datawarehouse Developer to join the organisation for a 6 month contract.

The Integration Developer (ETL) will be responsible for design, development, testing, maintenance, and support of the enterprise Integrations using Oracle Business Intelligence tools and underlying technologies

Additional Responsibilities

To provide excellent service and quality solutions in the development, enhancement and maintenance of Integration Solutions
Ensure a focus on information/data quality by adhering to enterprise data standards such as a common business vocabulary, naming conventions, data standards, transformation rules and related specifications
Significant expertise and experience in the following is required:
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 data modelling 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

Start date
n.a
Duration
6 months
From
SEC Recruitment Ltd
Published at
21.12.2012
Project ID:
464769
Contract type
Freelance
To apply to this project you must log in.
Register