Job: ETL/Data Warehouse Consultant

Distinct Partners are a new opening for a ETL/Data Warehouse Consultant.

Following a period of growth, we are now looking for experienced ETL professionals to join our consultancy team. If you are looking for a challenge in management consultancy and believe that you have the qualities to succeed in a dynamic and high growth consultancy environment, then we would love to hear from you.

Expertise Required:

• Data Integration skills (at least one of the following)
• Proprietary: Informatica, SAS Data Integration Studio, IBM Data Stage, Oracle.
• Open Source: Talend, Postgres, My SQL, CUDA, Python.
• Strong querying , data analysis and data flow mapping skills (must)
• Data quality skills – checks, standardisation, house holding etc (understanding)
• Data architecture skills (understanding)
• data modelling (normalisation, referential integrity etc)
• dimension modelling (dimensions, facts, SCDs etc
• XML scripting and open source data integration skills (strong plus)
• Database/ETL performance tuning and programming skills

Full details can be found at

http://www.linkedin.com/jobs?viewJob=&jobId=1556819&svfId=822045&goback=%2Emid_I2774654840*42

If you would like to apply for the job you can email your CV to

Gina Cassidy   gina.cassidy@distinctpartners.com

and mention you heard about the job from me

My Blog & others

Over the past few years I have been contributing on Data Mining and Oracle Data Miner topics on the BI-Quotient blog

http://www.business-intelligence-quotient.com/

Over the past few months I have decided to expand my blog postings to include all the things I’m currently doing or things that I find interesting. The main theme will be ‘Data is King’

The new blog will include posts on the following topics:

• Oracle
• Oracle Data Miner
• Data Mining
• Data Management
• My research
• Database Design
• and generally anything else that I find interesting and relating to Data.

This is where this blog come into its own. This will be my main blog going forward. It will contain all my posts, including a copy of these that I post on the BI-Quotient blog

Deputy Editor for Oracle Scene (June edition)

Today I got a phone call from Jennifer from the UKOUG office asking me would I be interested in helping out with some (minor) editing of 4 articles for the June edition of Oracle Scene.

I will also have an article in this edition of Oracle Scene (a 5 page spread).

I’ve had a quick look through the 4 articles and they are an interesting bunch of articles.

Oracle Scene will be holding elections over the coming months for a more longer term deputy editor. This will go out to the user community for a public vote. I might put might name forward for this.

VirtaThon–Online Confernce July

Yesterday I received an email telling me that my presentation submission for VirtaThon (Virtual Conference for the Oracle, Java & MySQL Communities).

The presentation is titled, Getting Started with Oracle Data Miner 11G R2.

I would really like to give an online demo of the tools or even to be able to show a view of the demo, but it looks like I may have to do it with good old Powerpoint.

Recent ODM activity

Over the past couple of weeks I’ve been a little bit busy with some Oracle Data Miner 11gR2 related activities. These include

• Writing an article called Oracle Data Miner Comes of Age for submission to Oracle Scene, the UKOUG quarterly magazine. I was told on 20th April that my article was accepted and will be in the June edition
• The call for presentations opened for the annual UKOUG conference in Birmingham in December. I submitted a presentation which will be based on the article in Oracle Scene.
• I submitted 2 presentations to Oracle Open World in October. But funding might be a problem here. I’ve asked the ODM development group to see if they could sponsor some of the costs. One presentation is on Oracle Data Miner. The second is on
• I also submitted a presentation to an online (virtual) Oracle conference called VirtaThon, again on Oracle Data Miner.

Some other things that I have planned are

• Create two videos for the Oracle Scene article. The first video is a short intro to the article. The plan is to have this on the UKOUG website to promote the article. The second video will be based on the article, covering the material and the demo in the article
• Create a video on creating an ODM repository and getting started with ODM
• Create a video on removing the ODM repository
• Create a video on saving/exporting a DM model from ODM
• Write an article on what Oracle products can be used throughout the Data Mining LifeCycle (CRISP-DM). Hopefully I will submit this for the autumn edition of Oracle Scene.
• Get all the documentation available on the data manipulation stage in the new ODM tool and write an article based on this, produce a video of it, etc

All of this to be finished by the middle of June.

So I have a busy few weeks ahead of me.

Oracle Data Miner 11g R2 – New Features

There are many new features in the new tool and these can be grouped under the following headings:

Data Exploration

: The first step of every data mining project involves investigating the data to try to learn from the data, gather some initial information and investigate if there are any patterns in the data

Workflow interface

: This gives the user a more intuitive way to work with the tool and with the overall process of data mining. It allows for the repeated rerunning of the data modelling process without having to input and define each step again. You had to do this in the previous version of the tool

Generate multiple models at the same time

: This is one of the major improvements in the tool. It allows you to create models using each of the algorithms available for each data mining techniques, in one step, instead of repeatedly defining each in the pervious version of the tool.

Graphical representations of models

: Another major new feature. The tool now produces Decision Trees and Clusters graphically. With the Decisions Trees we can now see on the screen how the tree looks and then to investigate the different branches of it to see how the tree was built. We can also see what rules were generated to create these branches.

Evaluation of all the developed models

: Another major new feature. In the previous version of the tool you were presented with a set of evaluation diagrams and measures for each model. You were not able to see all the results on one graph and you had to resort to having multiple windows open at the same time to try to compare the results. Now we can get the evaluation measures and graphs for all the models on the one set of graphs. This allows a data miner to concentrate on determining the most appropriate model to use.

Each of these new features really deserve a post by themselves to illustrate their new capabilities. These posts will follow over the coming weeks.

Brendan

---