Description
We are looking for accomplished Integration Developer (ETL).
Role details are as follows:
- 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
- Core integration principles, for example: guaranteed delivery
- Core principles around interfaces design
- Understanding of integration transports, FTP etc
- Significant expertise and experience in the following is required:
- Analysis and design of Integration solutions
- Relational Database Design and Modeling
- Advanced knowledge of PL/SQL
- Experience of Data Modeling
- Experience of with Embarcadero would be an advantage
- 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